Data Egress - Admin Implementation AB#294553

AB#294553

Please note that the linked ADO ticket mentions running particular reports to get the data from Zendesk. This isn't how we will do this technically as 1) you can't run a report through the API and 2) by getting the data directly ourselves we don't have to rely on a report being defined and 3) the report may have formats that are problematic.

After the CheckingExercise has closed, all of the ChangeRequest records with Status Submitted:Committed will also have a CMSId which references the zendesk ticket id.

Us those CMSIds to query the Zendesk API and get all the tickets:

https://esfa-preprod.zendesk.com/api/v2/tickets/show_many.json?ids={id},{id},...,...

That endpoint has a limit of 100 ids in the ids query param, so batch up the requests if there are more than 100.

Of those tickets that come back, any that have a status of accepted or auto-accepted need to be included in the CSV output.

I have attached the PoC console app that I used to test the API and the CSV generation. This is throwaway code and is only meant as an example.