In my OIC3 integration, I’m receiving data from a data source that returns a JSON response like this:
{
"success": "true",
"message": "Query executed successfully. Rows returned: 2",
"instance": "C62rsrbxEfCMaqvG4us5Fw",
"data": "[{\"NAME\":\"Abdul\",\"DEPARTMENT\":\"Integration\"},{\"NAME\":\"John1\",\"DEPARTMENT\":\"IT\"}]"
}
or
{
"success": "true",
"message": "Query executed successfully. Rows returned: 2",
"instance": "g1xAabbxEfCDkhFjl--tuA",
"data": "[{\"EXTERNAL_ID\":\"6905802162263\",\"INTEGRATION_STATUS\":\"Failed\"},{\"EXTERNAL_ID\":\"006gL00000C05acQAB\",\"INTEGRATION_STATUS\":\"Failed\"}]"
}
The data field is always a string containing a dynamic array of objects, but the keys differ each time (e.g., NAME, EXTERNAL_ID, etc.).
I just need to loop through each object in this array, regardless of the field names.
I tried using Stage File action, but it requires a defined output structure, which doesn’t work since my keys are dynamic.
Is there a way in OIC3 to:
- Parse or treat the
data field as a repeatable element (array),
- And loop through each object without defining a fixed schema?
I don’t need to access specific fields — just iterate through each object as a string or generic JSON element.