Jump to content
  • 0

Caspio REST with Microsoft power automate



Hey caspio universe, I am trying to use the Caspio REST API via Microsoft power automate and was wondering if anyone out there has made any flows with caspio? I have been experimenting with creating a custom connector and using the HTTP trigger but can't seem to get the authentication to work. Has anyone else gotten this to work? PA's HTTP trigger can use Basic Authentication but I can't see to get the authentication work that way. 

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Hey, @EvSam

Yes, we made it work with PowerAutomate.  And yes, this may be tricky :)

Even though Caspio's authentication is based on OAuth2, it's implemented differently than you may get used to. Unlike other applications, Microsoft PA Custom Connector will not help you to authenticate to Caspio (at least, I don't know how to do it).

To make it work, we implemented two supporting flows that work on schedule:

1) Gets the Refresh token and saves it to an environment variable (as plain text or Azure Key Vault, whatever makes more sense for you). This flow may work once a year, based on the expiration time of the Refresh token; 

2) Gets the Access token (using the Refresh token from the environment variable) and saves it to an environment variable. This flow may work once a day; 

The main flows use Basic authentication, using the Bearer token from the environment variable.

I hope it will help. 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...