Forum Discussion

VinceG14's avatar
VinceG14
New Contributor
5 years ago

GoToAssist Service Desk Custom Data Connector for Power BI

Does anybody know if LogMeIn has any intention of developing a custom data connector for Power BI? I have developed my own custom data connector for Power BI that utilizes the GoToAssist Service Desk API but I have to manually refresh this data connector every morning. I also am not able to utilize this data connector to obtain all of our ticket data with one HTTP API call because when I try I recieve an error code of 500 INTERNAL SERVER ERROR. I have had to break this down into one API call for every distinct assigned IT Support technician and then append the quieries in order to form one dataset that I can use in Power BI. So I have to manualy refresh 6 or more queries every morning and obtain a new access token for each one in order to get past the OAuth2 authentication with the GoToAssist Service Desk API.  Our company went from ZenDesk to GoToAssist as our IT ticketing system and when searching the marketplace it appears that ZenDesk has had a PowerBI Custom Data Connector avaliable in the Power BI marketplace for quite some time now.

  • flaviokf's avatar
    flaviokf
    Visitor
    2 months ago

    Hi VinceG14!

    I don't know how to help you, but I notice you are some steps ahead of me in Power BI integration.
    I have ID, Key and token, but I always receive the message:
    "A web API key can only be specified when a web API key name is provided." in Power BI Web Connector.
    Please, could you help me by giving me the correct way to fill the Power BI field "HTTP request header parameters"?

    Thank you.

  • flaviokf's avatar
    flaviokf
    Visitor
    2 months ago

    Hi Vince!

    After a while, I got it! 
    I got the API link on the GoTo website and applied to Postman software.
    There I included the arguments and made some tests.
    When I reached the correct result, I generated the Python code.
    On the code, is possible to get the complete URL and guess what, the information to fill the fields "HTTP request header parameters".
    The result was: in the first box I filled in the word Authorization, and in the second, with the word Bearer plus the token generated on the GoTo website.

    Does it make sense for you?