Forum Discussion
Authentication Issue while connecting to API with OAuth 2.0
I am able to get the access token Dynamically, but could not able to retrieve data.
Please help me with this issue. Below is the M code for your reference
Thank you.
let // Define API details
tokenUrl = "https://auth.servicetitan.io/connect/token",
apiUrl = "https://api.servicetitan.io/crm/v2/tenant/{tenant_id}/export/customers",
clientId = "%client_id%",
clientSecret = "%client_secret%",
// Get access token
tokenResponse = Json.Document(Web.Contents(tokenUrl, [
Content = Text.ToBinary("grant_type=client_credentials&client_id=" & clientId & "&client_secret=" & clientSecret & "&scope=" & scope),
Headers = [
Authorization = "Basic " & Binary.ToText(Text.ToBinary(clientId & ":" & clientSecret), BinaryEncoding.Base64),
Accept = "application/json",
#"Content-Type" = "application/x-www-form-urlencoded"
],
ManualStatusHandling = {400, 401, 403}
])),
accessToken = if Record.HasFields(tokenResponse, "access_token") then tokenResponse[access_token] else error "Failed to get access token",
// Call API with the access token
apiResponse = Web.Contents(apiUrl, [Headers=[Accept="application/json"]])
// Return data
in apiResponse
you need to present the token as part of your last API call. It goes into the Headers part.
Please follow the documentation. https://learn.microsoft.com/en-us/powerquery-m/web-contents
3 Replies
- lbendlinSuper User
you need to present the token as part of your last API call. It goes into the Headers part.
Please follow the documentation. https://learn.microsoft.com/en-us/powerquery-m/web-contents
- v-menakakotaCommunity Support
Hi Sri1999 ,
Thank you lbendlin for providing possible solution. I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you. - Sri1999Frequent Visitor
Thanks for your help. It actually worked.