We are having an issue with a simple call to gather data related to the COVID pandemic in India.
The straightforward fetch action sends a ‘GET’ request to https://api.covid19india.org/data.json with nothing in the body.
When executing this call in Postman, it comes back with a Status 200 (ok), returning a list of daily case and death count updates. We tested the call in Bubble’s API connector, and it too returns a successful call.
However, when trying to set up the call for an external collection in Adalo, it throws an error saying “Could not find any results. Are you sure the results key is correct?” This is despite the Full Response actually showing the data as being successfully returned. (See Screenshot below)
Would really appreciate any ideas as to how we may be able to rectify this issue. It’s working fine using other tools, so at a bit of a brick wall.
What I’m about to say is important for anyone using external collections
When I look at the url for the API (https://api.covid19india.org/data.json), I see that “cases_time_series” is at the top so I put that under the results key for the get-all and it worked!
@bhanu@James_App_Maker I want to sort the list in such a way that starting record’s date should be “recent date”. What formula I need to implement there?
({date} = ‘’)
We can see that the date is “6 March 2020”. If i scroll down to the end, “17 May 2021” will appear. So what i need is that the “17 May 2021” data should appear on the top. So that the users should not have to scroll to see the recent cases.
