Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Invalid_value_for_column

Topic Labels: API
3867 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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.