Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

How to convert API call with credentials

Dear,  I have a Dataverse DataFlow that connects to a third party API, which uses simple authentication. In the first part, I get the accesstoken by putting my email address and password in the bod...
mahoneypat's avatar
mahoneypat
Microsoft Employee
4 years ago

Not sure how ofter your token needs to be refreshed, but one way would be to create a Dataflow with your token query, and then use that Dataflow as the source for the token.

 

Pat

 

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Hi Pat,

 

Would that mean that I somehow save the result of the first "accesstoken" dataflow somewhere in Dataverse? And then I should use that in the "real" dataflow?

If that's the case, I have not yet found a way to call Dataverse data in a dataflow, I probably missed the correct documentation for that somehow; can you point me to documentation / examples of your suggestion?

 

The token is only valid for a two minutes; I need to call the API every five minutes...

 

Thanks,Koen

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    4 years ago

    I was proposing to use a Dataflow that only you had access to (to secure the login info), and using the output of that in a second dataflow that holds the actual data.  Given your 2 and 5 minute requirements, I don't think that would work well.  I don't know a good way to do what you are looking to do. 

     

    Pat

     

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      4 years ago

      Hi Pat,
      Regardless of the fact it will not help in this particular case, I am still curious how you would "use the output" of one dataflow in another dataflow? Where would you store this output, and how would you fetch it in the other dataflow?
      I will continue looking for another solution for my original question.

      Thanks,

      Koen