Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 01, 2023 11:21 AM
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?
Solved! Go to Solution.
Jun 01, 2023 04:11 PM
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
Jun 01, 2023 12:30 PM
You can recursively fetch linked records in your initial fetch. Whether it's more performant depends on your data.
Jun 01, 2023 12:55 PM
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.
Jun 01, 2023 04:11 PM
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