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.
Hi,
As per my understanding the below code :
Source = Json.Document(Web.Contents(url,[Content = [search = search,exec_mode=exec_mode,output_mode=output_mode,offset=offset,count=count]]))
will add query params to the url
How to send form params in the POST??? (equialent of -d in curl)
Solved! Go to Solution.
https://stackoverflow.com/questions/50151940/power-query-make-http-post-request-with-form-data
worked
let url = "https://example.com", body = "{ ""first_param"": ""AAAAA"", ""second_param"": ""BBBBBB""}", Parsed_JSON = Json.Document(body), BuildQueryString = Uri.BuildQueryString(Parsed_JSON), Source = Json.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/json"], Content = Text.ToBinary(BuildQueryString) ] )) in Source
https://stackoverflow.com/questions/50151940/power-query-make-http-post-request-with-form-data
worked
let url = "https://example.com", body = "{ ""first_param"": ""AAAAA"", ""second_param"": ""BBBBBB""}", Parsed_JSON = Json.Document(body), BuildQueryString = Uri.BuildQueryString(Parsed_JSON), Source = Json.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/json"], Content = Text.ToBinary(BuildQueryString) ] )) in Source
@Anonymous , refer if this can help
https://community.powerbi.com/t5/Desktop/How-to-run-POST-request-in-M/td-p/457138
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.