Transforming API data

Queries and Resources
1

Hi,
I am new to retool and trying to transform options chain data that I'm getting through TD API.

Currently, anything past the primary nest, does not show.

essentially I'm trying to get all of the properties inside of the nested array "3720.0". There are 199 more arrays nested in "2023-03-24:1"

I have gone through documentation and searched stackExchange for similar examples, but not having any luck. Could you please help me?

Thanks,
Greg

2

Hey @quonster!

What would you like the output to look like?

If you'd like to just flatten everything into a single array you might try something like

{{ Object.values(apiQuery.data.putExpDateMap["2023-03-24:1"]).flat() }}

or

{{ _.flatten(_.values(apiQuery.data.putExpDateMap["2023-03-24:1"])) }}

Curious to know more about exactly what you're looking for though!