Hi @adam3039,
According to your description, you want to get the token of restful api, right?
You can write a power query function to get token,then use this function as the parameter to call the api.
For detail information about get token, you can refer below article:
REST API Token-based Authentication
Call API Sample:
let
CallAPi= (
URI as text,
Username as text,
Token as text,
Paremeter as table,
optional Timeout as number
) as any =>
let
WebTimeout = if Timeout = null then #duration(0,0,0,100) else #duration(0,0,0,Timeout) ,
WebServiceContent = function(Paremeter),//format parameters to content
WebResponse = Web.Contents(Username&":"&Token&URI,
[Content = Text.ToBinary(WebServiceContent),
Headers = [Authorization="xxxxx",
#"Content-Type"="application/json",
Accept="application/json"],
Timeout = WebTimeout]),
output = formatfunction(WebResponse) //format the response
in
output
in
CallAPi
Regards,
Xiaoxin Sheng
