Parse JSON - REST API

JJG_SNOW
Mega Guru

I have a scripted REST API which is accepting JSON payloads. I am having trouble parsing the JSON however, as there are multiple objects. How can I parse this correctly?

 

JSON being received:

 

{
   "records":[
      {
         "u_asset_tag":"101",
         "u_serial_num":"1234",
         "u_unspc_code":"1111111"
      },
      {
         "u_asset_tag":"102",
         "u_serial_num":"5678",
         "u_unspc_code":"2222222"
      },
      {
         "u_asset_tag":"103",
         "u_serial_num":"9012",
         "u_unspc_code":"3333333"
      }
   ]
}

 

 

Scripted REST API:

        var requestBody = request.body.data;
        var parsedJSON = new JSONParser();
        var parsed = parsedJSON.parse(requestBody.records);
        

        for (var i = 0; i < parsed.length; i++) {

            var assetTag = parsed[i].u_asset_tag;

            var serialNum = parsed[i].u_serial_number;

            var comCode = parsed[i].u_unspc_code;
        }

 

1 ACCEPTED SOLUTION

JJG_SNOW
Mega Guru

Solved: 

        var requestBody = request.body.data;
        var records = requestBody.records;

        for (var i = 0; i < records.length; i++) {

            var assetTag = records[i].u_asset_tag;

            var serialNum = records[i].u_serial_number;

            var comCode = records[i].u_unspc_code;

        }

 

View solution in original post

1 REPLY 1

JJG_SNOW
Mega Guru

Solved: 

        var requestBody = request.body.data;
        var records = requestBody.records;

        for (var i = 0; i < records.length; i++) {

            var assetTag = records[i].u_asset_tag;

            var serialNum = records[i].u_serial_number;

            var comCode = records[i].u_unspc_code;

        }