Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Airtable returns a record ID (number from a text field) as alphanumeric

1358 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jaco_van_der_We
4 - Data Explorer
4 - Data Explorer

Hi

I create new records in Airtable via the API with integromat. As part of the payload I send a id which is numerical, however when I receive the response back from airtable, the id is displayed as alphanumeric. The same happens when I send an api request for records, the id is also displayed as alphanumeric - I have to see the id as a number

Untitled

Untitled2

Please assist

Thanks
Jaco

2 Replies 2

The ID value that Airtable is giving back to you—beginning with “rec”—is Airtable’s internal ID for the record. Airtable always creates its own ID for every record, even if the user chooses one themselves for the record’s primary field. That ID isn’t being stored in the literal “id” field that you created; Airtable is just returning it to you in case you need to use it in later steps that require an Airtable record ID.

The ID that you’re passing in is still being stored in a field named “id”, which will not clash with Airtable’s internal ID. However, you can’t use them interchangeably. If a later step in the scenario requires an Airtable record ID, you can’t pass your own ID. It needs to be an Airtable record ID.

Does that make sense?

Ok cool, yeah that’s very helpful, thank you