Parsing JSON Nested Nodes

[ebarr]

I have a large json file to parse that contains (I believe) nested information. It is a JSON file from our ecommerce site and has order information, along with line item information. I was basing my information on the following: Parsing and Pivoting JSON - #2 by mlauber71

But I’m having issues with getting each line item to accompany each line item. I’m uploading the workflow and I’ve masked all of the information for confidentiality.
sample json.knwf (126.9 KB)

For the three records I’ve included in the sample, it appears I have the correct output for the summary data:

But the last field isn’t as expected:

for the line items, the goal is to get them on separate lines for each record, but corresponding to the proper summary row of data (that is correct):

Any help would be great appreciated for best practice in getting this data into a tabular format. I can pivot/unpivot where necessary.

Thank you.

[McReady]

Looks like each row has reference data which cannot be extracted just 1:1. Think about a database where you have reference integrety within different tables. But that’s not a big deal.
First of all, you’ve already identified you’re retrieving JSON data from the JSON parsing. Just make sure within the JSON PATH your result type is JSON again and not string like displayed in the 2nd image.
Then add another JSON PATH node behind the first one and extract the JSON data you need. Maybe you have to repeat this multiple times. Or - depending on your goal - you have to extract the data to a separate tables like the reference integrety in e.g. a SQL database.