Render Data as JSON
Create JSON Objects from your data for flexible use in actions and automations
All beta features are available to users before official release. Your testing and feedback are an enormous help, please leave any feedback or bug reports you have at [email protected] Note that beta features are not guaranteed to be supported or compatible in the future.
JSON objects have already been natively supported for PostgreSQL and Redshift. Historically we allow users to dynamically render json data in a template using mustache:
{{#column_name}}
{{name}} is name
{{/column_name}}
We're adding support for iterating over JSON objects in action templates for more data sources.
We have introduced a naming convention to append the prefix
type_json_
to a column which will signal LogicLoop to parse the column value into JSON. All columns you return whose names start will type_json
will be parsed as JSON.
Example Query Casting String Response to JSON Object
Once you have a rule that creates a JSON object, you can use the JSON object in an action. You can use action templating to iterate over and access the values in your objects.

This feature is only available when triggering the action under the setting:
For each row returned
Last modified 5mo ago