Export to Airtable errors in Linked Fields

Ask a question
1

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

2

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
3

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”
}
}

4

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

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

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
6

Glad to see you guys got this all worked out!

1 Like
7

Hey everyone,

I was running into this same issue. I added the “typeform”: true verbiage and I am now running into a new issue.

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

Any thoughts?

BTW, I also changed it to a Post although I believe I would like a PUT but at this point, I just want it to work.

8

Hi @Henry_Johnson,

Can you copy and paste the JSON body of your request? Happy to take a look!