JSON_PATH
Extrae datos de objetos JSON.
Sintaxis
JSON_PATH(path, JSON)
Argumentos
| Nombre | Tipo | Descripción | Valor predeterminado |
|---|---|---|---|
| path | cadena de caracteres | Expresión de ruta JSON | |
| JSON | cadena de caracteres | Una cadena que contiene un documento JSON |
Ejemplos
| path | JSON | Resultado |
|---|---|---|
"$[*].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"}]
|