typecast parameter

775 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


I am working on a project requiring syncing complex data to Airtable. After having errors due to some columns containing json data (working on a Python script), I switched my API queries to typecast=true which solved my issue (json data is converter to text).

However, I was surprised that using this parameter gives me some errors on dates formatted as "2023/01/19 10:12:18" while same data was working correctly with typecast=false :

requests.exceptions.HTTPError: ('422 Client Error: Unprocessable Entity for url:*********/*********', '422 Client Error: Unprocessable Entity for url:*********/********* [Error: {\'type\': \'INVALID_VALUE_FOR_COLUMN\', \'message\': \'Cannot parse date value "2023/01/19 10:12:18" for field date_intervention\'}]')

Isn't typecast=true supposed to be more permissive ? If so, why such errors on dates while they are accepted on typecast=false?

0 Replies 0