Possible to retrieve nested data from external API?

So I’m trying to pull in a list of monitors from Best Buy’s product API. The issue I am finding is that the most important data appears to be “nested” (I believe that is the term) and therefore not accessable via Bubble’s API Connector. You can see that when I run the query via Best Buy’s builder, I can see all the important data such as screen size, refresh rate, resolution, etc. falls under the “Details” object.

But when I initialize the call via Bubble, it only appears to show the first item, then mentions some type of list.

Is there a way to retrieve this data so that I can save all of those values to my monitor list in my DB? Haven’t seen any strong documentation of examples of this being accomplished.

Bubvbe show an example, but if you look, it day that is a list. So you have access to all item in array. When you use Data and not action, you can also save this to a field of the list type like if this was a DB

If I read that correctly, sounds like you are saying it is possible, just need to access it a different way. Did you mean to say that Bubble shows how to do this? Do you have documentation or an example you could point me to? All I’ve seemed to find is old posts from the founder saying it’s not possible, but that was years ago.

In the API connector, Bubble show you the first item in the list as an example, but all items in the list are parsed. You can use this in a RG, you can set the RG to the type of the list. Only if you are using Data type and not action. You can access the api data using Get data from API instead of an action in a wf.

So are you saying Bubble can show me that nested data only in a RG or is there a way I can save that data to my database? By chance a place where Bubble documents this that you know of? I can’t seem to find anything on it.

There’s a lot of topic on that in forum. Like I told you, when you set the type to DATA, Bubble will create a thing type of the API Call. You can store that into a single field. You an also use WF to create DB thing for each item in list. But if you can avoid that, its better to call the API when you need it.