Bubble won't recognise list returned in API call?

[calum.rr.scott]

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!

[Jici]

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]

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