Bubble won't recognise list returned in API call?

calum.rr.scott · 2025-01-26T10:18:16.544Z

Hi Everyone, I have an API call which returns a list of items. I want to run a backend workflow on the list to create separate DB items. I’ve done this before and it worked well but this time Bubble won’t recognise the data correctly?

As you can see the GET request returns a list of aggregated statistics by month. I want to create a DB item for each month with the stats. The call works but when I am in the workflow Bubble recognises I want to run the API workflow on a list, then when I select the matching thing from the dropdown it doesn’t recognise they are the same?

Any idea why this is happening? Thanks in advance!

Screenshot 2025-01-26 at 10.14.271632×1366 194 KB

Screenshot 2025-01-26 at 10.13.59824×412 92.6 KB

Screenshot 2025-01-26 at 10.14.35912×704 46.4 KB

Jici · 2025-01-26T14:37:20.467Z

The problem is the payload that doesn’t return a list but a dictionnaries of data. This is not something Bubble yandle because the key will be different for each item. In JSON, an array is encoded between square brackets (that Bubble will detect). There’s a lot of tipic about that case. Take time to search forum about dictionnaries and you may find solutions.

calum.rr.scott · 2025-01-27T07:17:27.846Z

Aha thanks Jici I will look for another solution to parse the data thank you