I’m looking for the history of Tickets in AutoTask.
Each ticket in AutoTask has several statuses (Intake, In Progress, Solved, Completed, …). In AutoTask GUI I can see for a ticket each status, the DateTime is was set to that status and by whom.
I’ve been looking in the available tables in the AutoTask connector, but I can’t find the correct table.
I found the same table in the documentation, but when I try to access the table, it is not available. The only TicketHistory table found is the one with the count of rows…
I’m accessing the data via the ODATA feed.
A view can be created to use it from Power BI, but note that this require one API call per ticket. For instance, with 100.000 tickets in the filtered selection of 500.000 tickets in total, retrieval will trigger 100.000 API calls.