Savant

<code>json</code>: The JSON object.

<code>json_path</code>: The path to the specific field in the JSON object.

<code>value</code>: The new value to set for the specified field.

1. <code>json</code>: The JSON object.
2. <code>json_path</code>: The path to the specific field in the JSON object.
3. <code>value</code>: The new value to set for the specified field.

JSON_SET(`Company Details`, "$.date", TO_TEXT(TODAY()))

Sets a value for a specific field in JSON data

JSON_SET

Savant App

Savant Help

Find answers and get help from Intercom Support and Community Experts

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Title

Track the progress of all tickets related to your company.

Tickets portal.

{assigneeName} needs more information from you

Description	`JSON_SET()` modifies or adds a value to a specified field in a JSON object, identified by the JSON path. It's useful for updating or creating JSON data.
Syntax	JSON_SET(`json`, `json_path`, `value`)
Output	text

Company Details	JSON_SET
{"company_id": 1, "company_name": "ABC Inc.", "revenue": 500000, "location": "New York"}	{"company_id": 1, "company_name": "ABC Inc.", "revenue": 500000, "location": "New York", "date": "2023-12-14"}
{"company_id": 2, "company_name": "XYZ Corporation", "revenue": 750000, "location": "San Francisco"}	{"company_id": 2, "company_name": "XYZ Corporation", "revenue": 750000, "location": "San Francisco", "date": "2023-12-14"}
{"company_id": 3, "company_name": "LMN Enterprises", "revenue": 300000, "location": "Chicago"}	{"company_id": 3, "company_name": "LMN Enterprises", "revenue": 300000, "location": "Chicago", "date": "2023-12-14"}

Variables

Example