Json

The json field type is designed for storing and manipulating structured data using JavaScript Object Notation. It is a flexible format ideal for capturing nested data, API responses, metadata, or any information that doesn't fit cleanly into traditional scalar fields.

Capabilities Overview

The json field type supports a wide range of automation capabilities, enabling rich integrations with external services and data manipulation tools. You can use it to store results from APIs like OpenAI, Slack, Google Calendar, Typesense, and more. Common use cases include storing parsed chat messages, transcription results, or structured documents retrieved from other services.

JSON fields can be queried and transformed using tools such as JSONPath, and can also power advanced functionality like semantic search or document partitioning. This makes them essential for AI, automation, and integration-heavy workflows.

For example using regex match operation the field can retrieve specific patterns from the JSON data.