I currently have a workflow that takes in the following data from a retool application:
Selection 1
Selection 2
Start Date
End Date
Number
Selection 3
With these inputs it proceeds to do 5 Queries to a PostGreSQL database, some processing and data transformation and visual generation using Plotly. The final block of the workflow is a response block returning a some outputs from the processing blocks.
The main issue is that when I try to run the Workflow in a Query on the retool App. As soon as I click run, it takes 0.3s to say it has concluded with no errors, but nothing is returned.
(NOTE: When I check the run status on the Workflow page everything looks as it's supposed to, INCLUDING the response block output)
The only solution that I found was to add a random javascript code block to the workflow. I don't connect it to anything, just mark it as error handler and suddenly everything works as it should back in the application:
Do you have any logging you can compare with and without the random JS block? Aside from the standard logging, maybe add some console.log() or print() statements in your critical steps to see what variables are not getting passed with and without the random JS block?
Definitely seems odd. Other items to check would be making sure you are executing against the right environment (if you have multiple set up) and that you deployed the workflow. I can’t tell you how many times I was convinced a workflow wasn’t recognizing my code only to realize I was just running an old version…
The weird thing about is that when I check the run logs, the data outputs of each block is exactly the same, including for the response block.
Even though the app says the workflow took 0.3s to run, I can see that in the logs it actually takes4 seconds (which is what I expect). It tells me it successfully ran without it even finishing.
