tbl_json object where each row corresponds to a leaf
in the JSON structure. The first row corresponds to the JSON document as
a whole. If the document is a scalar value (JSON string, number, logical
or null), then there will only be 1 row. If instead it is an object or
an array, then subsequent rows will recursively correspond to the elements
(and their children) of the object or array.
a json string or tbl_json object
The columns in the
tbl_json returend are defined as
document.id 1L if
.x is a single JSON string, otherwise
the index of
parent.id the string identifier of the parent node for this
level what level of the hierarchy this child resides at,
0L for the root and incrementing for each level
of nested array or object.
index what index of the parent object / array this child
resides at (from
gather_array for arrays).
child.id a unique ID for this leaf in this document,
represented as <parent>.<index> where <parent> is the ID for the
parent and <index> is this index.
seq the sequence of names / indices that led to this child
(parents that are arrays are excluded) as a list, where character
strings denote objects and integers denote array positions
name if this is the value of an object, what was the name that
it is listed under (from
type the type of this object (from
length the length of this object (from
json_schema to create a schema for a JSON document or
1 2 3 4 5 6 7 8 9 10 11 12
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.