Docs
  • LogicLoop Documentation
  • LogicLoop Quickstart
  • Data Sources
    • Connect your data source
      • Deployment options
    • Supported data sources
      • API data (JSON)
      • AWS CloudWatch
      • BigQuery
      • Databricks
      • Google Analytics
      • Google Sheets
      • MongoDB
      • Microsoft SQL Server
      • MySQL
      • Oracle
      • PostgreSQL
      • Snowflake
      • Combine Results
      • LogicLoop Data Source
  • Queries
    • Write a rule
      • More rule options
      • A/B testing rules
      • Version history
      • Query Snippets
    • Visualizations & dashboards
      • Visualizations
      • Dashboards
  • Actions
    • Set up an action
    • Action destinations
      • Email
      • Slack
      • Webhooks & APIs
      • Microsoft Teams
      • Salesforce
      • Zapier
      • PagerDuty
      • Write to Database
      • Chain Rules
      • Google Sheets
      • Bento
    • Templating
  • Case Management
    • Case Management
      • Ticket Generation
      • Case Triage
      • Custom Fields and Attachments
  • AI
    • AI Query Helper
    • Ask AI
  • Teams & Settings
    • Integrations
      • Slack
      • Google Sheets
    • Invite your teammate
    • Groups & Permissions
  • Changelog
  • FAQs
  • Troubleshooting
  • Templates
    • Templates Home
    • Risk & Fraud Rules
    • AML Transaction Monitoring Rules
    • Logistics & Marketplace Ops
    • Customer Success & Growth
    • Systems Observability
    • Data Quality Monitoring
    • Healthcare
    • HTML Email Templates
      • Annual Review
      • Weekly Performance Table
      • Invoice Recap
  • BETA
    • AI SQL API
    • Approving rules
    • Render Data as JSON
    • Case Analytics
    • Python
  • Security & Legal
    • Security
    • AI Security
    • Terms of use
    • Privacy policy
    • Services description
Powered by GitBook
On this page

Was this helpful?

  1. BETA

Render Data as JSON

Create JSON Objects from your data for flexible use in actions and automations

PreviousApproving rulesNextCase Analytics

Last updated 2 years ago

Was this helpful?

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 support@logicloop.com. Note that beta features are not guaranteed to be supported or compatible in the future.

Using JSON in Templates

JSON objects have already been natively supported for PostgreSQL and Redshift. Historically we allow users to dynamically render json data in a template using

{{#column_name}}
{{name}} is name
{{/column_name}}

We're adding support for iterating over JSON objects in action templates for more data sources.

Format your Data as a JSON object

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.

Use Your Object in an Action

This feature is only available when triggering the action under the setting:

For each row returned

Once you have a rule that creates a JSON object, you can use the JSON object in an action. You can use to iterate over and access the values in your objects.

action templating
mustache:
Example Query Casting String Response to JSON Object