Invalid date format error in /filters POST

since 10.8.2022 we have noticed receiving ‘Invalid date format’ error response in attempts of creating filters via API. We haven’t changed the way we create filters and it worked until 10th of august.
We were creating it like this

'{ "name": "_CT_temp_****", "type": "deals", "conditions": { "glue": "and", "conditions": [ { "glue": "and", "conditions": [{ "object": "deal", "field_id": "***", "operator": ">=", "value": "2022-08-23T13:46:11Z", "extra_value": null }] },{ "glue":"or", "conditions": [] } ] } }'

which started to lead to this error

"error": "value: Invalid date format: 2022-08-23T13:46:11Z",

we implemented a workaround specifying just date in the filter without specific time like this

"value": "2022-08-07"

that works, but the fact that we’re not able to specify update time causes us additional issues.
I’d like to ask whether this is a known issue, or intended change in the api ?
Thank you.

Welcome to the community @Lukas_Masar :wave:

It is indeed an intended change in the API, but it was implemented too soon and we apologize for the inconvenience. Thank you for letting us know! Our team has rolled back the change and you should now be able to create filters the old way without issues.

We have now communicated via our Changelog that the YYYY-MM-DD date format check for filter conditions will be implemented on November 4, 2022. The goal of the change is to make sure that our API is consistent with the Pipedrive web app - in the web app, creating filters with a datetime format is not possible - and that all date type filters work as expected.

To be notified of other upcoming API changes or updates, I would suggest subscribing to our Changelog. :slight_smile:

Do let us know if you have further questions!

1 Like