Forum Discussion

heathernicole's avatar
heathernicole
Icon for Continued Contributor rankContinued Contributor
8 years ago

Connect to web APO in Power BI Desktop - HTTP request header parameters

I am trying to connect to Toggl's API using the Power BI web connector advanced settings. I'm not very familiar with headers, etc...   Toggl docs - mention this: You can authenticate in the reports...
Need Help
Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

heathernicole

It is all depending on Toggl's API. For testing purpose, could your provide a valid curl statement as in this document Toggl's API:Detailed report? You can mask the api_token and send it via a private message.  The API Token can be found in your profile at https://www.toggl.com.

curl -v -u 1971800d4d82861d8f2c1651fea4d212:api_token -X GET "https://toggl.com/reports/api/v2/details?workspace_id=123&since=2013-05-19&until=2013-05-20&user_agent=api_test"
Successful respons

 

 

heathernicole's avatar
heathernicole
Icon for Continued Contributor rankContinued Contributor
8 years ago

Eric_Zhang - I've got the API token (I don't know how to mask it) - I think part of my problem is I've never done anything quite like this before. So I don't necessarily have a full of understanding of how it works in the first place.

 

I can't seem to find any detailed documentation on Power BI's advanced settings for the Web connector either. 

 

 

 

 

 

 

  • McCow's avatar
    McCow
    Icon for Resolver III rankResolver III
    8 years ago

    Hi heathernicole

     

    This tool had save me a many many hours of API connectors development:

    Postman

     

    I belive it can help you to.

     

    Best ragards

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago
    heathernicole wrote:

    Eric_Zhang - I've got the API token (I don't know how to mask it) - I think part of my problem is I've never done anything quite like this before. So I don't necessarily have a full of understanding of how it works in the first place.

     

    I can't seem to find any detailed documentation on Power BI's advanced settings for the Web connector either. 

     

     

     

     

     

     

    heathernicole

    Can you send it via a private message? I am about to test it in Postman, as McCow mentioned.

    • heathernicole's avatar
      heathernicole
      Icon for Continued Contributor rankContinued Contributor
      8 years ago

      Eric_Zhang McCow - ok - I got a URL working in Postman. :)  (So excited!)

       

      I've been able to load a could of requests into PowerBI as well. However - I've got to work around a permissions issue. I'm admin within the workspace - but I can't access the report items I need or the list of users.

       

      THANK YOU for your assistance in getting started!!