With test version 0.0.11, flow tokens for Advanced Flows are added for the flow action “Execute SQL query”.
Using these tokens, you can directly use the SQL result in your flow. With the new logic cards you canparse the reault JSON string and extract more than only the first field.
Example:
This flow is:
- executing the SELECT statement, reading one line from the table
- printing the result JSON string to the timeline
- extracting line1, field “gas_meter” from the JSON
- printing this value to the timeline
Current test version:
