Retrieve "Tech Hours" Report Via API using Power BI

Hey everyone,

We are looking to create our own dashboards and have successfully connected Power BI to the Syncro API. We would like to report on time by technician per day.

In Syncro, if you run the “Tech Hours” report with no technicians selected and change the period to “all” you get a long list of all tickets in Syncro. Each row includes a column for “Work Hours.”

We are unable to find an API function that pulls this data - has anyone been able to do this?

Thanks,

J

1 Like

Also looking to get a nice Power BI dashboard setup.

Would you mind providing some details on how you got yours connected to Power BI, I am struggling with the data source and queries.

Thanks in advance

2 Likes

@msp3, @jgoldberg

Same here. We could not get the API to work as documented. If you figured it out, it would be a great help for others if you provided the details. Also if you are interested in collaborating on a joint effort please let me know. pc[a]inft.us

The API is very much lacking and documentation is poor.

I have tested using the Ticket Timer API and it does return the data you need. This query would return all ticket times for today (or into the future).

https://yourdomain.syncromsp.com/api/v1/ticket_timers?created_at_gt=2022-09-26