How to set values of configuration variables dynamically based on a query success handler?

[Uddyalok_Chakraborty]

I am trying to set up the value of the configuration variable based on a query but unable to figure out how

[Paulo]

Hi @Uddyalok_Chakraborty, welcome to the forum!

This is only possible on an Enterprise plan using the Retool API.

1. Create a REST API Resouce query and make a PUT request to /api/v2/configuration_variables/{id}, passing the new value in the body of the request:
   

   

2. Attach this Resource query as a success event handler to your existing query.