The GoTo Community is currently experiencing some technical issues affecting new posts and comments. You may need to reload the page you are on before you can post a comment. We are actively working with our service provider and apologize for the frustration.
Forum Discussion
Schedule Report as CSV
I'm trying to figure out a way to get to our incident data through Power BI. I can manually download incident reports as csv, but I don't see a way to schedule the report to be a csv attachment as opposed to a link. After reviewing the available API's I can't seem to find an API that gives me access to the incident objects in GoToAssist. I'm not sure how to automate extracting this data and would appreciate any assistance.
6 Replies
cajuncrawdad That refers to a number used with Active Directory assignments.
If that's the case, then what's the point of the "Account-Wide Api Token"? How do you use it in any of your apps?
cajuncrawdad Sorry, that 1 hour Auth requirement is mandatory for now, and cannot be changed from our end.
AshC , thank you for the reposne. I was able to setup the API calls and successfully get the data that I'm after as a JSON. I was even able to figure out how to set the report_id parameter to retrieve EXACTLY what I'm after. However, it's under that current access token that I generate in Postman. I can't get the access token each time in PowerBI. Is there a way to utilize the "Account-Wide Settings API Token" that is under, "
- Account API Token
? The idea is to not have PowerBI have to authenticate every 60 minutes.
Is this even possible?
cajuncrawdad This guide has all of the API calls for Incident Management starting on Page 4:
https://assets.cdngetgo.com/27/66/0e469b5948bcbb173fe16be1fcaf/gotoassist-service-desk-api-guide.pdf
You would want to customize your report under those parameters specifically.
Someone please reply to this
