# JSON\_PATH

Extrait des données d'objets JSON.

## Syntaxe

```
JSON_PATH(path, JSON)
```

## Arguments

| Nom | Type | Description | Valeur par défaut |
| --- | --- | --- | --- |
| path | chaîne | Expression de chemin d'accès JSON |  |
| JSON | chaîne | Chaîne contenant un document JSON |  |

## Exemples

| path | JSON | Sortie |
| --- | --- | --- |
| `"$[*].author.name"` | `"[{"name": "The Great Gatsby", "author": {"name": "F. Scott Fitzgerald"}}, {"name": "Nineteen Eighty-Four", "author": {"name": "George Orwell"}}]` | `[F. Scott Fitzgerald, George Orwell]` |
| `"net_id"` | `"{ "net_id": 41 }"` | `41` |
| `"net_id"` | `"{ "net_id": [41, 42] }"` | `[41,42]` |
| `"net_id[*]"` | `"{ "net_id": [41, 42] }"` | [`41`, `42`] |
| `"net_id.parent"` | `"{ "net_id": [41, 42] }"` | null |
| `"$[*]"` | `"[1,2,3]"` | [`1`, `2`, `3`] |
| `"$[*].author"` | `"[{"name":"The Great Gatsby", "author":{"name": "F. Scott Fitzgerald"}}, {"name":"Nineteen Eighty-Four", "author": {"name": "George Orwell"}}]` | `[{"name":"F. Scott Fitzgerald"}, {"name":"George Orwell"}]` |