Help

Invalid_value_for_column

Topic Labels: API
5486 1
cancel
Showing results for 
Search instead for 
Did you mean: 
mrpn
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1
Richard_Klopfen
4 - Data Explorer
4 - Data Explorer

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.