Export to Airtable errors in Linked Fields

Hey all,

I’m trying to export data to Airtable with the API. All works OK unless I am trying to export data into a linked Field, then it fails with a 422 error relating to invalid Record ID.

I assume it needs the recordID rather than the name but It works OK with Zapier as long as the name matches, if not it creates a record in the linked table.

If I use PUT (as I saw in another post) I get the error:

{
“error”: {
“message”: “Invalid request: parameter validation failed. Check your request data.”,
“type”: “INVALID_REQUEST_UNKNOWN”
}
}

Please help ;(

Jason

At the end of your body you have to include “typecast”: true so it would look like this:

{
“fields”: {
“Linked Field Name”: ["{Parabola Linked Field Name}"],
“AT Non Linked Field Name”: “{Parabola Non Linked Field Name}”
},
“typecast”: true
}

1 Like

Thanks, Josh, Appreciate the input. I’ve tried that but still getting an error

Body:
{
“fields”: {
“Twitter handle”: ["{handle}"],
“Tweet Content”:"{text}"
},
“typecast”:true

}

Here is the error:

{
“error”: {
“message”: “Invalid request: parameter validation failed. Check your request data.”,
“type”: “INVALID_REQUEST_UNKNOWN”
}
}

It looks like the formatting of the body changed when I pasted. Try this.

{
	"fields": {
		"Twitter handle": ["{handle}"],
		"Tweet Content": "{text}"
	},
	"typecast": true
}

All working now, really appreciate your input Josh.

I had changed Type from Post to Put after reading another possible solution. I changed it back and used the “typecast”:true and, as if by magic, it all works :wink:

Thanks, Again

1 Like

Glad to see you guys got this all worked out!

1 Like