Adalo List not showing proper Result

I am using an External collection and showing it as list but the problem is it is not showing all the results. It just showing one result or repeating the same result over and over again.

Whats the issue.

My Result looks like this

[
{
“category”: “Locksmiths”,
“city”: “Rockford”,
“state”: “IL”,
“zip_code”: “61109”,
“county”: “Winnebago”,
“count”: “23”
},
{
“category”: “Locksmiths”,
“city”: “Loves Park”,
“state”: “IL”,
“zip_code”: “61111”,
“county”: “Winnebago”,
“count”: “7”
},
{
“category”: “Locksmiths”,
“city”: “South Beloit”,
“state”: “IL”,
“zip_code”: “61080”,
“county”: “Winnebago”,
“count”: “8”
},
{
“category”: “Locksmiths”,
“city”: “Winnebago”,
“state”: “IL”,
“zip_code”: “61088”,
“county”: “Winnebago”,
“count”: “4”
},
{
“category”: “Locksmiths”,
“city”: “Rockton”,
“state”: “IL”,
“zip_code”: “61072”,
“county”: “Winnebago”,
“count”: “4”
},
{
“category”: “Locksmiths”,
“city”: “Machesney Park”,
“state”: “IL”,
“zip_code”: “61115”,
“county”: “Winnebago”,
“count”: “2”
},
{
“category”: “Locksmiths”,
“city”: “Cherry Valley”,
“state”: “IL”,
“zip_code”: “61016”,
“county”: “Winnebago”,
“count”: “1”
}
]

@Flawless

@dilon_perera

Hi @jibranmusa,

Is it possible to share a screenshot of the external collection with the properties? Is it possible to share the API details with us?

Thank you

sure

https://www.callsexchange.net/adalo/main/ads-demands?category=Locksmiths&county=Winnebago&state=IL

thsi is the query

image

Drag the zip_code property to top like this :

image

And the result :

Issue discussed here : API Result Display on Repeat - #12 by joeyology

1 Like

let me try

worked but why it behaved like that? Any specific reason?

1 Like

I guess it’s due to some uniqueness of the response. A unique property has to be in the top. In this case if you look all the zip_codes are unique and no problem!

Read here : API Result Display on Repeat - #12 by joeyology

the easiest solution will be to assign a serial number the first column

I believe the city property will also works because it’s unique!

image

got it adalo lists needs the first column unique to iterate

Unfortunately this is not the case, or rather, it is not always the case.
I entered as the first field the primary key of the table referenced in SQL, but the result is always the same, that is, the doubling of the rows displayed.