connect to a web api from power BI

[Anonymous]

Hi Community

I am trying to connect to a web api via PBI desktop.

I have been provided with the details of the api, but I am unable to figure out how to translate that into PBI to get my results

below are the details that I need to fetch

GET /0/facebook/profiles

HTTPS Host: api.mywebsite.com

Authorization: Basic wxxXZcCRpbjp5c4V1UqVHgdtwHTF

Content-Type: application/json; charset=utf-8

So far, I am using web connector, in URL I am putting https:\\api.mywebsite.com

then,

in add header I am giving autorization code, and add header content type =application/json

But I am not sure where to provide the first line ie GET /0/facebook/profiles

any help would be highly appriciated. any directions or links to material or any quick hints.

regards

[Greg_Deckler · Accepted solution]

If I am reading that correctly, you need to connect to:

https://api.mywebsite.com/0/facebook/profiles

In other words, you should be getting /0/facebook/profiles from the host api.mywebsites.com.

[Anonymous]

Awesome, Thanks. 

If I also need to fetch something specific, say I am using following request

Let

Source = Json.Document(Web.Contents("https://api.mywebsite.com/facebook/profiles",
[Headers=[Authorization="Basic TWpjNekV5WHpNNVpEQTBZMlZpWkRJNE9EY3habVU1WdRellqRTE6NDRmMjk1NTM3ZTVhZmENTlmNDg0Nkjdsoifuwenr",
#"Content-Type"="application/json; charset=utf-8"]],

In 

Source

 OutPUT:

id, name, count, city

if I want to fetch data ony for a specific id, say id number 100 & city = Sydney, how would I ammend the query