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'm attempting to submit the following in Power Query:
Web.Contents(
www.myurl.com/stuff.json
, [
Query = [
created = "[Select+Date+Range]&created_custom_gte=[" & EarlierstDate & "T00:00:00.000000+0000]"
]
]
)
However, when it actually makes the web call it's encoding the "created" parameter which is causing the API call to fail.
Expected: www.myurl.com/stuff.json?created=[Select+Date+Range]%26created_custom_gte=[2020-05-01T00:00:00.000000+0000]
Actual: www.myurl.com/stuff.json?%5BSelect%2BDate%2BRange%5D%26created_custom_gte%3D%5B2020-05-01T00%3A00%3A00.000000%2B0000%5D
Thanks!
Same here. Any suggestions?
@Anonymous , Looking at how url should go I think it should be like
Web.Contents(
"www.myurl.com/stuff.json",
, [
Query = [
created = "[Select+Date+Range]&created_custom_gte=[" & EarlierstDate & "T00:00:00.000000+0000]"
]
]
)
There is a good reference on dynamic URL here -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/
Not sure if I'm missing something... That looks like the exact code I put in the original post?
As stated, the query string encodes the value in the key value pair which causes the API request to fail.
Any solution?
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |