Using output from JSON Parser node

Hi everyone,

I'm just getting started with API calls and using the JSON Parser node, and I'm trying to determine how to reference the output 'jsonVar' values from the JSON Parser node. I have what I think is a simple example of using an API call to get a list of customers from a third party application. In the third party application, I only have two customers currently, and just to get started, I'm trying to get the value of the 'AddressLine1' variable from the second customer.

Below is my JSON Parser variable list, followed by the jsonText that is returned from the JSON Parser node. How would I qualify the jsonVar to point it to the second customer to get the value of 'AddressLine1'? I've tried various combinations of JSONParser9570_jsonVar["MainContact"]["Address"]["AddressLine1"]["value"], and tried putting subscripts in, but not having any luck.

JSONParser9570_jsonText = [{"id":"33b4dd36-be0c-ec11-a814-000d3a9f3a6f","rowNumber":1,"note":{"value":""},"CustomerClass":{"value":"STANDARD"},"CustomerID":{"value":"001234"},"CustomerName":{"value":"Mike's Excavating"},"MainContact":{"id":"55f18d56-a58f-4492-b0ed-f0eeae0b62a1","rowNumber":1,"note":null,"Address":{"id":"fb3574a1-cb31-4827-bb33-c8b4c7f727c2","rowNumber":1,"note":null,"AddressLine1":{"value":"45678 W Diggers Ave"},"AddressLine2":{},"City":{"value":"Green Bay"},"PostalCode":{"value":"54311"},"State":{"value":"WI"},"custom":{}},"Email":{"value":"mfrelich@gbp.com"},"Phone1":{"value":"9204301245"},"custom":{}},"custom":{}},{"id":"c55c055d-7367-ec11-a816-000d3a9f3a6f","rowNumber":2,"note":{"value":""},"CustomerClass":{"value":"STANDARD"},"CustomerID":{"value":"002345"},"CustomerName":{"value":"MAF Test Customer"},"MainContact":{"id":"f58a898f-eada-4fb8-9dda-4e11d997f9b6","rowNumber":1,"note":null,"Address":{"id":"8f1345ee-3977-443f-8afa-24c585f4de23","rowNumber":1,"note":null,"AddressLine1":{"value":"Test Address 1"},"AddressLine2":{"value":"Test Address 2"},"City":{},"PostalCode":{},"State":{},"custom":{}},"Email":{"value":"mfameree@gbp.com"},"Phone1":{},"custom":{}},"custom":{}}]

Thanks in advance,

Mike Fameree

0712131256598360.doc

Find more posts tagged with

Process Automation (IPA) - General Discussions

Accepted answers

All comments

unknown

Hi! Are you sure you're getting both records in your result before you parse? When I do something like that for multiple records it gives me a # sign to indicate that there are multiple. Immediately following the JSON Parser, I do a For Each loop passing in the JSON Object array. But you could just put in an Index number where the # sign is to get the correct record if you don't need to loop though all records.

(click on image to make it bigger)

For Each:

Thanks,

David

unknown

Thanks much David for the response and screen prints! The jsonText is coming back with both of my two customer records. How do you get the JSON Parser to set the # sign for multiple records? I uploaded a Sample Document with an example customer record that I copied in from a Postman example. Below was the first record of the sample document I copied in (there were multiple records in the file), but it didn't return the # and doesn't seem to know that there are multiple records:

{
"id": "e43d3c1c-8765-e411-a267-e06995c86014",
"rowNumber": 1,
"note": {
"value": ""
},
"CustomerClass": {
"value": "DEFAULT"
},
"CustomerID": {
"value": "C000000001"
},
"CustomerName": {
"value": "Jersey Central Office Equip"
},
"MainContact": {
"id": "6bd3dda1-a5f0-41b5-865c-c30e0f0bf6ab",
"rowNumber": 1,
"note": null,
"Address": {
"id": "055a40ce-bfd2-4a08-a97f-3371729a0e29",
"rowNumber": 1,
"note": null,
"AddressLine1": {
"value": "1 De Villiers & Harrison St, 11-th Flr."
},
"AddressLine2": {},
"City": {
"value": "Johannesburg"
},
"PostalCode": {},
"State": {},
"custom": {}
},
"Email": {
"value": "jersey-equip@mail.con"
},
"Phone1": {
"value": "+1 (777) 283-0414"
},
"custom": {}
},
"custom": {}
}

richard-lyons

Mike,

It looks like the results are coming back to you in an array. I have not been able to get the JSON Parser to work in this situation.

However, I have a couple of sample flows that do seem to work with your sample data.

If you give me an email address, I will send them to you.

Richard

unknown

Hi Mike,

This is my JSON Sample file:

{
data: [
{
AdjustedStartDate: "1980-01-01",
Employee: 999999,
UnionCode: "UNIT D",
YEARS_OF_SERVICE: 41,
Position: 123456
}
],
"errorMessage": " ",
"error": false,
"count": 0
}

I believe that because I have an outer "data" wrapper (with brackets), that gives me the array that gives me the # sign as a placeholder for an index. My JSON parser just references "data". When I select Set Variable, it gives me what was in my earlier screenshot with the # sign. Looking at your JSON Sample, you don't have an outside wrapper. Maybe try putting a data: [] wrapper around your whole set of code.

Thanks,

David

unknown

Thanks much Richard! My email address is mfameree@gbp.com. If you could email me sample flows, I'd really appreciate it!

unknown

Thanks much David, looks like adding the 'data' wrapper did give me the # sign as the placeholder for the index. See screen shot below. However, I'm still having trouble referencing a value using the index. I tried setting a String variable equal to JSONParser9570_jsonVar["data"][1]["CustomerName"], and also tried JSONParser9570_jsonVar["data"][1]["CustomerName"]["value"], and it throws an error message: Error: org.mozilla.javascript.EcmaError: TypeError: Cannot read property "1" from undefined (threadScript#1). Is there something wrong with my syntax?

richard-lyons

I sent you an email with the 4 flow samples I have.

Copyright © 2025 Infor. All rights reserved.