Get data from API

[chrisyan_manalu]

Hi All,

I got error while trying to get the data using web api with basic authentication. 

From the message error as I attached, is that true ?

Or any solution for my issue ? 

Please help

Thanks

[chrisyan_manalu]

Dear @PhilipTreacy 

Yes, Web.BrowserContents only supports anonymous connections

> Well noted. 

What exactly are you trying to do?

> I'm trying to get data using that API

If you need to provide authentication to an API you can use a different web connector and provide the auth that way

> I have been using all of these web conector in power bi like Web, OData, Web API but cannot reach the data

Thanks

[PhilipTreacy]

@chrisyan_manalu 

have you tried adapting my code to get your API data?

Please post the query you are currently using (removing any username and password) so I can see how it needs to be modified to get it working.

Regards

Phil

[PhilipTreacy]

Hi @chrisyan_manalu 

Yes, Web.BrowserContents only supports anonymous connections.  What exactly are you trying to do?

If you need to provide authentication to an API you can use a different web connector and provide the auth that way.  Something like this

let
    // Get the API Token
    api_url = "https://api.paypal.com/",
    token_path = "v1/oauth2/token",
    ClientID = "xxxxxxxx",
    Secret = "xxxxxxxx",
    
    EncodedCredentials = "Basic " & Binary.ToText(Text.ToBinary(ClientID & ":" & Secret), BinaryEncoding.Base64),
    
    Token_Response  = Json.Document(Web.Contents(api_url,
    [ 
      RelativePath = token_path,
      Headers = [#"Content-Type"="application/x-www-form-urlencoded",#"Authorization"=EncodedCredentials],
      Content=Text.ToBinary("grant_type=client_credentials")
    ]
    )
    ),
in 
    Token_Response

Further reading which may help you

Getting Started with API's in Power Query • My Online Training Hub

Connecting to an OAuth API Like PayPal With Power Query • My Online Training Hub

regards

Phil

[chrisyan_manalu]

Hi @PhilipTreacy 

Sorry for late replay.

I tried to using your code to get the data, but still no get that. 

If you dont mind, could you help me to write correctly. Currently, this is the code like this

(SelectedService as text,Authentication as text) =>
let
#"BaseURL" = "My Url", //this url just masking for your demo
#"ConstantVar" = "my constant var", //this url just masking for your demo
response = Web.Contents(
#"BaseURL",
[
Headers = [Authorization= Authentication],
RelativePath = #"ConstantVar" & SelectedService
]
),
jsonResponse = Json.Document(response),
Navigation = jsonResponse[data],
#"Navigation 1" = Navigation{0},
#"Converted to table" = Record.ToTable(#"Navigation 1"),
#"Transposed table" = Table.Transpose(#"Converted to table"),
#"Promoted headers" = Table.PromoteHeaders(#"Transposed table", [PromoteAllScalars = true])
in
#"Promoted headers" 

Thanks