How import via API a text string into a linked field

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

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.)

2 Likes

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

Have a good day,

Clément

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.