Forum Discussion
Anonymous
6 years agoNot applicable
How to authenticate with a custom API in a custom connector, and store tokens for future API request
I'm having a very hard time finding any examples for my use case which I find surprising. I have an endpoint like "www.myCompany/login" that takes a username, password, and user type as a json array ...
SteveCampbell
Memorable Member
6 years agoHopefully this pattern can help get you started. You would need to finish to extract the info you need and maybe add headers / body and probably some edits depending how your data is returned
let
token_header = [
#"Content-Type" = "application/json",
#"Accept" = "*/*"
],
token_content = [
#"grant_type" = "client_credentials",
#"client_id" = #"clientid",
#"client_secret" = #"secret"
],
AccessTokenCall = (Web.Contents("https://XXX.com/v1/oauth2/token", [Headers = token_header, Content = Json.FromValue(token_content)])),
AccessToken= Json.Document(Source, 1252),
Headers=[
#"Authorization" = "Bearer " & AccessToken ,
#"Content-Type" = "application/json"
],
APICall = Web.Contents("https://XXX.com/v1/oauth2/token", [Headers = Headers])