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