Help

Get record name instead of id - via API using Python

Solved
Jump to Solution
2355 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Matt_Kennedy1
6 - Interface Innovator
6 - Interface Innovator

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!