External API Results keu

[sambarendsma]

Can’t seem to find any results key that work. tried ALOT but no luck, i’ve read dozens of other posts but the solutions didn’t work sadly. so i hope that a genius here knows how to help me . i tried to give as much info as possible in the attachments.

API URL: http://ergast.com/api/f1/current/last/results.json
API WEBSITE: https://web.postman.co/workspace/My-Workspace~91b87f48-05bb-4b3a-85c6-e26fc2313662/collection/27331480-620a433e-361f-4a4d-9de8-f7c63a8fe4b6

i have tried MRData, RaceTable, Races, Results and a lot more in diffrent orders and combinations

[theadaloguy]

Did using a results key, for example MRData give you no results at all? Or just not the fields you need?

[theadaloguy]

Ok I’ve got it working but you’d have to go through Xano first to restructure it.

The problem is You’ve got objects within array within objects within array etc. It’s nested a lot.

On Xano i had to go to MRData → Result → Races.

Then I got the first entry of the array (there’s only one race returned from this endpoint) and saved as a Variable.

Then I went to → Results within that.

This leaves me with an endpoint I can call from Adalo. Please try yourself by adding to your Adalo as an external collection:

https://x8ki-letl-twmt.n7.xano.io/api:MFcCUsvH/Races

No query parameters or results keys needed. I’ll just be keeping this endpoint temporarily so you can see how the data might come out if you did something similar yourself.

[sambarendsma]

@theadaloguy

Did using a results key, for example MRData give you no results at all? Or just not the fields you need?

@sambarendsma

i have tried MRData, RaceTable, Races, Results and a lot more in diffrent orders and combinations

it always gives me results it just doesn’t let me save it.

[sambarendsma]

amazing!! i will try that right away. only problem is that i have no idea of what xano is or how to set it up. but i will try fo sure. many thanks

[sambarendsma]

how did you get the output of the Xano API/endpoint to be in Json? i followed some tutorials and i am now at the point where i have a xano link like yours wich will output the data from “races” but it is in html so i now get that error in adalo.

EDIT: nevermind i just had to republish the endpoint. YOU MADE MY DAY

[theadaloguy]

That’s great to hear Sam! Good luck with the app. Remember Xano free plan with be rate limited, I think to 20 requests per minute. You may need a paid Xano account when your app is live.

[sambarendsma]

Yes the rate limit is 10 per 20 seconds. Is there a way to limit the API call rate in adalo so xano doesn’t go into a time out for 20 seconds? Sorry for all the questions, i really try to figure things out myself but I have gone into unknown territory for many forums and tutorials on the internet.

[theadaloguy]

I don’t see an easy way to rate limit on Adalo side. Doesn’t matter if you hit the rate limit while you’re developing, but you’ll need to have no rate limit for an app with live users.