Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need to add Body
{ "method": "get", "params": { "SelectionCriteria": {}, "FieldNames": ["Id", "Name"] } }
in Web.Contents() query.
I can not understand how to do it.
Is this even possible in Web.Contents()?
_________________________________________
Current code:
let Source = Json.Document(Web.Contents("https://api-sandbox.direct.yandex.com/json/v5/campaigns", [Headers=[Authorization="Bearer AQAAAAANlKwBAAQQn4WfgbuD9xxxx"]])) in Source
Solved! Go to Solution.
Done!
Solution from here: https://eriksvensen.wordpress.com/2014/09/15/specifying-json-query-in-power-query-example-statistics...
let content = "{ ""method"": ""get"", ""params"": { ""SelectionCriteria"": {}, ""FieldNames"": [""Id"", ""Name""] } }", Source = Json.Document(Web.Contents("https://api-sandbox.direct.yandex.com/json/v5/campaigns", [Headers=[Authorization="Bearer AQAAAAANlKwBAAQQn4Wfgbxxxxxxxxxx"], Content=Text.ToBinary(content)])) in Source
Thanks for your post .
I am trying to do a similar connection to an url, however I don’t see the table with the information that I need.
This is the code I am using:
let
url = “https://urladdress”,
body = “{ “”statisticType””: “”[“”CMD_Stock””]””, “”startDate””: “”2020-04-07″” , “”endDate””: “”2020-04-07″” }”,
Source = Json.Document(Web.Contents(url,[Headers = [#”Content-Type”=”application/json”], Content = Text.ToBinary(body) ] ))
in
Source
I need to obtain the following structure in Power BI (a table with three columns):
statisticType startDate endDate
CMD_Stock 07/04/2020 07/04/2020
CMD_Stock 07/04/2020 07/04/2020
CMD_Stock 07/04/2020 07/04/2020
Can you help me? Thanks mdsr.
Hi @Vankod,
What requirement do you want to achieve by adding the body?
Add another blank query in Query Editor, then paste the following code in Advanced Editor, does it return your expected result?
let Source = Json.Document("[ { ""method"": ""get"", ""params"": { ""SelectionCriteria"": {}, ""FieldNames"": [""Id"", ""Name""] } }]") in Source
Thanks,
Lydia Zhang
Thanks, @v-yuezhe-msft!
It's return JSON body content. This is useful step
But how to use it in Web.Contents() query?
Done!
Solution from here: https://eriksvensen.wordpress.com/2014/09/15/specifying-json-query-in-power-query-example-statistics...
let content = "{ ""method"": ""get"", ""params"": { ""SelectionCriteria"": {}, ""FieldNames"": [""Id"", ""Name""] } }", Source = Json.Document(Web.Contents("https://api-sandbox.direct.yandex.com/json/v5/campaigns", [Headers=[Authorization="Bearer AQAAAAANlKwBAAQQn4Wfgbxxxxxxxxxx"], Content=Text.ToBinary(content)])) in Source
@VankodLovely, had wasted lot of time in trying to fect something, your reply helped me resolve it 🙂