> This page is for Glide Classic.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://www.glideapps.com/docs/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://www.glideapps.com/docs/_mcp/server.

# JSON

> Build and query JSON Objects.

The **JSON** integration allows you to work with data in JavaScript Object Notation format. This format is the most common way to store and work with data through APIs. When paired with the [**Call API** ](/docs/automation/integrations/call-api)integration, you can unlock infinite new ways to connect your Glide apps with other platforms.

> **Note**
>
> Just getting started with JSON? Check out our [guide to APIs and JSON to learn more](https://www.glideapps.com/blog/introduction-to-apis).

## JSON Object

The **JSON Object** feature allows you to build JSON objects from your data. JSON objects contain key-value pairs, consisting of a key (or string type) and a value.

When you create JSON objects in Glide, keys will be quoted values in strings, and values will be quoted or unquoted depending on the type of value. You can pull in values from columns in your data, or enter values manually. Note that if you enter string values manually, they must be entered with quotes.

The feature can be configured as a column in the [Data Editor](/docs/getting-started/introduction-to-the-data-editor) or as an action in the Layout or Workflow Editor.

#### Data Editor

#### JSON - Arcade 1

In the Data Editor, open the table you want to edit.

Add a new column by clicking the (**+**) plus symbol to the right of the table.

Give the column a name.

For type, search for **JSON Object** or navigate to **Integrations → JSON → JSON Object.**

Add as many key-value pairs as needed by clicking **+ Add Value**.

Select **Done.**

Your JSON objects should appear in the column immediately.

#### Layout Editor

#### JSON - Arcade 2

Create a column in your data to house the returned JSON.

Click on the plus (**+**) sign in the **Component** panel to add a new component that supports actions, or select an existing component to add an action.

In the **General** tab on the right side of the Layout Editor, navigate to the **Actions** section and search for **JSON Object** or navigate to **Integrations → JSON → JSON Object.**

Select the icon and title for your action.

Add as many key-value pairs as needed by clicking **+ Add Value**.

For **Resulting JSON**, select the column you created to store this data.

Add conditions to the action, if desired. These will limit when the action is allowed to trigger.

Click away from the configuration menu. Your settings will save automatically.

#### Workflow Editor

#### JSON - Arcade 3

Create a column in your data to house the returned JSON.

Select the (**+**) plus symbol or the **+ New Workflow** button.

Select as the data source for the action the data source of the screen where the action is triggered.

Search for **Query JSON** or navigate to **Integrations → JSON → JSON Object.**

Add as many key-value pairs as needed by clicking **+ Add Value**.

For **Resulting JSON**, select the column you created to store this data.

Click away from the configuration menu. Your settings will save automatically.

## Query JSON

The **Query JSON** feature allows you to parse, or pull out, part of a JSON object. Glide uses JSONata as our querying language.

> **Note**
>
> Want to learn more about querying JSON? We recommend checking out [JSONata](https://jsonata.org/) to learn more.

When setting up Query JSON, you will have the option of choosing values from a menu. This menu will show an example value for each element, pulled from the first row of your data. To pull out multiple types of values into different columns, create a new **Query JSON** for each one. The feature can be configured as a column in the Data Editor or as an action in the Layout or Workflow Editor.

#### Data Editor

#### JSON - Arcade 4

In the Data Editor, open the table you want to edit.

Add a new column by clicking the (+) plus symbol to the right of the table.

Give the column a name.

For type, search for **Query JSON** or navigate to **Integrations → JSON → Query JSON.**

For the **JSON** field, select the column with the JSON you want to parse.

For the **Query** field, when you click the three dots to open the column selector, you will see a list of the values from your JSON. You can choose from this list or type the key name of the value you want to parse out. For example, if you want to pull the values from the 'name' value, you could type 'name' in this field.

Select **Done.**

Your parsed values will appear immediately in the column.

#### Layout Editor

#### JSON - Arcade 5

Create a column in your data to house the transformed JSON.

Click on the plus (**+**) sign in the **Components** panel to add a new component that supports actions, or select an existing component to add an action.

In the **General** tab on the right side of the Layout Editor, navigate to the **Actions** section and search for **Query JSON** or navigate to **Integrations → JSON → Query JSON.**

Select the icon and title for your action.

For the **JSON** field, select the column with the JSON objects you want to parse.

For the **Query** field, when you click the three dots to open the column selector, you will see a list of the values from your JSON. You can choose from this list or type the key name of the value you want to parse out. For example, if you want to pull the values from the 'name' value, you could type 'name' in this field.

For the **Transformed JSON** field, use the column you created to store this data.

Add conditions to the action, if desired. These will limit when the action is allowed to trigger.

Click away from the configuration menu. Your settings will save automatically.

#### Workflow Editor

#### Json - Arcade 6

Create a column in your data to house the transformed JSON.

Select the (**+**) plus symbol or the **+ New Worfkflow** button.

Select as the data source for the action the data source of the screen where the action is triggered.

Search for **Query JSON** or navigate to **Integrations → JSON → Query JSON.**

For the **JSON** field, select the column with the JSON objects you want to parse.

For the **Query** field, when you click the three dots to open the column selector, you will see a list of the values from your JSON. You can choose from this list or type the key name of the value you want to parse out. For example, if you want to pull the values from the 'name' value, you could type 'name' in this field.

For the **Transformed JSON** field, use the column you created to store this data.

Click away from the configuration menu. Your settings will save automatically.

## JSON Template

The **JSON Template** feature allows you to build JSON objects by creating a template with variables you can then substitute with values from your data.

JSON objects contain key-value pairs, consisting of a key (or string type) and a value. To build these into a template in Glide, put each key in quotation marks and each value starting with a \$ symbol. For example, to build a template with key-value pairs for a person's name and age, the template JSON would look like this:

```
{
  "person": {
    "name": "$name",
    "age": $age
  }
}
```

You can then bind the values for name and age to existing column values in your data tables.

The feature can be configured as a column in the [**Data Editor**](/docs/getting-started/introduction-to-the-data-editor) or as an action in the Layout or Workflow Editor.

#### Data Editor

#### JSON Template - Arcade 1

In the Data Editor, open the table you want to edit.

Add a new column by clicking the (**+**) plus symbol to the right of the table.

Give the column a name.

For type, search for **JSON Template** or navigate to **Integrations → JSON → JSON Template.**

Enter the JSON template. Format keys `'like this'` and values `$likethis`

Bind the template keys to values from your columns. Add as many key-value pairs as needed by clicking **+ Add Value**.

Select **Done.**

Your JSON objects should appear in the column immediately.

#### Layout Editor

#### JSON Template - Arcade 2

Create a column in your data to house the returned JSON.

Click on the plus (**+**) sign in the **Component** panel to add a new component that supports actions, or select an existing componentto add an action.

In the **General** tab on the right side of the Layout Editor, navigate to the **Actions** section and search for **JSON Template** or navigate to **Integrations → JSON → JSON Template.**

Select the icon and title for your action.

Enter the JSON template. Format keys `'like this'` and values `$likethis`

Bind the template keys to values from your columns. Add as many key-value pairs as needed by clicking **+ Add Value**.

For **Resulting JSON**, select the column you created to store this data.

Add conditions to the action, if desired. These will limit when the action is allowed to trigger.

Click away from the configuration menu. Your settings will save automatically.

#### Workflow Editor

#### JSON Template - Arcade 3

Create a column in your data to house the returned JSON.

Select the (**+**) plus symbol or the **+ New Workflow** button.

Select as the data source for the action the data source of the screen where the action is triggered.

Search for **JSON Template** or navigate to **Integrations → JSON → JSON Template.**

Enter the JSON template. Format keys `'like this'` and values `$likethis`

Bind the template keys to values from your columns. Add as many key-value pairs as needed by clicking **+ Add Value**.

For **Resulting JSON**, select the column you created to store this data.

Add conditions to the action, if desired. These will limit when the action is allowed to trigger.

Click away from the configuration menu. Your settings will save automatically.

## Frequently Asked Questions

#### Is the JSON integration free?

Yes! The JSON integration is included in all plans.

#### Can I create nested JSON objects?

At this time the **JSON** integration does not support creating nested objects. To work around this, you can first create a column for the nested data, then pull that column into your JSON Object construction.

#### I'm getting an error icon on my manual string value.

Make sure you put the value in quotes. Quotes are required for custom string values.