Hi,
I'm creating new data action that returns a JSON object (with nested arrays and objects) as a response. I want to parse through this JSON object in Architect and get the values.
What JSON functions can be used to parse the nested JSON values?
e.g: How do I get the value of "External_Id_THNK__c" from the below JSON object?
{
"totalSize": 1,
"done": true,
"records": [
{
"attributes": {
"type": "Order",
"url": "/services/data/v53.0/sobjects/Order/8010p000004a6PNAAY"
},
"Id": "8010p000004a6PNAAY",
"AccountId": "0010p00001IVy1aAAD",
"BillToContactId": "0030p00000hUvqyAAC",
"Address__r": {
"attributes": {
"type": "Address__c",
"url": "/services/data/v53.0/sobjects/Address__c/a3z0p000000e1AsAAI"
},
"Postal_Code__c": "2010"
},
"Account": {
"attributes": {
"type": "Account",
"url": "/services/data/v53.0/sobjects/Account/0010p00001IVy1aAAD"
},
"Primary_Billing_Address__r": {
"attributes": {
"type": "Address__c",
"url": "/services/data/v53.0/sobjects/Address__c/a3z0p000000e1AsAAI"
},
"Postal_Code__c": "2010"
},
"IsCustomerPortal": true
},
"BillToContact": {
"attributes": {
"type": "Contact",
"url": "/services/data/v53.0/sobjects/Contact/0030p00000hUvqyAAC"
},
"FirstName": "Test",
"LastName": "ivr four",
"Email": "testingnews01+130714@gmail.com",
"MobilePhone": "6140000000",
"External_Id_THNK__c": "60473658",
"Account": {
"attributes": {
"type": "Account",
"url": "/services/data/v53.0/sobjects/Account/0010p00001IVy1aAAD"
},
"Type": "Household"
}
},
"Billing_System__c": "THNK"
}
]
}