Help

Get linked table data

Topic Labels: API
1602 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Danik_Yurkevich
4 - Data Explorer
4 - Data Explorer

Hello! I have two tables: visualSKU and visualSKUTypes. Column “type” in visualSKU linked to visualSKUTypes. How can I get full query of linked table?
photo_2021-07-19_17-04-55
Instead of record id in “type” I want to get full data of visualSKUTypes:
image

2 Replies 2

Welcome to the Airtable community.

Airtable is very different from other databases in how it handles data in linked tables. There are two ways of getting info from a linked table in the api:

  • use lookup and rollup fields to bring the info from the linked table into the current table.

  • do a read of the second table and match data based on the record ids

Welcome to the community, @Danik_Yurkevich! :grinning_face_with_big_eyes: Did @kuovonne provide the answer you were seeking? If so, please mark her comment above as the solution to your question. This helps others who may be searching with similar questions. If you need further help, please let us know. Thanks!