Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 15, 2020 11:48 AM
I’ve got a cURL PATCH request in order to update a record, however I seem to be getting this error:
{
"error": {
"type": "INVALID_REQUEST_MISSING_FIELDS",
"message": "Could not find field \"fields\" in the request body"
}
}
This is my current cURL request, I am using PHP:
<?php
// get cURL resource
$ch = curl_init();
// set url
curl_setopt($ch, CURLOPT_URL, 'https://api.airtable.com/v0/appmAdTUWbbY2vitV/Members/recl0qsFKY2dkR1NR');
// set method
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'PATCH');
// return the transfer as a string
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
// set headers
curl_setopt($ch, CURLOPT_HTTPHEADER, [
'Content-Type: application/json; charset=utf-8',
'Cookie: brw=brwjOwXWWJ95PfnJr',
]);
// json body
$json_array = [
'records' => [
[
'id' => 'recl0qsFKY2dkR1NR',
'fields' => [
'Rank' => 'Captain'
]
]
]
];
$body = json_encode($json_array);
// set body
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $body);
// send the request and save response to $response
$response = curl_exec($ch);
// stop if fails
if (!$response) {
die('Error: "' . curl_error($ch) . '" - Code: ' . curl_errno($ch));
}
echo 'HTTP Status Code: ' . curl_getinfo($ch, CURLINFO_HTTP_CODE) . PHP_EOL;
echo 'Response Body: ' . $response . PHP_EOL;
// close curl resource to free up system resources
curl_close($ch);
Note, I’ve deliberately left out my API key.
I’ve tried searching the web, but nothing has yet worked! Please help! I do not know how to use the bundled .js
API, which is why I am doing it this way.
Apr 15, 2020 12:34 PM
Just a hunch - I don’t think this should be an array; rather, an object like this which contains an array of records:
Apr 15, 2020 02:11 PM
Thanks for the help, I got it working. The reason was that I did not need the “records” index.
Apr 15, 2020 03:38 PM
It also looks like you are doing a POST instead of a PATCH.
curl_setopt($ch, CURLOPT_POST, 1);
Apr 15, 2020 03:49 PM
Yep I completely rewrote the code.
Apr 15, 2020 03:57 PM
If you are making a PATCH request to the record endpoint url, you don’t use the “records” level of the multi-dimensional array in the $body.
If you are making a PATCH request to the table endpoint url, you do need the “records” level of the multi-dimensional array in the $body.
You were mixing and matching the record endpoint (for updating a single record) with the format for updating multiple records (which should be sent to the table endpoint).
The syntax of the $body was fine. The PHP syntax looks a little strange to if you’re used to JavaScript, but it should work.
Apr 15, 2020 04:01 PM
Ahh I see. Thanks so much for clarifying that.
Apr 21, 2021 02:53 PM
Hi @rebal15 , may you share your final code with me please, I have similiar problems and believe you already solved with this discussion.
May 13, 2021 11:49 PM
Hey @rebal15 , can you update us with your final code? I cannot get a patch request to work for the life of me.