Savant

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

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

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

JSON_FIELD(`Company Details`, "$.company_name")

JSON_FIELD

Find answers and get help from Intercom Support and Community Experts

Track the progress of all tickets related to your company.

{assigneeName} needs more information from you

Description	`JSON_FIELD()` retrieves a particular field specified by the JSON path from a JSON object. This is helpful for accessing specific data within a JSON structure.
Syntax	JSON_FIELD(`json`, j`son_path`)
Output	text

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