Hello @cpearson4772!
This is a pretty intricate data structure, I would recommend joining our office hours on Discord where we can better help you grab the right data to put into your table.
Office hours are 11am-Noon PST Tuesday and Thursday!
It sounds like you need to do logic similar to a nested loop to iterate through the orders via value.data[i] first and then do a second loop through each product in the order later on within .data.body[j].
The i/index value will be useful for the first variable to tell the loop where to key in.
For the second inner loop I would recommend triggering another workflow, passing in the nested data of value.data[i].custom_field['0'].data.body
Then in a loop block in the second workflow you can pass in i or index on the smaller chunk of data you are sending over and iterating through.
I might not have gotten the placement right on where to put in the [i]
but I would also recommend feeding the data structure into ChatGPT and asking it how you can loop through the order and the products within order!
This way you can break up the loops and iterations, as it is tricky to do back to back loop blocks in one single workflow.
It is much easier to loop through the array of orders in the first workflow and then pass in an array of all the products and their info within an order to another workflow, where you will just need to use i to tell each database post which array in the array you are looping through to grab data from.
You might have already seen it but this user posted in the forum about trying to do back to back loops and got a helpful answer on dividing up logic/looping.
Hope this can help! ![]()