Apr 25, 2020 07:40 PM
I am getting a 422 error code when I try to update a record via PATCH method. Specifically, the Airtable > Update a record event performs the folloiwng HTTP request:
curl -X PATCH ‘https://api.airtable.com/v0/APPXXXXXX/Clients/RECXXXXXX’ -H ‘user-agent: Integromat/production’ -H ‘authorization: ***’ -H ‘content-type: application/json’ -d ‘{“fields”:{“Status”:“Lead - New”,“Initial Call Date”:“2020-04-16”,“Post Call Followup”:“None”,“Opportunity Followup”:“None”,“Post Project Followup”:“None”},“typecast”:false}’
for which the module received the following response:
Status code: 422
Headers:
{
“access-control-allow-headers”: “authorization,content-length,content-type,user-agent,x-airtable-application-id,x-airtable-user-agent,x-api-version,x-requested-with”,
“access-control-allow-methods”: “DELETE,GET,OPTIONS,PATCH,POST,PUT”,
“access-control-allow-origin”: “*”,
“content-type”: “application/json; charset=utf-8”,
“date”: “Thu, 23 Apr 2020 08:24:37 GMT”,
“etag”: “W/“52-ooYmp4xonjkntQ21csI0DL9Yg5I””,
“server”: “Tengine”,
“set-cookie”: [
“brw=brwIxfJkCri6aA5rp; path=/; expires=Fri, 23 Apr 2021 08:24:37 GMT; domain=.airtable.com; secure; httponly”
],
“strict-transport-security”: “max-age=31536000; includeSubDomains; preload”,
“vary”: “Accept-Encoding”,
“x-content-type-options”: “nosniff”,
“x-frame-options”: “DENY”,
“content-length”: “82”,
“connection”: “Close”
}
Body:
{
“error”: {
“type”: “UNKNOWN_FIELD_NAME”,
“message”: “Unknown field name: “Status””
}
}
The API call keep throwing the UNKNOWN_FIELD_NAME error despite the fact that the field Status evidently exists in the referenced table. I am getting this error for OTHER fields as well.
Apr 26, 2020 10:37 AM
A wild guess - the double quotes in your JSON payload trouble me. Make sure you don’t have a character encoding issue in your cURL statement.