Forum Discussion

cajuncrawdad's avatar
cajuncrawdad
New Contributor
7 years ago

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.  

      • cajuncrawdad's avatar
        cajuncrawdad
        New 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?