Skip to main content

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.


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.


Reply