I'm also curious about this!
Once I convert my transformer to be a JS query, how do I trigger it to refresh every time I call a REST query?
Do I need to wrap them both in a third JS query that manually triggers the "prep" query and the REST query?
This is all related to custom authentication to generate a signature for a REST API.
Hey @mattcaruso - great question! I'm wondering if applying a success event handler to the REST query would help you to trigger the refresh needed for the JS query?
I need the JS query to run before the REST query. And I may have multiple REST queries that utilize the same authentication logic. Your suggestion is reversed, unfortunately.
What action are you wanting to trigger the transformer turned JS query?
There is a "listener query" workaround that may help here. If you set up a query set to "Query JSON with SQL" and set it up to look something like this:
SELECT * FROM {{watchedInput.value}}
you could then set this query to run on input change, any time this input changes, this query should run, so next all we would need to do is add an event handler to run your JS query. Do you think this could work for your use case?
Also, wrapping them in another JS query that manually triggers as you mentioned above could suffice.