> For the complete documentation index, see [llms.txt](https://docs.cascade.io/cascade/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cascade.io/cascade/functions-and-expressions/functions/text/jsonparse.md).

# JSONPARSE

{% hint style="info" %}
Due to the complexity of parsing several rows of JSON, this function takes longer than the average Cascade function.
{% endhint %}

JSONPARSE( `Column`, `Name` )

Checks if a `column`  contains an input `name` within the Json path

### Arguments

| Input    | Description                                          |
| -------- | ---------------------------------------------------- |
| `column` | Column of json to parse and extract field for `name` |
| `name`   | String path to search for in `column`                |

### Output

Outputs field found in json

#### See documentation for further details: 

<https://jsonpath-rw.readthedocs.io/en/latest/#jsonpath-syntax>

### Example

| **Json**                                           | JSONPARSE( { Json }, "first" ) |
| -------------------------------------------------- | ------------------------------ |
| {"first" : "John", "middle" : "K", "last" : "Doe"} | "John"                         |
| {"first" : "Jane", "middle" : "J", "last" : "Doe"} | "Jane"                         |

### Example 2

| **Json**                                                        | JSONPARSE( { Json }, "name\[0].middle" ) |
| --------------------------------------------------------------- | ---------------------------------------- |
| {"name": \[{"first" : "John", "middle" : "K", "last" : "Doe"}]} | "K"                                      |
| {"name": \[{"first" : "Jane", "middle" : "J", "last" : "Doe"}]} | "J"                                      |