JSON_PATH
Извлекает данные из объектов JSON.
Синтаксис
JSON_PATH(path, JSON)
Аргументы
| Имя | Тип | Описание | Значение по умолчанию |
|---|---|---|---|
| путь | string | Выражение JSON Path | |
| JSON | string | Строка, содержащая документ JSON |
Примеры
| путь | JSON | Выходные данные |
|---|---|---|
"$[*].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"}]
|