Incremental ticket export api filtered by brand
Hello,
We are on an Enterprise plan with multiple brands. My ultimate goal is to export a 90 day rolling window of tickets within one brand that contain a specific tag (cancel). Using the search api exceeds the rate limit. When attempting to use the incremental ticket export, I have not been able to figure out how to export just the single brand I am reporting on, using &include=brand_id:12345678 doesn't seem to be correct as I am still seeing other brand ids in the results.
Not sure how to incorporate the rolling 90 day window as it looks like the parameter is start_time=unix timestamp.
Thank you in advance!
-
Hey Patrick,
With search, it helps to make the query more specific to return smaller sets of data within the results limit or use Export Search Results. This may allow you to avoid exceeding rate limits.
There isn't a way to filter tickets returned by the Incremental Ticket Export (outside of excluding deleted tickets). It will return all tickets updated since the providedstart_time. Your application that requests the export will need to parse the response data and filter any undesired tickets from that end.
For an export of the last 90 days, generate the timestamp for "now" or "today" and subtract 90 days (in seconds). This new timestamp will be yourstart_timevalue for 90 days ago. After sending the first request, continue paginating until the end of the stream. Then you'll have an export of tickets updated in the last 90 days.
-
Thank you for the reply, I appreciate it!
-
No problem. Have a great weekend!
Please sign in to leave a comment.
3 Comments