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

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.

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

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

Hi GabyTango (and anyone else who might be tackling this now),

I know this post is from back in February, but for anyone else running into the same problem, I thought I’d add some extra info.

As kuovonne explained, the Airtable REST API limits you to retrieving data from one table at a time, so you’d need to make multiple requests and manually combine the data from linked records.

For anyone still looking for a more efficient solution, a GraphQL API like BaseQL might be useful. It allows you to query across multiple tables in a single request—similar to SQL joins—making it much easier to work with linked records.

Here’s a guide I wrote on handling cross-table joins with Airtable that could be helpful: Cross-Table Joins with Airtable API.

Hopefully this helps anyone else facing this issue!