Forum Discussion

Chiniminiz's avatar
Chiniminiz
Frequent Visitor
5 years ago
Solved

Power Query REST API with Token and additional value - How to add this additional value?!

Hello everybody,   we try to connect to a data source via REST API with the Post method and Web.Content(). This source can be normally reached and set up via browser. Here we created a reporting u...
Need Help
Tutorial Requests
Chiniminiz's avatar
Chiniminiz
Frequent Visitor
5 years ago

Hi v-jingzhang,

 

with the video, other sources and a little bit try and error I got the connection.

 

The code is 

let
    Source = 
    Json.Document(
        Web.Contents(
            LoadURL,
            [
                Headers=[#"Content-Type"="application/json",
                #"Origin"= "Servername.domain.de", 
                #"X-Best-Auth" = "#SecurityKey"],
                Content= info
            ]
        )
    ),
    
in
    Source

 

The problem was, to give the REST API the correct content (Body). This must be in a JSON format. So we needed a Table, which has to be converted into JSON format, which forward to the API in the Content.

Also the Origin and the Auth-Code has to be used in the Header and not like usually in the Content.

 

Thanks for your help and hopefully I help with this post others with an similar problem.