Skip to main content
Solved

API fetch linked fields in one api call

  • June 1, 2023
  • 3 replies
  • 132 views

Forum|alt.badge.img+3

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?

Best answer by YossiB

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

3 replies

Forum|alt.badge.img+18

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


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • June 1, 2023

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. 


Forum|alt.badge.img+3
  • Author
  • New Participant
  • Answer
  • June 1, 2023

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