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.  

6 Replies

  • AshC's avatar
    AshC
    Retired GoTo Contributor
    6 years ago

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

  • cajuncrawdad's avatar
    cajuncrawdad
    New Contributor
    6 years ago

    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?  

  • AshC's avatar
    AshC
    Retired GoTo Contributor
    6 years ago

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

  • cajuncrawdad's avatar
    cajuncrawdad
    New Contributor
    6 years ago

    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?