I was adding a new external collection to my Adalo project. It is the first time I added an external collection that had some API values that were zero or empty strings.
When I setup the external collection and did the “Run Test” I saw all the JSON items, even though some of them had a zero value or empty value.
Any field that had a zero or empty value was not added to the External Collection list on the left navigation area of Adalo. Because of this, those fields could not be used in the app.
The solution for me was to prefill the returned API data with some value so it shows up in your External Collection list.
Let me know if I may have messed something up or if this is expected behavior. Thanks!