Invalid_value_for_column


#1

Hello, working on small PHP site with https://github.com/DavidZadrazil/airtable-api-php/

When I’m trying to update Checkbox or Number field via

$response = $request->updateRecord('recsH5WYbYpwWMlvb', ['Cancel' => '123']); $response->isSuccess(); // true / false

I get this error;

Fatal error: Uncaught GuzzleHttp\Exception\ClientException: Client error:PATCH https://api.airtable.com/v0/appXXXX/Invoices/recSMXnTwTiRrRvGBresulted in a422 Unprocessable Entityresponse: {"error":{"type":"INVALID_VALUE_FOR_COLUMN","message":"Field Cancel can not accept value 123"}}

I can successfully update Name fields. Any ideas why i get 422 error?

Thanks


#2

Late to the party, but that error appears when a field like single-select or multiple-select is given a value that isn’t one of the pre-defined select options.