Forum Discussion
connect to a web api from power BI
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
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.
2 Replies
- Greg_Deckler
Community Champion
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.
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