API external database - list shows only last record

[dmol]

I have integrated an external database via API. When testing, all data in the array is displayed cleanly.

When I want to display this database in a list, only the last record from the array is displayed and repeats up to the number of the actual count.

Can I change anything? Or can adalo not handle it?

[dilon_perera]

Hi @dmol,

These posts might help you!

API Result Display on Repeat

I finally got it @Ben! I just moved the book_id at the top. Maybe its a primary key position of some sort. It’s working now! [image] Result: [image]

External Collection API Setup Error & Repeating Values

Hey @Kostya, Have you tried this: Resolution to Repeating Values More info here: API Result Display on Repeat - #12 by joeyology In your Collections drag the field you’re displaying to the top of the fields in the External Collection (there is a screenshot in my initial post). In my case I was using “Name”. Now see above: “Name is unique but it wasn’t at the top by default so you need to drag it to the top manually. This could be an ID or similar in your case” This fixed it for me. I hope t…

Thank you

[dmol]

Hey @dilon_perera

Thank you for your quick reply.
That was my first thought, too. Unfortunately, putting the “Order_ID” at the top of the list did nothing.

adalo shows only the last order ID 903.