Clear date field with null via API

I’m struggling to pass an empty date to Airtable without throwing an error. My integration is with python, and so far I’ve tried an empty string and Python’s None (i.e. null) keyword. But with the None keyword I run into this error…

‘422 Client Error: Unprocessable Entity for url: https://api.airtable.com/v0/…[Error: {‘type’: ‘INVALID_VALUE_FOR_COLUMN’, ‘message’: ‘Cannot parse date value “None” for field Effective Date’}]’)

Passing None to other fields clears the fields correctly so I’m really hoping this isn’t an API limitation where we can’t clear dates? Thanks for any thoughts!

sorry, please ignore this, the API does accept None for a date column - I was just mistakenly converting to String elsewhere in my code before passing to the API

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.