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

DanT1994's avatar
DanT1994
Helper I
2 years ago

Unfortunately if I do that, the data source wont be there so the 'edit permissions'/'clear permissions' boxes are greyed out.  There's no way of clearing the permissions at the same time as adding the data source...

lbendlin's avatar
lbendlin
Super User
2 years ago

Now would be as good as any time to start over, with a new PBIX file...