The AirTable API (a more efficient way to integrate AirTable with Thunkable)

Tutorials and DIY Guides
, , ,
41

Every table in Thunkable has a column named ID. This column is hidden and it contains the Row ID

See this example

image
image734×154 10.1 KB

1 Like
42

OK, thanks muneer !!!

43

Good morning. First of all I would like to thank those who gave me really efficient advice in this post. Now I have another problem, sorting the outgoing data from the query, I did some testing, but the app fails. Do any of you have any good advice for me?
I seem to understand that you can sort data both in the URL field or in queryParameters. True?

Su post BIS4
Su post BIS41300×365 50.9 KB

44

Hey @Dario_Cappello

Check out how easy it is to filter and sort your response!

Here I filter responses by Age and Sex,

Then i sort the responses by Age.

So easy!

FHtxERRWUAc91Hi
FHtxERRWUAc91Hi1282×1132 124 KB

4 Likes
45

Thank’s Jared

1 Like
46

Hi, are there any problems with the AirTable API? I can no longer insert records in the table. Can anyone give it a try?

47

Hi all
Jared, why “QueryParameters” block starts with “AND”?
And other question: what is the meaning of the ‘0’ in the “sort” statement?
Grazie!!

48

At the time (I’m not sure anymore) the AND() informed the api that you were sending more than 1 filter and that it was an “and” condition between the contained constraints. (Ie return only records that satisfy filter 1 and filter 2 vs an OR condition)

This has to do with the way they expect you to pass the sort. Essentially this is how a list of 0-indexed sort options get passed

1 Like