Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: API fetch linked fields in one api call

Solved
Jump to Solution
3272 0
cancel
Showing results for 
Search instead for 
Did you mean: 
YossiB
4 - Data Explorer
4 - Data Explorer

I have a few tables where each table has linked records to the other table and I am fetching it with the Airtable api the problem is though that I need to first fetch table 1 and and get all the linked records IDs and then I fetch table 2 with the record ids and so on until I get the whole object graph and it’s very slow 

my question is is there a way to get the whole graph in a single api call?

1 Solution

Accepted Solutions
YossiB
4 - Data Explorer
4 - Data Explorer

Thanks all for your reply’s in the end I am using baseql.com which gives you a graphql endpoint to the base. Works like a charm

See Solution in Thread

3 Replies 3

You can recursively fetch linked records in your initial fetch. Whether it's more performant depends on your data.

In Airtable, you can create lookup fields, rollup fields, and formula fields to bring in the linked record data that you need into your first table. Then, that data will be returned to you when you query the first table. 

YossiB
4 - Data Explorer
4 - Data Explorer

Thanks all for your reply’s in the end I am using baseql.com which gives you a graphql endpoint to the base. Works like a charm