Page History
To see how to examine a JSON object, please read the following article first: Accessing json objects JSON OBJECTS in database schemas.
In some cases the JSON objects can also hold JSON objects themselves (nested objects). These can be identified because the text that appears on running an <OBJECT>::TEXT will have the following structure:
Code Block | ||
---|---|---|
| ||
{"<NESTED OBJECT NAME1>":{"COLUMN NAME 1": <value>, "COLUMN NAME 2": <value>, |
...
... etc}, {"<NESTED OBJECT NAME2>":{"COLUMN NAME 1": <value>, "COLUMN NAME 2": <value>, |
...
... etc}, |
...
... etc} |
Example:
Or:
To access elements of the nested elements you first need to get to the nested object itself and identify what information you want to get.
...