Forum Discussion
Helper IIAPI auth - Use parameter instead of Data Source Setting GUI
Hi All
Very new to Power BI but slowly figuring things out. I have a json API source that currently uses a web source and Basic authentication via the Data Source GUI. This works great.
Username: <API Key>
Password: Blank
I would like to set the API key as a parameter and reference it in a query instead of using the GUI - Something like below (with FreshserviceAuthHeader as the parameter):
(PageNo as number) =>
let
Source = Json.Document(Web.Contents(FreshserviceBaseURL,
[RelativePath="/tickets?",
Query=[workspace_id="2",
page=Number.ToText(PageNo),
Headers=[Authorization="Basic "&FreshserviceAuthHeader]]))
in
Source
But this doesn't work. Is this technically possible?
Thanks
change your data source settings to anonymous auth.
10 Replies
- lbendlin
Super User
RelativePath must be only "tickets"
Usually an APIKey is part of the URL but consult the documentation of your API for the details. Spacing is important so use
Headers=[Authorization="Basic " & FreshserviceAuthHeader]
MyThumbsClickThanks for your help. I went back to the API documentation and found this article detailing how to connect via powershell.
Running that powershell script with the Base64 key works (and i can get data from the API).
$credPair = "<your-freshservice-api-token>:."; $encodedCredentials = [System.Convert]::ToBase64String([System.Text.Encoding]::ASCII.GetBytes($credPair)); $headers = @{ Authorization = "Basic $encodedCredentials" }; $url = "https://<your-subdomain>.freshservice.com/api/v2/tickets/1?include=assets"; $Response = Invoke-WebRequest -Uri $url -Method Get -Headers $headers -UseBasicParsing; $Response.Content;The format for the headers line matches what you suggested and what i have in my query but i get the following error:
- lbendlin
Show the definition of FreshServiceBaseURL
- lbendlin
no, the ) afterwards.
- MyThumbsClick
That was a typo in my post. Heres what it currently looks like:
let Source = Json.Document(Web.Contents(FreshserviceBaseURL, [RelativePath="tickets", Headers=[Authorization="Basic " & FreshserviceAuthHeader]])) in Source- lbendlin
change your data source settings to anonymous auth.