I'm trying to use retool to automate the sending of mandril emails following a snowflake query.
I've been able to connect a single api request successfully with a JSON object as a mock datasource. Running through a loop, however, I can't call an object's values in by api body (i can successfully call {{value}} in the url parameters strangely .
A number of us are having a similar issue. The Retool team is aware but having difficulties trying to reproduce the problem on their end to make a fix.
Tess suggested I try to recreate the loop lambda and it fixed a similar issue I was having.
For example, in your loop, pick something else (like where mine is selected to retool workflow) and then reselect it to the thing you actually want. It seems to fix whatever issue was causing it not to be able to read the {{value}}.