I am fetching data from web service using POST method and using OAuth 2.0 authentication , which will generate access token using power query, after applying the query, I am getting an error: Invalid Client , I am passing client_secret, client_id & refresh token as per API docs in the content option, but getting an unexpected error:
let url="https://accounts.zoho.com/oauth/v2/token", contents=[#"refresh_token"="1000.1affXXXXXXXXXXXXXX"& "client_id"="1000.WRXXXXXXXx"& "client_secret"="10f6aaXXXXXXXXXX"& "grant_type"="refresh_token" ], result=Web.Contents(url,[Content=Json.FromValue(contents)]), Final=Json.Document(result)
When I pass the above parms in the POSTMAN it is giving me access token as requested, I don't know what is wrong in the above query, Pls help !!
Not sure what the issue is but you can just hard code the whole url like this. I saw the redirecturi in the documentation and see that you didn't have it (not sure if needed or not). If this works, but you then have scheduled refresh issue, you can use the RelativePath and/or query paramters of Web.Contents.
After checking again with the API docs, redirecturi is not the mandatory parameter to pass in the request call, As Postman is giving me the correct response without using redirecturi parameter that means, there is something wrong with my written query, I've followed your above written query, but now it is showing : Web.Contents failed to get contents from 'https://accounts.zoho.com/oauth/v2/token/?