---
title: JSONPATH
url: https://www.tines.com/docs/formulas/functions/jsonpath/
kind: formula-function
---

*[tines.com](https://www.tines.com/llms.txt) › [Docs](https://www.tines.com/llms.txt) › [Formulas](https://www.tines.com/llm/docs/formulas.md) › [Functions](https://www.tines.com/llm/docs/formulas/functions.md)*

# JSONPATH

*[View on tines.com](https://www.tines.com/docs/formulas/functions/jsonpath/)*

Evaluates objects using JSONPath expressions. Supports escaped and non-escaped JSON. JSONPath expressions support wildcards, filters, and slices. See [JSONPath](https://goessner.net/articles/JsonPath/) or the [Online Evaluator](https://jsonpath.com/) for more information. Please note: Tines uses [JSONPath](https://goessner.net/articles/JsonPath/) version 0.9.9, which may not support all features available in modern online JSONPath evaluators. More examples of how to use JSONPATH can be seen in our [Story Library](https://www.tines.com/story-library/87758/navigate-complex-data-structures-with-tines-jsonpath-function)

**Categories:** Objects

## Syntax

```
JSONPATH(object, path)
```

## Examples

### Example 1

Input:

```json
{
  "my_action": {
    "json": {
      "phoneNumbers": [
        {
          "name": "John",
          "type": "iPhone",
          "country": "Australia"
        },
        {
          "name": "Joe",
          "type": "Android",
          "country": "Australia"
        },
        {
          "name": "Jess",
          "type": "home",
          "country": "Ireland"
        }
      ]
    }
  }
}
```

Formula:

```
JSONPATH(my_action.json, "$.phoneNumbers[*].type")
```

Output:

```json
[
  "iPhone",
  "Android",
  "home"
]
```

## Sample actions

```json
{
  "standardLibVersion": "13",
  "actionRuntimeVersion": "2",
  "agents": [
    {
      "disabled": false,
      "name": "My Action",
      "description": "",
      "options": {
        "mode": "message_only",
        "loop": false,
        "payload": {
          "message": {
            "phoneNumbers": [
              {
                "name": "John",
                "type": "iPhone",
                "country": "Australia"
              },
              {
                "name": "Joe",
                "type": "Android",
                "country": "Australia"
              },
              {
                "name": "Jess",
                "type": "home",
                "country": "Ireland"
              }
            ]
          }
        }
      },
      "position": {
        "x": 1965,
        "y": 2895
      },
      "type": "eventTransformation",
      "timeSavedUnit": "minutes",
      "timeSavedValue": 0,
      "monitorAllEvents": false,
      "monitorFailures": false,
      "monitorNoEventsEmitted": null,
      "form": null
    },
    {
      "disabled": false,
      "name": "JSONPATH",
      "description": "",
      "options": {
        "mode": "message_only",
        "loop": false,
        "payload": {
          "jsonpath": "=JSONPATH(my_action, \"$.message.phoneNumbers[*].type\")"
        }
      },
      "position": {
        "x": 1815,
        "y": 3000
      },
      "type": "eventTransformation",
      "timeSavedUnit": "minutes",
      "timeSavedValue": 0,
      "monitorAllEvents": false,
      "monitorFailures": false,
      "monitorNoEventsEmitted": null,
      "form": null
    },
    {
      "disabled": false,
      "name": "JSONPATH",
      "description": "",
      "options": {
        "mode": "message_only",
        "loop": false,
        "payload": {
          "jsonpath": "=JSONPATH(my_action, \"$.message.phoneNumbers[*].name\")"
        }
      },
      "position": {
        "x": 1965,
        "y": 3000
      },
      "type": "eventTransformation",
      "timeSavedUnit": "minutes",
      "timeSavedValue": 0,
      "monitorAllEvents": false,
      "monitorFailures": false,
      "monitorNoEventsEmitted": null,
      "form": null
    },
    {
      "disabled": false,
      "name": "JSONPATH",
      "description": "",
      "options": {
        "mode": "message_only",
        "loop": false,
        "payload": {
          "jsonpath": "=JSONPATH(my_action,\"$..phoneNumbers[?(@.type=='home')].country\")"
        }
      },
      "position": {
        "x": 2115,
        "y": 3000
      },
      "type": "eventTransformation",
      "timeSavedUnit": "minutes",
      "timeSavedValue": 0,
      "monitorAllEvents": false,
      "monitorFailures": false,
      "monitorNoEventsEmitted": null,
      "form": null
    }
  ],
  "links": [
    {
      "sourceIdentifier": 0,
      "receiverIdentifier": 1
    },
    {
      "sourceIdentifier": 0,
      "receiverIdentifier": 2
    },
    {
      "sourceIdentifier": 0,
      "receiverIdentifier": 3
    }
  ],
  "diagramNotes": []
}
```