Connecting to web api

Question

Hi&nbsp;I am very new to using Power bi, so this might be a very basic question, but hope someone can help me.&nbsp;Until now&nbsp;I have only created dashboards based on data from our local server. However now I would like to connect to data from one of our online services.&nbsp;They have provided the following:https://speca.io/SimonOnlinePOS/external-api-v2?key=41502b8375f30e56b210877ef797b7e4How would I easiest set a connect up? I have look though the many connects in Power bi, but only got more confused. So maybe someone, could guide me on where to start 😊&nbsp;CheersJesper Miles

jayendran · Answer

Hi&nbsp;Anonymous&nbsp;&nbsp;As&nbsp;SteveCampbell&nbsp; mentioned you can pass the token in the Headers,In Power Query this will be likeWeb.Contents("https://api.powerbi.com/v2.0/",[Headers=[Authorization=Bearer 412sdsx1....]])Making much simpler you can also provide your query parameters lilke the belowWeb.Contents(
    "https://data.gov.uk/api", 
    [
        RelativePath="3/action/package_search", 
        Query=
        [
            q="cows", 
            rows="20"
        ]
    ]
)Some References:https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/https://eriksvensen.wordpress.com/2014/09/15/specifying-json-query-in-power-query-example-statistics-sweden/https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/

jayendran · Answer

Hi&nbsp;Anonymous&nbsp;&nbsp;You can use the Web Connector&nbsp;let
    Source = Json.Document(Web.Contents("http://https://speca.io/SimonOnlinePOS/external-api-v2"))
in
    Sourcehttps://docs.microsoft.com/en-us/power-bi/desktop-tutorial-importing-and-analyzing-data-from-a-web-page&nbsp;https://stackoverflow.com/questions/36685463/how-to-connect-my-web-api-wtih-power-bi-reports

stevecampbell · Answer

If you go Get Data &gt; Web Contents, you have the option of "Advanced".This will allow you to apply Headers&nbsp;&nbsp;&nbsp;&nbsp;Love hearing about Power BI tips, jobs and news?I love to share about these - connect with me!Stay up to date on&nbsp;&nbsp;Read my blogs on&nbsp;&nbsp;Remember to spread knowledge in the community when you can!&nbsp;

anonymous · Answer

Thansk&nbsp;Jayendran!&nbsp;I have been provieded with a token form the web service, where does that fit in ?&nbsp;If you open the link, then i though i shoul build a Url like this:&nbsp;&nbsp;Web.Contents("https://api.onlinepos.dk/api/getCardsList/{debtor}/{type}/{offset}")&nbsp;

jayendran · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;Do you have any update ? If you solved your problem, please accept the answer so that it will help other community members

Forum Discussion

Connecting to web api

5 Replies

Related content

Web API connection

New API connection

Query for Salesforce API connection

Connecting Power BI to Deltek Vantagepoint API

Authenticating OData.Feed using Web API difficulty