Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Connect to a Web Service sending parameters

Hi Community   I am trying to access a wb API. I am connecting using web connector. I need data based upon some query valuess. I am able to access the website for the basic table, but not sure how...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I've been trying to do this same thing a variety of ways and always run into an error (usually a 400 error), but now with this way, I am getting a "Please specify how to connect" even though I have hard coded the authorization header.. any thoughts? 

 

let
    auth_key = "Bearer MyApiKey",
    url = "https://myapi.com/analytics",
    header = [#"X-Impersonate-User"="UserKeyHere", Authorization=auth_key, #"Content-Type"="application/json"],
    content = "{
                ""start_date"":""2022-08-01T08:00:00.000Z"",
                ""end_date"":""2022-08-10T08:00:00.000Z"",
                ""space_ids"":[""1234""], 
                ""time_resolution"":""day"",
                }",
    webdata = Web.Contents(url, [Headers=header,Content = Text.ToBinary(content)]),
    response = Json.Document(webdata)
    in 
    response