Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How import via API a text string into a linked field

1114 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a table 1 “user” linked to a table 2 “event”. Via Post API, the users create any events where I collect de {user.email} like "email": "{user.email}" ]. This is to be able to link users informations in the Event table with lookup. Then, the goal is to display event with a GET request and add event information + users informations. But, the problem is, with the POST request, i can’t send a Text string (le user email so) from the API to the linked field… It necessary to give the row ID matching with the User record from the User Table.

Do you have any idea to be able to directly send, via API call, the user email as text ? Thanks you for your help

2 Replies 2

Welcome to the community, @clement_desrues!

If you enable the typecast parameter by making its value true, then Airtable will automatically translate the text string into the appropriate Record ID value for you.

It’s not described too well in the Airtable API documentation, but that’s what the typecast parameter does.

Currently, the API documentation says this for typecast: “The Airtable API will perform best-effort automatic data conversion from string values if the typecast parameter is passed in.”

In real-world language, what this means is that enabling typecast will allow you to do 3 things:

  1. Post text to a linked record field, and Airtable will automatically convert it to the appropriate Record ID (if the linked record already exists), or Airtable will automatically create a linked record (if the linked record doesn’t already exist).

  2. Post text to a single select field, and Airtable will automatically add a new option if it doesn’t already exist.

  3. Post text to a multi select field, and Airtable will automatically add a new option if it doesn’t already exist.

Alternatively, remember that you can always search the other table for the record that you’re looking for, which will then return the Record ID for you that you can use for your API calls.

And, if you don’t want to write your own API calls at all, you can always use Integromat, which is a no-code/low-code environment for communicating with Airtable’s API.

Integromat is an easy point-and-click environment, and they have integrated the typecast parameter as an option entitled “Smart Links”.

(Note that I am a professional Airtable consultant and a Registered Integromat Partner, and the Integromat link contains my personal referral code. If you have a budget for your Airtable project and you’d like to hire an expert to help you, please feel free to contact me through my website at ScottWorld.com.)

Hey @ScottWorld thanks you so much ! This is exactly what I was looking for :pray:

Have a good day,

Clément