I am trying to make a regular, plain HTTP request without getting the popup to specify authentication to get Power BIs approval. The API I am trying to call uses a non-standed authentication that the web authentication wizard will not let me do. I just want to make a plain HTTP request from M, specifying the authentication headers myself. Why is this so hard to do?
I was directed towards WebAction.Request to make a plain HTTP request, but I get the error "Object reference is not set to an instance of an object". The docs says that it "Creates an action that, when executed, will return the results of performing a method request against url using HTTP as a binary value.". What exactly is an "action" that it is referring to and how do I execute it? I cannot find any documentation on what exactly an action is or how to retrieve the response from it.
I wrote this function to make requests to this API, but I get "Object reference is not set to an instance of an object" when I try to call it:
let
Source = (path as text, query as record) =>
let
response = WebAction.Request("get", Text.Combine({"https://xxxxxxxxxxxx.xxx/v4_6_release/apis/3.0", path}), [
Headers = [
Authorization = "Basic xxxxxxxxxxx",
#"Content-Type" = "application/json",
clientId = "xxxxxxxxxxx"
],
Query = query
]),
json = Json.Document(response)
in
json
in
Source
