An easy way to identify the paths that you will need is to use.....
https://jsonpathfinder.com/
Paste your JSON in there and you can click on the record to see the path that you will need. It is also a nice way of understanding the structure. Your "Loop Jsonpath query" for iterating over the elements there will be.....
Yes, you can do this. But this JSON is rather strangely formatted if the first address in the destination addresses array corresponds to the first elements array's complex type. I presume that there can also be other origin_addresses (given that is an array as well). In order to extract this information you will need to know exactly which array elements you are looking at. So I would use 4 tExtractJSONFields components. 1 for each array. I would extract the "destination_addresses" elements and number them. I would then extract the "origin_addresses" elements and number them. Then I would (in another SubJob) extract the "rows" elements, number them and then pass the data to another tExtractJSONFields component and extract the "elements" elements and number them. This will give you a link between origins, destinations and origin-->destination metrics using the numbering. So, if you have 4 destinations and 4 origins, to find the distance between destination 3 and origin 1, you would look at "rows" 1 and "elements" 3 for the time and distance.
An easy way to identify the paths that you will need is to use.....
https://jsonpathfinder.com/
Paste your JSON in there and you can click on the record to see the path that you will need. It is also a nice way of understanding the structure. Your "Loop Jsonpath query" for iterating over the elements there will be.....
