cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Active 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 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 6
Highlighted
Active Contributor

Re: Schedule Report as CSV

Someone please reply to this

Highlighted
LogMeIn Contributor

Re: Schedule Report as CSV

@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.

Highlighted
Active Contributor

Re: Schedule Report as CSV

@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?

Highlighted
LogMeIn Contributor

Re: Schedule Report as CSV

@cajuncrawdad  Sorry, that 1 hour Auth requirement is mandatory for now, and cannot be changed from our end.

Highlighted
Active Contributor

Re: Schedule Report as CSV

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?  

Highlighted
LogMeIn Contributor

Re: Schedule Report as CSV

@cajuncrawdad  That refers to a number used with Active Directory assignments.