最近搜索
没有最近搜索
Zendesk Search API - Relative Solved Date
已于 2024年2月05日 发布
Hi,
Hoping someone would be able to help out.
I'm not overly familiar with API but am experimenting on using them for some reporting as opposed to the export of a spreadsheet.
I'm attempting to use https://domain.zendesk.com/api/v2/search.json to get all of the tickets and user's details for tickets solved within the past 7 days.
Problems I'm facing are:
a) the query I can get to work e.g. https://domain.zendesk.com/api/v2/search.json?query=created:2024-02-05 doesn't appear to have any solved dates in the response
b) I can't figure out how to use a relative date as a parameter in the API call assuming it is possible and I don't have to use Python for example and do it via that while importing datetime as I would ideally like this to be queried in Excel Power Query.
A separate option (not ideal as I would prefer it at source) is available if the solved date is available in the response if for the date range to be filtered in Power Query.
Thanks,
James
0
1 条评论
Tipene Hughes
Hi James,
The search query you provided would only return tickets that were created on 05/02/2024 so it may be that there were no solved tickets for that specific date. You could use something like this to search for a specific range i.e within the last 7 days:
https://domain.zendesk.com/api/v2/search.json?query=created>2024-01-29 created<2024-02-06
That said, the Incremental Exports API might be more suitable for you if you're wanting to use relative dates. Here's the documentation which goes in to more detail.
If you have any questions at all, feel free to let me know.
Thanks!
Tipene
0