JSON_EXTRACT_FIRST
This page describes the JSON_EXTRACT_FIRST function in Lenses SQL.
Last updated
This page describes the JSON_EXTRACT_FIRST 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 the first match, as a string 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:
✓ | ✓ |