Cannot Get Patch Request To Work

[Suraj_Kapoor]

article_url = "https://api.airtable.com/v0/appxxxxxxxxxxx/articles/row_id?api_key=APIKEY"
data = {"fields" : {"contacted" : "hello world"}, "typecast":True}
patch_article_data = requests.patch(article_url, data=data)

I don’t understand why the above doesn’t work doing a patch request. I’ve tried many variations, including without typecast. I get the following response.

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

[Bill_French]

I’m pretty sure a record ID is required for a PATCH.

[Suraj_Kapoor]

In the example, row_id is the record_id. Should it be a param instead?

[Bill_French]

Suraj_Kapoor:

row_id is the record_id. Should it be a param instead?

Without a complete review of the underlying code I can only say that I think a PATCH payload (the data) must be an array of records to be updated.

[JonathanBowen]

Hi @Suraj_Kapoor - I’m assuming you are using the Python requests library here. This is some code that I implemented for a patch request:

api_url = 'https://api.airtable.com/v0/YOUR_APP_ID/YOUR_TABLE_NAME/' + id

headers = {
    'Content-Type': 'application/json',
    'Authorization': 'Bearer YOUR API KEY'
    }

data = {
  "fields": {
    "your_field_name": "value"
  }
}

response = requests.patch(api_url, headers=headers, json=data)

Looking at this post:

API URL Query - How do I filter by date? API

When passing your access token to the API, it should always be in the form “Bearer {MY_KEY}” where {MY_KEY} is your access token. Also, you should be placing the access token in the “Authorization” header for your request and not in a query parameter. To filter by a given field, you have two options. One option is to create a view in your base and then use the view name in the view query parameter. For example, if the view is named “Dates after Feb 20”, you can access it via https://api.airta…

it recommends using the API key in the headers, rather than as a URL param. Try this, hopefully will work out for you.

JB

[JonathanBowen]

Suraj_Kapoor:

In the example, row_id is the record_id. Should it be a param instead?

As per the API docs for your base, the record id should be in the patch request URL:

curl -v -X PATCH https://api.airtable.com/v0/APP_ID_HERE/TABLE_NAM_HERE/rec123123123

[Suraj_Kapoor]

Thank you! That did the trick. Appreciate your help

[sadhika_bhatia]

I am also facing the same issue that getting this error for patch request. I have added the API key in the header and the view in the query parameter but still getting the same error

[JonathanBowen]

Did you pass the ID of the record you wanted to update? e.g.:

https://api.airtable.com/v0/APP_ID_HERE/TABLE_NAM_HERE/rec123123123

Note the record ID on the end, this is the record you want to update