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

[heathernicole]

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 API only with your API token. For HTTP Basic Auth you have to add the Authorization header with the request. The API token is the user name and the string 'api_token' is the password. Whenever possible please use the tools and interfaces provided by your http library to do Basic Auth (for example, curl uses the -u switch for that). 

but I'm not exactly sure how to format the parament for the Authorization below. Any help would be greatly appreciated!

[Eric_Zhang]

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

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

[Eric_Zhang]

---

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

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

[McCow]

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