Forum Discussion
Solved
Connect API with Header ApiKeyName not going through
Dear community, Im trying to connect my Excel/PowerBI and is not working. I read the entire forum and I could not reach the right answer for it. My provider gave me the following instructions...
Perhaps this might work too:
Yes, off course. It is working like this:
let
Source = Json.Document(Web.Contents("URL", [Headers=[#"x-api-key"="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"]])),
#"Converted to Table" = Record.ToTable(Source)
in
#"Converted to Table"
Very Niiice jasonfordx !!
But I have a question, you posted in the workspace and managed to put automatic update???