FunctionsJSON

json_all_paths_with_types

Parses each JSON document and returns a JSON array of path:type entries for all observed nested values.

json_all_paths_with_types(…) → JSON

Kind · scalar

Parses each JSON document and returns a JSON array of path:type entries for all observed nested values.

Part of the JSON family.

json_all_paths

Parses each JSON document and returns a JSON array of observed nested paths in dot-and-index notation.

json_array_element

Returns the JSON element at the requested array index. Negative indexes count backward from the end.