Try to get data from nested arrays

How To
1

Hi

I would appreciate any help on this issue which has been challenging.

I have data extracted from a PDF using PDFCo which contains data of a Fedex invoice. See attached image. Each regular bill from Fedex contains details of different consignments to various destinations - this example shows 5 consignments listed er ‘lineItems’

The aim is to get all the details for each consignment into a row on an Excel spreadsheet.

I have it working collecting the main invoice details, and then iterating the ‘lineItems’ array, I can get all the details for each consignment, BUT within each consignment (lineItem), there is a sub- array called ‘other_charges’ which contains 3 or 4 items, and it is this data I can’t seem to ‘pluck’ out…to store in the spreadsheet row.

PDFCo output
PDFCo output1024×1606 184 KB

2

You can try to create two iterators and at the end create an aggregator over all of them.
This question is similar to the following: Nested JSON data