Help

How to find the linked table for lookup type columns

Topic Labels: API
906 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Sefik_Serengil
4 - Data Explorer
4 - Data Explorer

Hi Folks,

I need to find the linked table id of a lookup type column. Airtable metadata api returns this information for record links type field but it does not return for lookup type fields. I share sample response of metadata api for those field types.

{
 "type": "multipleLookupValues",
 "id": "fldXYZ",
 "name": "Column 1"
},
{
 "type": "multipleRecordLinks",
 "options": {
 "linkedTableId": "tblXYZ",
 "isReversed": false,
 "prefersSingleRecordLink": false,
 "inverseLinkFieldId": "fldYYY"
 },
 "id": "fldAAA",
 "name": "Column 2"
}
1 Reply 1
LeanZubrezki
5 - Automation Enthusiast
5 - Automation Enthusiast

This is still happening in the new API, please see the difference between a multipleLookupValues and  multipleRecordLinks:

LeanZubrezki_0-1713980592284.png

LeanZubrezki_1-1713980625986.png

The funny thing is that there is nothing in the documentation about multipleLookupValues