Filter tickets using updated_at with date and time

 Hi, I need to filter tickets with the exact time from the last update (updated_at).


This uri works:

https://domain.freshdesk.com/api/v2/search/tickets?query=%22updated_at:%3E%272018-03-21%27%22


But this return an error:

https://domain.freshdesk.com/api/v2/search/tickets?query=%22updated_at:%3E%272018-03-21T10:01:01Z%27%22


Error:

message"Given query is invalid, expected format \"keyword:value OPERATOR keyword:'string' OPERATOR keyword:>'yyyy-mm-dd' OPERATOR keyword:<integer\". Space is mandatory between key/value pair and operator. Please check the paranthesis if there are any."


I understand from this and from the docs that the search API only allow using the field "updated_at" like a date type and not like a datetime to filter tickets, I am correct?. Someone know a workaround for this?


Thanks in advance!

1 Comment

Hi,


The Filter tickets endpoint is primarily to filter tickets based on the custom properties setup in the helpdesk. The updated_at filter allows you only to input date value and doesn't accept the datetime format. Having said that, you can try the List all tickets endpoint wherein the updated_at value can be specified in datetime format.


Cheers!

Login or Signup to post a comment