Incremental ticket export api filtered by brand | Community
Skip to main content

Incremental ticket export api filtered by brand

  • November 10, 2022
  • 3 replies
  • 0 views

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! 

3 replies

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 provided start_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 your start_time value 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.

  • Author
  • November 17, 2022

Thank you for the reply, I appreciate it!


No problem.  Have a great weekend!