Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Issue with Array in JSON

edited Sep 16, 2019 4:17PM in Integration 7 comments

Summary

Arrays not being handled correctly with in Json request

Content

Hello,

I hope you can help me with the following. I have an integration where I need to push Opportunities to JDEdwars via standard REST adapter.

The Json request have some section that are arrays, but is creating some issues: formActions, gridRowInsertEvents.

{
    "token": "****",
    "formServiceAction": "U",
    "deviceName": "CRM",
    "formName": "****",
    "formActions": [{
            "gridAction": {
                "gridID": "1",
                "gridRowInsertEvents": [{
                    "gridColumnEvents": [{
                            "command": "SetGridCellValue",
                            "value": "175516",
                            "columnID": "14",
                            "columnDescription": "CRM Row Id"
                        },
.....
                    ]
                }
            ]
            }
        },
        {
            "command": "DoAction",
            "controlID": "12"
        }
    ]
}
 

 The issue comes when OIC builds the request and send it over to JDE. It ignores the [] for the formActions section and gridRowInsertEvents sections, and also the {} that enclose command and controlID are also ignored. This is how OIC is building that request:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!