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
cajuncrawdad
8 years agoNew Contributor
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 o...
cajuncrawdad
7 years agoNew Contributor
Someone please reply to this
- AshC7 years agoRetired GoTo Contributor
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.
- cajuncrawdad7 years agoNew Contributor
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?
- AshC7 years agoRetired GoTo Contributor
cajuncrawdad Sorry, that 1 hour Auth requirement is mandatory for now, and cannot be changed from our end.