Forum Discussion
Some credentials arent validated problem
Hello,
This is how I call the API:
let
Source = Json.Document(Web.Contents("https://[URL o the site]/api-public/report/query/50", [Headers=[#"X-API-Key"="1234567890"]]), 65001),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
#"Converted to Table"
I'm calling all the API in the same way, but a few I skipped the "Test" and now I have this error that I can't fix, it seems.
When I try to update the credention of those with a problem, I get:
Failed to update data source credentials: Web.Contents failed to get contents from 'https://[SITE URL]/api-public/report/query/58' (400): Hide details
What I noticed is that all of the API that are ok has a "private Level Setting" selected.
The one that has a problem is missing that setup. I can choose any and I get the 400 error.
Hi efilipe
Can you try my below answer
Basically you are using X-key for the autentication to the API which is currently not a possible for Web Connector. so you can follow my workaround mentioned in the above link
