Hi,
We are trying to import data into a Data Source for use with the ETL from our BMC CMDB. We need to do this in JSON format and it needs to be paginated due to the size of the transfer. However, BMC is returning the JSON in a format that is not supported by ServiceNow and causing a DataStream to fail in processing the JSON. The JSON returned is in the following format:
[
{
"kind": "...",
"count": 1,
"offset": 0,
"results": [
{
...
},
{
...
}
]
}
]
Is there anyway to intercept the JSON in a DataStream to remove the outer square brackets before the data is processed to put it into a format ServiceNow supports? Or is there another way of importing the JSON, with pagination, to allow it to be passed to ETL?
