Has anyone used the Trigger Webhook to post ticket data to an external source? I'm trying to effectively write some ticket data to an external source i.e. SharePoint or similar. Currently my leadership team is wanting to gather total elapsed time of ticket in a particular status for reporting purposes. Tickets in Group A spent a total of 120 hours in phase "Development", and so on. There doesn't appear to be a way to accomplish this in the canned reports or analytics. The data is not included in the scheduled export either. My thought was to trigger a webhook when the status changed given certain criteria, and then write data from the ticket to an external source. I could then draft custom reporting off that.
Thoughts? or help?