Zendesk Search API - Relative Solved Date | Community
Skip to main content

Zendesk Search API - Relative Solved Date

  • February 5, 2024
  • 1 reply
  • 0 views
J

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

    1 reply

    Tipene
    • Tipene
    • February 5, 2024

    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

    Terms & ConditionsCookie settingsAccessibility statement