JSON_PATH
Extraherar data från JSON-objekt.
Syntax
JSON_PATH(path, JSON)
Argument
| Namn | Typ | Beskrivning | Standardvärde |
|---|---|---|---|
| sökväg | sträng | JSON-sökvägsuttryck | |
| JSON | sträng | En sträng som innehåller JSON-dokument |
Exempel
| sökväg | JSON | Utdata |
|---|---|---|
"$[*].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"}]
|