# Parse JSON Fields

If your dataset has a field that contains data in a JSON format, you can parse that field to display the specific pieces of data you want in new columns. You can do this by creating a new custom field and then passing it a value that references the JSON field. 

Let's explain this more in-depth by using the following example.

Suppose you have a field that has JSON data like the following:

```javascript
{
  "fields": {
    "pricing": {
      "integerValue": "109"
    },
    "quantity": {
      "integerValue": "98"
    }
  }
}
```

Without changing anything, it will be displayed like this:

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

#### To parse this data and make it more readable, follow these steps:

1. Edit the data type for the field with your JSON data. It will be *Text* by default; change it to JSON.\
   Here you can also change how the data in this column is displayed within this field – as either text or as fields.

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

2. Create a new Computed Field with the data you want
   1. Click *Add computed column* in the table menu on the right
   2. Pass the correct value to your field:\
      \- Click the *ƒx Formula* button\
      \- Choose the field from your table that has your JSON data\
      \- Choose the JSON field and value that you need
   3. Give your column an appropriate name
   4. Adjust the data type for your field as necessary

<figure><img src="/files/6KmLdDj9xGWi7NTs6laU" alt=""><figcaption></figcaption></figure>

3. (Optional) Hide the field with the JSON data by clicking on the slider next to the field name in the Table menu

<figure><img src="/files/3b1IfQ1Dbc8CtuJQIZP7" alt=""><figcaption></figcaption></figure>


---

# 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.jetadmin.io/user-guide/computed-columns/formulas/parse-json-fields.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.