maheshp93 | 2023-10-26 23:44:50 UTC | #1
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 "ExternalIdTHNK__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", "Addressr": { "attributes": { "type": "Addressc", "url": "/services/data/v53.0/sobjects/Address_c/a3z0p000000e1AsAAI" }, "PostalCode_c": "2010" }, "Account": { "attributes": { "type": "Account", "url": "/services/data/v53.0/sobjects/Account/0010p00001IVy1aAAD" }, "PrimaryBillingAddress_r": { "attributes": { "type": "Address_c", "url": "/services/data/v53.0/sobjects/Address_c/a3z0p000000e1AsAAI" }, "PostalCode_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", "ExternalIdTHNK__c": "60473658", "Account": { "attributes": { "type": "Account", "url": "/services/data/v53.0/sobjects/Account/0010p00001IVy1aAAD" }, "Type": "Household" } }, "Billing_System__c": "THNK" } ] }
SimonBrown | 2023-10-27 17:12:39 UTC | #2
If you are going to pass the json object, rather than using the data action to parse for you then Genesys recently updated architect with lots of JSON functions.
Info page with detail and examples.
system | 2023-11-27 17:12:43 UTC | #3
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.
This post was migrated from the old Developer Forum.
ref: 22746