Caspio REST with Microsoft power automate

[EvSam]

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. 

[andRe]

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. 

[autonumber]

Hi - Just adding this link for authenticating and using REST API in Caspio that might help - https://howto.caspio.com/web-services-api/rest-api/authenticating-rest/