External database list give me just one record

Get Help External Collections, Custom Actions & Collections
1

Hi all,

I’ve seen this problem several times on this forum, but none of those solutions seen to be working.

I’m trying to get make a external data list, but it doesn’t work right. When I try to add some items to the list it only gives me one record.

fd11fcb005c44351dfb3092135a7d9956a2da172_2_550x1000.jpeg
fd11fcb005c44351dfb3092135a7d9956a2da172_2_550x1000.jpeg550×1000 67.2 KB

I’ve send my IPA to Spreadsheets just to see if there is more information and it shows that it has to be.

58a82d43182f0a137557e8b57d43dcad5c0f8f8f_2_1380x734
58a82d43182f0a137557e8b57d43dcad5c0f8f8f_2_1380x7341380×734 429 KB

Here the URL:

805033d1a679f166a3adda44b5027d90145e6504_2_1070x1000
805033d1a679f166a3adda44b5027d90145e6504_2_1070x10001070×1000 45 KB

The whole API is already send to this one: API only one record

Ive spend alot of hours to fix this, hope slmeone is able to help…

2

Hi @niels,

I decided to comment here as well as this might be beneficial for the community.

In short: I guess the reason for this problem is that API structures its response in a way that Adalo can’t understand it.

As I see, what you need is the values from “responses” (each response represents an entry in the collection). However, API returns “responses” as an array without unique IDs.

See the example from airtable:

Screenshot 2022-02-12 at 13.15.33
Screenshot 2022-02-12 at 13.15.331106×804 77.7 KB

As you can see each array element has an ID entry in it.

Response of Football API looks differently. You need “response” as a primary key, and array is there:

Screenshot 2022-02-12 at 13.22.28
Screenshot 2022-02-12 at 13.22.281152×844 74.7 KB

Inside this array you have “fixture”, “league”, “teams”, “goals”, “score”

Screenshot 2022-02-12 at 13.23.39
Screenshot 2022-02-12 at 13.23.391084×992 94.8 KB

Screenshot 2022-02-12 at 13.24.31
Screenshot 2022-02-12 at 13.24.311116×1204 80.4 KB

However, there is no any unique ID in each “response”. According to my knowledge Adalo can’t handle such responses in external collections. There were several posts on forum about that - can’t find them right now.

As for the workarounds I can suggest:

  • if this is collection will be used like “static” (no data changes), you can try to download it from the source to some place like airtable, and then connect it to Adalo
  • there might be a possibility to use some 3rd party service like Integromat to form responses recognizeable by Adalo. Though this could be costly.

May be someone else can suggest more ideas.

Hope this helps.

Best regards, Victor.

2 Likes
3

This was an incredibly helpful explanation @Victor I just posted about the same issue, but it seems like I need to find another solution. Thank you.

1 Like