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?
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.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.