JSON array Follow

0
Avatar
Aivo Rautam

I’m using Input Data Format type JASON. If I include data in just one record the integration works fine. But if I use two or more records, I receive the following message: 

Input data file 'FinalLabel.txt' contains data not in correct JSONVariables format. Details: Invalid object passed in, ':' or '}' expected. (2):

{[{"prodOrderNo": "","prodRelease": "","partNo": "02003361"},
{"prodOrderNo": "","prodRelease": "","partNo": "02003361"}]}

Any ideas on what is causing my error?

3 comments

0
Avatar
Jasper Wen
Moderator
Comment actions Permalink

Currently, Integration doesn't natively read in JSON arrays or multiple objects/records out of the box. It only supports the format of one JSON object and value pairs. You would have do some type of data transformation to get in a data format Integration can understand such as a text delimited data format and multiple records. There is a feature request on this already submitted to better handle and natively support JSON formatting.

0
Avatar
Ruben Arslanian
Comment actions Permalink

This answer is from 2016 - does the Integration Builder support JSON arrays in 2019R6?

0
Avatar
Nicolas Bykov
Comment actions Permalink

I'm also interested...We need to get a lebel with list of goods on it. Passing data through JSON. Please give feedback! 

Please sign in to leave a comment.