Forum Discussion

akashgera's avatar
akashgera
Helper I
5 years ago

Pull data from web service using POST method

Hello Folks, 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 ...
Need Help
mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Please try this instead.  You need to make a record in your contents step.

 

= 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)

in
Final

 

Pat

  • akashgera's avatar
    akashgera
    Helper I
    5 years ago

    Thanks for the response, I've tried with the below query as well, but still getting the same error: invalid_client

    let
    url="https://accounts.zoho.com/oauth/v2/token",
    contents=[refresh_token="1000.1afXXXXXXXXXXXXXX",
    client_id="1000.WXXXXXXXXXXXXXXXX",
    client_secret="10fXXXXXXXXXXXX",
    grant_type="refresh_token"
    ],
    result=Web.Contents(url,[Content=Json.FromValue(contents)]),
    Final=Json.Document(result)

    in
    Final

     

    • mahoneypat's avatar
      mahoneypat
      Microsoft Employee
      5 years ago

      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.

       

      let
      url="https://accounts.zoho.com/oauth/v2/token",
      refreshtoken="1000.1affXXXXXXXXXXXXXX",
      clientid="1000.WRXXXXXXXx",
      clientsecret="10f6aaXXXXXXXXXX",
      granttype="refresh_token",
      redirecturi = "????",
      finalurl = "https://accounts.zoho.com/oauth/v2/token?refresh_token=" & refreshtoken & "&client_id=" & clientid & "&client_secret=" & clientsecret & "&redirect_uri=" & redirecturi & "&grant_type=" & granttype,
      result=Web.Contents(finalurl),
      Final=Json.Document(result)

      in
      Final

       

      Pat

      • akashgera's avatar
        akashgera
        Helper I
        5 years ago

        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/?