How to reference a value in the JSON parser node

I am trying to use the JSON parser node but don't know how to access the results. The node successfully parses the result of a web run node. Here is the output I am getting:

JSONParser210_jsonText = [{"input_index":0,"candidate_index":0,"delivery_line_1":"61 Pine Knob Dr","last_line":"South Windsor CT 06074-2330","delivery_point_barcode":"060742330618","components":{"primary_number":"61","street_name":"Pine Knob","street_suffix":"Dr","city_name":"South Windsor","default_city_name":"South Windsor","state_abbreviation":"CT","zipcode":"06074","plus4_code":"2330","delivery_point":"61","delivery_point_check_digit":"8"},"metadata":{"record_type":"S","zip_type":"Standard","county_fips":"09003","county_name":"Hartford","carrier_route":"C001","congressional_district":"01","rdi":"Residential","elot_sequence":"0065","elot_sort":"D","latitude":41.83491,"longitude":-72.51136,"precision":"Zip9","time_zone":"Eastern","utc_offset":-5,"dst":true},"analysis":{"dpv_match_code":"Y","dpv_footnotes":"AABB","dpv_cmra":"N","dpv_vacant":"N","active":"Y","footnotes":"N#U#"}}]

How would I reference the delivery line_1 value? I have tried using the variable Path: JSONParser210_jsonVar["delivery_line_1"] but that is undefined. I have also tried assigning a variable del_ln_1 in the output tab but that is also undefined.

Find more posts tagged with

Process Automation (IPA) - General Discussions

Accepted answers

All comments

chris-mccullough

Is it because its 3 deep?

Try:

JSONParser210_jsonVar["input_index"]["candidate_index"] ["delivery_line_1"]

CEB Call 5-20-2021.pdf

john-miller

Are you on version 11? If this is your first JSON attempt, you should check out the JournalEntryApproval process flow that Infor Delivers, they have a JSON Parser to pull all of the Key fields out of the Journal Entry.

unknown

We are on version 10.

unknown

I have resolved this by not using the JSON parser node. I am taking the results of the webrun node and using it in JSON.parse() call.

unknown

To use the JSON Parser node...

Create a json file with all the possible fields being captured, like the data you have above. Select the output tab and Load that as the sample document.

Then select variables button and assign variables to the values. The great part is there is no mapping to the JSON path needed.

All that is needed is the variable name for each key field you want to capture and the Node will create the path definition for you.

input data:

Variables defined here on the output tab

Copyright © 2025 Infor. All rights reserved.