Skip to main content
Solved

Clear date field with null via API

  • March 1, 2022
  • 1 reply
  • 108 views

Forum|alt.badge.img+9

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!

Best answer by DanielP

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 reply

Forum|alt.badge.img+9
  • Author
  • Inspiring
  • 14 replies
  • Answer
  • March 1, 2022

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