Displaying External API Data in Repeating Group, Response from External API isn't nested

Hey all,

I’m making a call to an external api to get a list of orders. I’m able to successfully make the call and it is returning the data I need… but it isn’t showing up in a nested json format.

When I call the api and my response is a list of objects, it combines all of the properties together as if the response was a single object. Is there something I need to set up in the API connector? here is the current configuration (pretty simple):

As you can see from the screenshot below, I’m able to call the API and retrieve a response as seen in the debugger panel, however it’s not in the format I need to dynamically display a list of orders and the repeating group itself is stuck loading.

After reading through the forum, I haven’t come across other topics with this issue and all of the screenshots I see look like they have nested objects the way I need them, however it’s not working that way for me.

Anyone have some insight on what the issue is or what i’m doing wrong?

It would be very much appreciated! Thanks!

Matt

Hi Matt, what is your repeating group’s Type & Source set to?

Have you tried initializing the call in the API connector without any order values so that you can get a full list instead of a filtered one? If you’re able to initialize with a list response, that might help.

Edit - I see the source in your screenshot - I just want to see more of your RG setup.

Are you sure this is what gets returned? The screenshot shows an object containing another object, not containing a list.

You might have to set the response type as “Text” and get the whole thing as a single JSON blob, then do your own processing on it.

1 Like

Yeah, but that doesn’t work. List in a list of complex objects goes into the same API Ghetto as a list of complex objects. Don’t get the OP’s hopes up.

Thanks to everyone who gave suggestions.

How I ended up fixing the problem was to just approach it differently altogether.

My original idea was to display a list of the orders in a repeating group by calling an external api. The API I was calling was specifically for retrieving multiple orders. When I tried to display the api response, I ran into the issue described at the beginning of the thread.

Here’s what I did instead:
Instead of trying to call the data from an external API every time the page loads, I decided to source the list of orders from my apps data. The only problem with this is that the orders wouldn’t be up to date, so I created a refresh button for a user to call the api for a single order and refresh the details of a single cell’s order.

I think this is better not only cause it works, but I think it’s less resource intensive too.

1 Like