Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |