Adalo List not showing proper Result

[jibranmusa]

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

[jibranmusa]

@dilon_perera

[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

[jibranmusa]

sure

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

thsi is the query

[jibranmusa]

[dilon_perera]

Drag the zip_code property to top like this :

And the result :

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

[jibranmusa]

let me try

[jibranmusa]

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

[dilon_perera]

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

[jibranmusa]

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

[dilon_perera]

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

[jibranmusa]

got it adalo lists needs the first column unique to iterate

[emanuele1964]

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.