May 27, 2022 07:30 AM
Mi update with curl doesn’t work and i dont know where is the error
Record id, url and key are corrects (they works with delete and create rows), but not with update.
¿Can someone help me?
Thanks for your time!
May 27, 2022 08:07 AM
Hi did you also test this out on Postman first to be sure there isn’t any issue with the endpoint, also what response did you get ?
May 27, 2022 08:20 AM
I dont know if im doing good on Postman, is this correct or im doing something wrong?
May 27, 2022 08:23 AM
Did you send the X-Airtable-Client-Secret in the header ?
May 27, 2022 09:13 AM
This is mi header, i need something more here?
May 27, 2022 09:31 AM
May 27, 2022 11:53 AM
Why i didn’t use it in create record or delete record and they works? I only need on update?
May 27, 2022 04:09 PM
Welcome to the Airtable community!
To do an update you need a PATCH
request. It looks like you are setting your custom request to PATH
. Try adding the C
.
May 28, 2022 05:02 AM
Ops! That’s true, i add “C” but still doesnt work
Is param’s array correct?
May 28, 2022 01:02 PM
Are you getting an error message? If so what?
Are your $params
correct?
Are you updating one record, or multiple records?
If yo are updating only one record, are you using the endpoint for the record or the endpoint for the table?
If you are using the endpoint for the table, it looks like your body is missing the records
key as described in the API documentation.
May 29, 2022 03:51 PM
Mi params are correct: $field → Column name, $value → boolean (is check column)
Im updating only one record.
Im using table endpoint (that works on delete and insert statements)
The record’s key is in $record[‘id’] in $params, i not sure about that, for that i asked for mi param’s array.
May 29, 2022 03:55 PM
This is mi create record
And this, si mi delete record:
They works fine, i dont know why mu update doesn’t, only the param’s array is the difference…
May 29, 2022 07:06 PM
The top level object in the body should have a key of “records” whose value is the array of records. This key is at the same level as the “typecast” key.
May 31, 2022 12:52 AM
Finally it works, the array was the problem. If i use this, all go fine:
Thanks all for your time and help!
May 31, 2022 05:40 AM
Glad you got it working.
Is there a reason why you switched to doing the JSON encoding manually? That step is unrelated to including the top level “records” object key, which was your main problem. Depending on the names and values of your fields, you may eventually get values that will be very difficult to encode manually.