Need help to connect to a appi with a appi key

[Krijgerss]

hello i want to connect to a appi by the way of the advance editor within the powerquery i used this code

now if i want to connect i get the datasource error : " web.contents with the option content only support anomeus " what do i need to change in my code so i can connect to the api the Api has a API TOKEN so i need to put a api key in the M-code


many thanks

[Daryl-Lynch-Bzy]

Hi @Krijgerss - it is difficult to help.  Have you tried testing this API call in Postman?

My gut instinct is that you need to include the API key in the Header.   It is similar to the approach described here: Accessing REST APIs with Basic Auth and API Key in Power Query | John Dalesandro

Consider moving it from the Web.Content step to the options step, where you have added Content Type. 

options = 
[
   #"Content-Type" = "abc",
   "ApiKeyName" = "xyz"
]

If your API Key has been added into the Connection Credential.  It will need to be deleted and replaced with "Anonymous" setting like this instead on being included in the "Web API" panel.