Help

Clear date field with null via API

Topic Labels: API
Solved
Jump to Solution
1382 1
cancel
Showing results for 
Search instead for 
Did you mean: 
DanielP
6 - Interface Innovator
6 - Interface Innovator

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!

1 Solution

Accepted Solutions
DanielP
6 - Interface Innovator
6 - Interface Innovator

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

See Solution in Thread

1 Reply 1
DanielP
6 - Interface Innovator
6 - Interface Innovator

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