How do I use REST API to retrieve data from linked tables in one API call?

[GabyTango]

Hi, I am trying to use REST API to retrieve data from a base that includes both the records from a primary table and the linked records from a related table in a single request.  Is there a way to obtain this data in just one API call?

Know that in SQL, a single query can fetch data from multiple tables in one request, but Airtable has me stumped. 

Any guidance is much appreciated. Thanks in advance. 

[kuovonne]

This is not possible with the current Airtable REST API. A single query can only retrieve data from a single table.

If you have access to the base schema, you may be able to bring info from other tables into the current table using lookup and rollup fields.

Although Airtable is a relational database, it is not an SQL database and you cannot perform SQL queries.

[GabyTango]

Thanks very much, Kuovonne. Will try to modify the base schema as you suggest. 

[GavinA]

Hey @GabyTango - we are working on this feature for our app CSV Getter . I demo the feature in this video. What do you think? Would it help you?

https://www.youtube.com/watch?v=o0xIbXe8k_M