Update Retool API Resources

Hi,

I have configured a resource of type Oracle DB on a Retool Cloud environment.

The way I am authenticating on my Oracle instance is using a Wallet Key file.

However, this wallet key expires once in a while, and then, I need a way to automatically update this resource with the new key.

Could we update the retool resource api to allow updating this custom value?

Thanks!

1 Like

The simple one-step solution for now is:

When your Wallet Key expires, manually go to your Oracle resource in Retool, edit it, and upload the new Wallet Key file.

This is currently the only direct way until Retool adds support for updating the key through their API.

Yes, exactly. I just would like to have an automatic solution for this. Can we consider this as a feature request for Retool Team? :slight_smile:

Hi @Marcus_Santos,

We can definitely look into this feature request! You want a way to run a query or API call to Retool's backend that would replace the wallet key on an existing Oracle DB resource for one specific app, correct?

I am curious, is this functionality outside the scope of a refresh flow for the resource? How are you getting the new wallet key when the old one expires?

Hi @Marcus_Santos,

Could you share a screenshot of how your Oracle resource is set up? I am not familiar with using Wallet Key files but I can definitely make a feature request for having an API endpoint to update the resource with a new file.

How are you imagining the event for updating the file to be triggered?