JSON_EXTRACT_ALL
This page describes the JSON_EXTRACT_ALL function in Lenses SQL.
Last updated
This page describes the JSON_EXTRACT_ALL function in Lenses SQL.
Last updated
2024 © Lenses.io Ltd. Apache, Apache Kafka, Kafka and associated open source project names are trademarks of the Apache Software Foundation.
Interprets ‘pattern’ as a Json path pattern and applies it to ‘json_string’, returning all matches, as an array of strings containing valid json. Examples for the pattern parameter: “$.a”, “$[‘a’]”, “$[0]”, “$.points[?(@[‘id’]==‘i4’)].x”, “$[‘points’][?(@[‘y’] >= 3)].id”, “$.conditions[?(@ == false)]”
Available in:
Processors | SQL Studio |
---|---|
Sample code:
Output:
✓
✓