# To JSON

<figure><img src="/files/imPbwLVZ0OZ16B00t6dP" alt=""><figcaption></figcaption></figure>

## Overview

The To JSON Node provides a powerful way to combine multiple columns into a single column with structured data, such as arrays or objects. This is especially useful when dealing with hierarchical or relational data and wanting to keep related values bundled together.

<figure><img src="/files/YLyox2dqirTd79tCcfP9" alt=""><figcaption></figcaption></figure>

## Settings

![](/files/fO2QCuKwd1HsYTACY36B)

#### Combine values from

Select one or multiple columns that you want to combine into JSON.&#x20;

#### Into

Choose a type of JSON to combine all columns into: an array or object.

Object. When an object type is selected, the column name is used as a key name, and column values as values.

```
{
  "Gender": "M",
  "Country": "USA",
  "BirthYear": 1980
}
```

Array. If you select array type information about column names will be lost.

```
["USA", "M", 1980]
```

#### Column name

Enter a name for the new column or select the column you want to overwrite. If you want to overwrite values in an existing column, enable toggle **Overwrite** and select the required column.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.tabula.io/data-flows/tools-nodes/json-and-api/to-json.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
