Forum Discussion

DanT1994's avatar
DanT1994
Helper I
2 years ago
Solved

Connect to Web API with custom header

Hi,   I'm getting the following error when trying to connect a web API. Using an online API testing tool, my URL and custom header looks like this:   So, I'm maybe simplifying this too m...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    HI DanT1994,

    Perhaps you can try opt use following code to use web connector getting data with apikey in anonymous mode:

    let
    url="xxx.xxxxxx.com",
    apiKey = "key",
    headers = [

        #"CLICDATA-API-KEY" = apiKey,
        #"Content-Type" = "application/json"
    ],
    path="/api/xxx/xxx",
    request = Web.Contents(url, [ Headers = headers, RelativePath= path])
in
    request

    Using The RelativePath And Query Options With Web contents 

    Regards,

    Xiaoxin Sheng

lbendlin's avatar
lbendlin
Super User
2 years ago

As it says in the error message - you need to include the authentication either in the header or in the body.

  • DanT1994's avatar
    DanT1994
    Helper I
    2 years ago

    Thanks for the reply, please could you expand/advise how I'd do that?  I thought I had included my authentication key in the header (screenshot in original post).

    Thanks

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Go to Data Source settings, clear permissions for the API URL, and on next try use anonymous auth.

      • DanT1994's avatar
        DanT1994
        Helper I
        2 years ago

        It won't allow me to save the source, because of the above error, so I'm unable to go into data source settings and clear permissions...

        Thanks
        Dan