Parse Nested JSON Array and objects

triciav · ‎12-09-2019

I have a RestMessage that I am getting back the JSON as below,

How do I parse this to get the SerialNumbers?

Thank you

{
"Devices":[
{
"EasIds":{
"EasId":[
"XXPI8PIKDD4LP5ID797BVKSGKO",
"XXFDA7DB295B406C9933FA634B190B77"
]
},
"Udid":"00000000-000A6C940E30802E",
"SerialNumber":"xxxxxxxxx",

vkachineni · ‎12-09-2019

your obj is the data

//try the following code

var json = new global.JSON();
var obj = json.decode(responseBody);
gs.info("TRICIA Json " + obj.Devices[0].SerialNumber);
for(i = 0; i<= obj.Devices.length-1; i++)
{
gs.info(obj.Devices[i].SerialNumber);
}

View solution in original post

Ankur Bawiskar · ‎12-09-2019

Hi,

it seems incomplete json. can you share complete one?

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

vkachineni · ‎12-09-2019

//try. Although the JSON is incomplete, i am guessing the first serial number will be.

object.Devices[0].SerialNumber;

triciav · ‎12-09-2019

This is the JSON, There could be more than 1 SerialNumber devices so I would need to loop through 
to get each one
{
 "Devices":[
 {
 "EasIds":{
 "EasId":[
 "XXPI8PIKDD4LP5ID797BVKSGKO",
 "XXFDA7DB295B406C9933FA634B190B77"
 ]
 },
 "Udid":"00008030-000A6C940E30802E",
 "SerialNumber":"XXXXXXX",
 "MacAddress":"XXX71841C1C",
 "Imei":"311895101261879",
 "EasId":"",
 "AssetNumber":"0000000-000A6C940E30802E",
 "DeviceFriendlyName":"jdoe iPhone iOS 13.2.3 N70Q",
 "LocationGroupId":{
 "Id":{
 "Value":98072
 },
 "Uuid":"18726ff8-6a4c-4b4f-989c-7ef45e7b0082",
 "Name":"Production"
 },
 "LocationGroupName":"Production",
 "UserId":{
 "Id":{
 "Value":195275
 },
 "Uuid":"17fb71b7-79dd-4888-b712-e1216835cce9",
 "Name":"Jane Doe"
 },
 "UserName":"jdoe",
 "DataProtectionStatus":0,
 "UserEmailAddress":"jdoe@example.com",
 "Ownership":"E",
 "PlatformId":{
 "Id":{
 "Value":2
 },
 "Name":"Apple"
 },
 "Platform":"Apple",
 "ModelId":{
 "Id":{
 "Value":1
 },
 "Name":"iPhone 11 Pro Max (512 GB Midnight Green)"
 },
 "Model":"iPhone 11 Pro Max (512 GB Midnight Green)",
 "OperatingSystem":"13.2.3",
 "PhoneNumber":"+12229991111",
 "LastSeen":"2019-12-06T18:42:07.303",
 "EnrollmentStatus":"Enrolled",
 "ComplianceStatus":"Compliant",
 "CompromisedStatus":false,
 "LastEnrolledOn":"2019-10-01T13:15:12.527",
 "LastComplianceCheckOn":"2019-12-04T18:12:56.440",
 "LastCompromisedCheckOn":"2019-12-06T18:26:02.153",
 "IsSupervised":false,
 "VirtualMemory":0,
 "DeviceCapacity":506008895488.0,
 "AvailableDeviceCapacity":200861466624.0,
 "IsDeviceDNDEnabled":false,
 "IsDeviceLocatorEnabled":false,
 "IsCloudBackupEnabled":false,
 "IsActivationLockEnabled":true,
 "IsNetworkTethered":false,
 "BatteryLevel":"85 %",
 "IsRoaming":false,
 "SystemIntegrityProtectionEnabled":false,
 "ProcessorArchitecture":0,
 "TotalPhysicalMemory":0,
 "AvailablePhysicalMemory":0,
 "DeviceCellularNetworkInfo":[
 {
 "CarrierName":"",
 "CardId":"11114103272344405762",
 "PhoneNumber":"+12229991111

",
 "DeviceMCC":{
 "SIMMCC":"",
 "CurrentMCC":""
 },
 "IsRoaming":false
 }
 ],
 "EnrollmentUserUuid":"00000000-0000-0000-0000-000000000000",
 "Id":{
 "Value":655723
 },
 "Uuid":"1115d471-aed3-4d11-b324-22e6c35775d5"
 }
 ],
 "Page":0,
 "PageSize":500,
 "Total":1
}

triciav · ‎12-09-2019

vkachineni,

That worked so I need to figure out how to loop through to get all the SerialNumbers

How can I achieve that

Thank you