Explore report export for use in API calls

Gepostet 28. Sept. 2023

Feature Request Summary:

To make it easier to use Zendesk API, is there a way to get a report's query exported as a JSON or SQL or API query? We would like to be able to handle live Zendesk data, rather than relying on data files and dashboards.

Description/Use Cases:

When using the API, the query parameter usage can be pretty difficult to replicate from complex reports created using Explore. When replicating, the various end points and parameters that need to referenced are possible to identify, but would require a significant level of effort to really capture. However, it seems like there should be a formulaic solution to that and that it would be possible to do so manually. If so, it seems like Explore should also be able to use the formula to stitch these together.

Business impact of limitation or missing feature:

This is important to our business as we try to extend usage of Zendesk data to other business contexts (ie. comparisons against Marketing Cloud campaigns, or financial analysis in Power BI). Since it relies on complex understanding of a variety of Zendesk end points, but one that could generally exist, this would save on both developer time and accuracy/confidence in the results.