Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Get record name instead of id - via API using Python

Solved
Jump to Solution
1196 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m using Python API Wrapper.

When I use get() method to retrieve a record that contains a ‘Link to Another Field’ Column, the method returns the linked record ID. I would like to get the linked record name instead. My next step will be to do a 2nd operation to look up each record (by id) and get the name. But I wonder if there is an easier way that I’m overlooking.

If not, any recommendations about an efficient way to do this with Python / Pandas would be appreciated.

1 Solution

Accepted Solutions

Hi @Matt_Kennedy1,

I think this is because Airtable into “link to” fields stores the record id even if we see the data.
What I recommend is to create a formula field that with ArrayJoin({linked to filed}) function inside. This will convert it to text so you can request this field with get() function.

Does it work for you?

Thanks

See Solution in Thread

2 Replies 2

Hi @Matt_Kennedy1,

I think this is because Airtable into “link to” fields stores the record id even if we see the data.
What I recommend is to create a formula field that with ArrayJoin({linked to filed}) function inside. This will convert it to text so you can request this field with get() function.

Does it work for you?

Thanks

Yes - this works. I was hoping to avoid adding the extra fields for all the tables I’m working with, but it isn’t too bad so far. Thanks!