# Parse nested values Shape / columns parse or build JSON, XML, URL, key-value, nested structs and lists Page: ## Status Runs as a SQL step. arcform carries it as a `sql:` step today. ## The DuckDB step read fields out of JSON It reads the `orders` table the proofs share. Create it first: ```sql CREATE TABLE orders AS SELECT * FROM (VALUES (1, 'Alice Ng', 'north', DATE '2026-01-03', 120.00, 'widget', 'a|b', '{"channel":"web","items":[1,2]}'), (2, 'alice ng', 'north', DATE '2026-01-05', 80.50, 'gadget', 'b', '{"channel":"shop","items":[3]}'), (3, 'Bob Okafor', 'south', DATE '2026-01-05', 300.00, 'widget', 'a|c', '{"channel":"web","items":[4,5,6]}'), (4, 'Carla Díaz', 'east', DATE '2026-01-09', NULL, 'gizmo', NULL, '{"channel":"web","items":[]}'), (5, 'Bob Okafor', 'south', DATE '2026-01-12', 45.25, 'gadget', 'c', '{"channel":"phone","items":[7]}'), (6, 'Dev Patel', 'west', DATE '2026-01-12', 510.00, 'widget', 'a', '{"channel":"web","items":[8,9]}'), (7, 'Carla Diaz', 'east', DATE '2026-01-20', 99.99, 'gizmo', 'b|c', '{"channel":"shop","items":[10]}'), (8, 'Dev Patel', 'west', DATE '2026-02-02', 510.00, 'widget', 'a', '{"channel":"web","items":[8,9]}'), (9, 'Eve Larsen', NULL, DATE '2026-02-03', 15.00, 'gadget', NULL, '{"channel":"web","items":[11]}'), (10, 'Alice Ng', 'north', DATE '2026-02-10', 220.00, 'gizmo', 'a|b|c', '{"channel":"phone","items":[12,13]}') ) t(order_id, customer, region, order_date, amount, product, tags, meta); ``` Then run the statement: ```sql CREATE TEMP TABLE result AS SELECT order_id, meta->>'channel' AS channel, json_array_length(meta->'items') AS n_items, from_json(meta, '{"channel":"VARCHAR","items":["INTEGER"]}') AS typed FROM orders; SELECT * FROM result; SELECT CASE WHEN ((SELECT sum(n_items) = 15 AND count(*) FILTER (WHERE channel = 'web') = 6 AND max(typed.items[3]) = 6 FROM result)) THEN 'as expected' ELSE error('the JSON fields did not come out as 15 items, 6 web orders and a typed list') END AS verdict; ``` It needs nothing installed beyond DuckDB itself. ## Variants - Combine rows into one nested value: Gather the values of many rows into a single JSON, XML or list value. - [Convert a document between formats](https://meridian.online/operations/parse-nested-values/convert-document-between-formats): Turn a JSON, XML, HTML or EDIFACT document into the same content in another of those formats. - Decode log, network and binary records: Parse syslog, HL7, email header, NetFlow, IP, Avro or binary payloads into separate fields. - [Extract values by path](https://meridian.online/operations/parse-nested-values/extract-values-by-path): Pull the values at chosen JSON paths, XPaths or field names out of a nested column into new columns. - [Spread nested fields into columns](https://meridian.online/operations/parse-nested-values/spread-nested-fields-into-columns): Lift every field of a struct or object column into its own top-level column, one row still per row. - [Work with list values](https://meridian.online/operations/parse-nested-values/work-with-list-values): Test, index, sort, filter, combine or summarise the elements inside list and array values. - [Work with map values](https://meridian.online/operations/parse-nested-values/work-with-map-values): Build maps, look up a key, list keys or values, and merge maps. - Other nested-value functions: General nested-type support and function families that mix building, reading and editing structs and unions. - [Pack columns into a nested value](https://meridian.online/operations/parse-nested-values/pack-columns-into-nested-value): Combine several columns of each row into one struct, list, JSON, XML or Avro column. - Parse text into a nested value: Turn a text column holding JSON, XML or key-value pairs into a typed nested value in the same column. - [Write a nested value as text](https://meridian.online/operations/parse-nested-values/write-nested-value-as-text): Turn a struct, list or JSON value back into a JSON text string. - Turn a nested document into table rows: Expand a JSON or XML document, or a list of records, into a table with one row per record or element. - [Restructure a document with a transform language](https://meridian.online/operations/parse-nested-values/restructure-document-with-transform-language): Rewrite a JSON or XML document with a stylesheet, patch or transform program such as XSLT, a JSON patch or jq. - [Split a URL into its parts](https://meridian.online/operations/parse-nested-values/split-url-into-parts): Extract the host, path, query parameters or other parts of a URL, or encode and decode URL text. ## What other tools call it Meridian's classification; an independent blind rating agreed on 86.2% of 312 rows (exact class, version 2). - Azure Data Factory: [`Array functions`](https://learn.microsoft.com/en-us/azure/data-factory/data-flow-array-functions) (read 2026-09-27) - Azure Data Factory: [`Collection functions`](https://learn.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions) (read 2026-09-27) - Azure Data Factory: [`Map functions`](https://learn.microsoft.com/en-us/azure/data-factory/data-flow-map-functions) (read 2026-09-27) - Azure Data Factory: [`Parse`](https://learn.microsoft.com/en-us/azure/data-factory/data-flow-parse) (read 2026-09-27) - Azure Data Factory: [`Stringify`](https://learn.microsoft.com/en-us/azure/data-factory/data-flow-stringify) (read 2026-09-27) - Alteryx Designer: [`JSON Build`](https://help.alteryx.com/current/en/designer/tools/laboratory/json-build-tool.html) (read 2026-09-27) - Alteryx Designer: [`JSON Parse`](https://help.alteryx.com/current/en/designer/tools/developer/json-parse-tool.html) (read 2026-09-27) - Alteryx Designer: [`XML Parse`](https://help.alteryx.com/current/en/designer/tools/parse/xml-parse-tool.html) (read 2026-09-27) - Bruin: [`bruin.get_url_host(field)`](https://getbruin.com/docs/bruin/assets/templating/macros.html) (read 2026-09-27) - Bruin: [`bruin.get_url_parameter(field, parameter)`](https://getbruin.com/docs/bruin/assets/templating/macros.html) (read 2026-09-27) - Bruin: [`bruin.get_url_path(field)`](https://getbruin.com/docs/bruin/assets/templating/macros.html) (read 2026-09-27) - Apache DataFusion: [`Array Functions`](https://datafusion.apache.org/user-guide/sql/scalar_functions.html) (read 2026-09-27) - Apache DataFusion: [`Field access (col['field'] and col[1])`](https://datafusion.apache.org/user-guide/features.html) (read 2026-09-27) - Apache DataFusion: [`Map Functions`](https://datafusion.apache.org/user-guide/sql/scalar_functions.html) (read 2026-09-27) - Apache DataFusion: [`Struct Functions`](https://datafusion.apache.org/user-guide/sql/scalar_functions.html) (read 2026-09-27) - Apache DataFusion: [`Support for nested types (ARRAY/LIST and STRUCT)`](https://datafusion.apache.org/user-guide/features.html) (read 2026-09-27) - Apache DataFusion: [`Union Functions`](https://datafusion.apache.org/user-guide/sql/scalar_functions.html) (read 2026-09-27) - Apache DataFusion: [`unnest (struct)`](https://datafusion.apache.org/user-guide/sql/special_functions.html) (read 2026-09-27) - dbt-utils: [`Array functions`](https://docs.getdbt.com/reference/dbt-jinja-functions/cross-database-macros) (read 2026-09-27) - dbt-utils: [`get_url_host`](https://raw.githubusercontent.com/dbt-labs/dbt-utils/main/README.md) (read 2026-09-27) - dbt-utils: [`get_url_parameter`](https://raw.githubusercontent.com/dbt-labs/dbt-utils/main/README.md) (read 2026-09-27) - dbt-utils: [`get_url_path`](https://raw.githubusercontent.com/dbt-labs/dbt-utils/main/README.md) (read 2026-09-27) - DuckDB: [`Array Functions (family)`](https://duckdb.org/docs/current/sql/functions/array) (read 2026-09-27) - DuckDB: [`List Functions (family)`](https://duckdb.org/docs/current/sql/functions/list) (read 2026-09-27) - DuckDB: [`Map Functions (family)`](https://duckdb.org/docs/current/sql/functions/map) (read 2026-09-27) - DuckDB: [`Nested Functions (family)`](https://duckdb.org/docs/current/sql/functions/nested) (read 2026-09-27) - DuckDB: [`Struct Functions (family)`](https://duckdb.org/docs/current/sql/functions/struct) (read 2026-09-27) - DuckDB: [`Union Functions (family)`](https://duckdb.org/docs/current/sql/functions/union) (read 2026-09-27) - Duckle: [`Array Distinct`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25) - Duckle: [`Array Length`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25) - Duckle: [`Contains`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25) - Duckle: [`Element At`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25) - Duckle: [`Flatten`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25) - Duckle: [`IP Parse`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25) - Duckle: [`JSONPath Extract`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25) - Duckle: [`Merge Objects`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25) - Duckle: [`Parse JSON`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25) - Duckle: [`Stringify JSON`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25) - Duckle: [`URL Parse`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/website/docs/components.html) (read 2026-09-25) - Duckle: [`jq Filter`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/frontend/src/workflow-ui/palette-data.ts) (read 2026-09-25) - EasyMorph: [`Construct JSON`](https://help.easymorph.com/doku.php?id=transformations:constructjson) (read 2026-09-27) - EasyMorph: [`Extract JSON properties`](https://help.easymorph.com/doku.php?id=transformations:extractjson) (read 2026-09-27) - EasyMorph: [`Modify JSON`](https://help.easymorph.com/doku.php?id=transformations:modifyjson) (read 2026-09-27) - EasyMorph: [`Parse JSON`](https://help.easymorph.com/doku.php?id=transformations:parsejson) (read 2026-09-27) - EasyMorph: [`Parse XML`](https://help.easymorph.com/doku.php?id=transformations:parsexml) (read 2026-09-27) - EasyMorph: [`Parse web form submission`](https://help.easymorph.com/doku.php?id=transformations:parseformsubmission) (read 2026-09-27) - EasyMorph: [`XSLT transformation`](https://help.easymorph.com/doku.php?id=transformations:xslt) (read 2026-09-27) - AWS Glue: [`Extract JSON path`](https://docs.aws.amazon.com/glue/latest/dg/transforms-extract-json-path.html) (read 2026-09-27) - AWS Glue: [`Flatten`](https://docs.aws.amazon.com/glue/latest/dg/transforms-flatten.html) (read 2026-09-27) - AWS Glue: [`Parse JSON column`](https://docs.aws.amazon.com/glue/latest/dg/transforms-parse-json-column.html) (read 2026-09-27) - AWS Glue: [`Simplify_ddb_json`](https://docs.aws.amazon.com/glue/latest/dg/aws-glue-api-crawler-pyspark-transforms-simplify-ddb-json.html) (read 2026-09-27) - AWS Glue: [`Unbox`](https://docs.aws.amazon.com/glue/latest/dg/aws-glue-api-crawler-pyspark-transforms-Unbox.html) (read 2026-09-27) - AWS Glue: [`UnnestFrame`](https://docs.aws.amazon.com/glue/latest/dg/aws-glue-api-crawler-pyspark-transforms-UnnestFrame.html) (read 2026-09-27) - AWS Glue: [`unnest_ddb_json`](https://docs.aws.amazon.com/glue/latest/dg/aws-glue-api-crawler-pyspark-extensions-dynamic-frame.html) (read 2026-09-27) - Apache Hop: [`Add XML`](https://hop.apache.org/manual/latest/pipeline/transforms/addxml.html) (read 2026-09-27) - Apache Hop: [`Avro decode`](https://hop.apache.org/manual/latest/pipeline/transforms/avro-decode.html) (read 2026-09-27) - Apache Hop: [`Avro encode`](https://hop.apache.org/manual/latest/pipeline/transforms/avro-encode.html) (read 2026-09-27) - Apache Hop: [`Edi to XML`](https://hop.apache.org/manual/latest/pipeline/transforms/edi2xml.html) (read 2026-09-27) - Apache Hop: [`XML Join`](https://hop.apache.org/manual/latest/pipeline/transforms/xmljoin.html) (read 2026-09-27) - Apache Hop: [`XSL pipeline`](https://hop.apache.org/manual/latest/workflow/actions/xslt.html) (read 2026-09-27) - Apache Hop: [`XSL transformation`](https://hop.apache.org/manual/latest/pipeline/transforms/xslt.html) (read 2026-09-27) - Ibis: [`Array`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayAll`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayAny`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayConcat`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayContains`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayDistinct`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayFilter`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayFlatten`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayIndex`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayIntersect`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayLength`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayMap`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayMax`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayMean`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayMin`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayMode`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayPosition`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayRemove`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayRepeat`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArraySlice`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArraySort`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayStringJoin`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/strings.py) (read 2026-09-27) - Ibis: [`ArraySum`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayUnion`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ArrayZip`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/arrays.py) (read 2026-09-27) - Ibis: [`ExtractAuthority`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/strings.py) (read 2026-09-27) - Ibis: [`ExtractFile`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/strings.py) (read 2026-09-27) - Ibis: [`ExtractFragment`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/strings.py) (read 2026-09-27) - Ibis: [`ExtractHost`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/strings.py) (read 2026-09-27) - Ibis: [`ExtractPath`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/strings.py) (read 2026-09-27) - Ibis: [`ExtractProtocol`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/strings.py) (read 2026-09-27) - Ibis: [`ExtractQuery`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/strings.py) (read 2026-09-27) - Ibis: [`ExtractUserInfo`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/strings.py) (read 2026-09-27) - Ibis: [`JSONGetItem`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/json.py) (read 2026-09-27) - Ibis: [`Map`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/maps.py) (read 2026-09-27) - Ibis: [`MapContains`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/maps.py) (read 2026-09-27) - Ibis: [`MapGet`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/maps.py) (read 2026-09-27) - Ibis: [`MapKeys`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/maps.py) (read 2026-09-27) - Ibis: [`MapLength`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/maps.py) (read 2026-09-27) - Ibis: [`MapMerge`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/maps.py) (read 2026-09-27) - Ibis: [`MapValues`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/maps.py) (read 2026-09-27) - Ibis: [`StructColumn`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/structs.py) (read 2026-09-27) - Ibis: [`StructField`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/structs.py) (read 2026-09-27) - Ibis: [`ToJSONArray`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/json.py) (read 2026-09-27) - Ibis: [`ToJSONMap`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/json.py) (read 2026-09-27) - Ibis: [`UnwrapJSONBoolean`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/json.py) (read 2026-09-27) - Ibis: [`UnwrapJSONFloat64`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/json.py) (read 2026-09-27) - Ibis: [`UnwrapJSONInt64`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/json.py) (read 2026-09-27) - Ibis: [`UnwrapJSONString`](https://github.com/ibis-project/ibis/blob/05d2b293344e86cb41c1a426071734f7e270335a/ibis/expr/operations/json.py) (read 2026-09-27) - KNIME Analytics Platform: [`Column to XML`](https://api.hub.knime.com/nodes/*VqkSwDBKksqolRKh?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`Columns to Collection`](https://api.hub.knime.com/nodes/*eNgVOpmMFNJq3Jie?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`Columns to JSON`](https://api.hub.knime.com/nodes/*S5sWr2sm-SjOA14S?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`JSON Column Combiner`](https://api.hub.knime.com/nodes/*YWufNYG_cCOXV2VP?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`JSON Diff`](https://api.hub.knime.com/nodes/*Xxi6agi_HN4F-Gnk?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`JSON Path`](https://api.hub.knime.com/nodes/*3IccdLfpFEAp9yoz?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`JSON Path (Dictionary)`](https://api.hub.knime.com/nodes/*2Nt0avhANQZN1ULo?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`JSON Row Combiner`](https://api.hub.knime.com/nodes/*C1zA3UfdJepeh0eb?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`JSON Transformer`](https://api.hub.knime.com/nodes/*wcERuaxFYqiU2d-0?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`JSON to Table`](https://api.hub.knime.com/nodes/*2xUDt4Z24aku4wiS?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`JSON to XML`](https://api.hub.knime.com/nodes/*AB2v7bC0nru1GHKf?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`Nominal Probability Distribution Creator`](https://api.hub.knime.com/nodes/*TD93rewy2eMlDiSJ?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`String to JSON`](https://api.hub.knime.com/nodes/*0v93iQ8V50L_6LVf?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`String to XML`](https://api.hub.knime.com/nodes/*Ez6XD4p5nN1wh_Lm?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`Table to JSON`](https://api.hub.knime.com/nodes/*xsMeCA0QgX92370E?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`XML Column Combiner`](https://api.hub.knime.com/nodes/*iY4Ln0a0nzW73ykY?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`XML Row Combiner`](https://api.hub.knime.com/nodes/*zLLBGgIKDOD7jlWh?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`XML to JSON`](https://api.hub.knime.com/nodes/*eyEk_DTTp2oTl6Ah?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`XPath`](https://api.hub.knime.com/nodes/*dTIN1LNlL6w1s7MX?details=full) (read 2026-09-27) - KNIME Analytics Platform: [`XSLT`](https://api.hub.knime.com/nodes/*tMnMemDSAwnOT-W_?details=full) (read 2026-09-27) - Apache NiFi: [`AttributesToCSV`](https://nifi.apache.org/components/org.apache.nifi.processors.standard.AttributesToCSV/) (read 2026-09-27) - Apache NiFi: [`AttributesToJSON`](https://nifi.apache.org/components/org.apache.nifi.processors.standard.AttributesToJSON/) (read 2026-09-27) - Apache NiFi: [`EvaluateJsonPath`](https://nifi.apache.org/components/org.apache.nifi.processors.standard.EvaluateJsonPath/) (read 2026-09-27) - Apache NiFi: [`EvaluateXPath`](https://nifi.apache.org/components/org.apache.nifi.processors.standard.EvaluateXPath/) (read 2026-09-27) - Apache NiFi: [`EvaluateXQuery`](https://nifi.apache.org/components/org.apache.nifi.processors.standard.EvaluateXQuery/) (read 2026-09-27) - Apache NiFi: [`ExtractEmailHeaders`](https://nifi.apache.org/components/org.apache.nifi.processors.email.ExtractEmailHeaders/) (read 2026-09-27) - Apache NiFi: [`ExtractHL7Attributes`](https://nifi.apache.org/components/org.apache.nifi.processors.hl7.ExtractHL7Attributes/) (read 2026-09-27) - Apache NiFi: [`FlattenJson`](https://nifi.apache.org/components/org.apache.nifi.processors.standard.FlattenJson/) (read 2026-09-27) - Apache NiFi: [`JSLTTransformJSON`](https://nifi.apache.org/components/org.apache.nifi.processors.jslt.JSLTTransformJSON/) (read 2026-09-27) - Apache NiFi: [`JoltTransformJSON`](https://nifi.apache.org/components/org.apache.nifi.processors.jolt.JoltTransformJSON/) (read 2026-09-27) - Apache NiFi: [`JoltTransformRecord`](https://nifi.apache.org/components/org.apache.nifi.processors.jolt.JoltTransformRecord/) (read 2026-09-27) - Apache NiFi: [`ParseNetflowv5`](https://nifi.apache.org/components/org.apache.nifi.processors.network.ParseNetflowv5/) (read 2026-09-27) - Apache NiFi: [`ParseSyslog`](https://nifi.apache.org/components/org.apache.nifi.processors.standard.ParseSyslog/) (read 2026-09-27) - Apache NiFi: [`ParseSyslog5424`](https://nifi.apache.org/components/org.apache.nifi.processors.standard.ParseSyslog5424/) (read 2026-09-27) - Apache NiFi: [`TransformXml`](https://nifi.apache.org/components/org.apache.nifi.processors.standard.TransformXml/) (read 2026-09-27) - OpenRefine: [`Array functions`](https://openrefine.org/docs/manual/grelfunctions#array-functions) (read 2026-09-27) - OpenRefine: [`Format-based functions (JSON, HTML, XML)`](https://openrefine.org/docs/manual/grelfunctions#format-based-functions-json-html-xml) (read 2026-09-27) - OpenRefine: [`Jsoup XML and HTML parsing`](https://openrefine.org/docs/manual/grelfunctions#jsoup-xml-and-html-parsing) (read 2026-09-27) - OpenRefine: [`URI parsing`](https://openrefine.org/docs/manual/grelfunctions#uri-parsing) (read 2026-09-27) - Pentaho Data Integration: [`Add XML`](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-transformation-steps-reference-overview) (read 2026-09-27) - Pentaho Data Integration: [`Edi to XML`](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-transformation-steps-reference-overview) (read 2026-09-27) - Pentaho Data Integration: [`HBase row decoder`](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-transformation-steps-reference-overview) (read 2026-09-27) - Pentaho Data Integration: [`XML Join`](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-transformation-steps-reference-overview) (read 2026-09-27) - Pentaho Data Integration: [`XSL Transformation`](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-transformation-steps-reference-overview) (read 2026-09-27) - Polars: [`DataFrame.to_struct`](https://docs.pola.rs/api/python/stable/reference/dataframe/export.html) (read 2026-09-27) - Polars: [`DataFrame.unnest`](https://docs.pola.rs/api/python/stable/reference/dataframe/modify_select.html) (read 2026-09-27) - Polars: [`Expr.arr (group)`](https://docs.pola.rs/api/python/stable/reference/expressions/array.html) (read 2026-09-27) - Polars: [`Expr.list (group)`](https://docs.pola.rs/api/python/stable/reference/expressions/list.html) (read 2026-09-27) - Polars: [`Expr.str: JSON (group)`](https://docs.pola.rs/api/python/stable/reference/expressions/string.html) (read 2026-09-27) - Polars: [`Expr.struct (group)`](https://docs.pola.rs/api/python/stable/reference/expressions/struct.html) (read 2026-09-27) - Polars: [`SQL functions: Array (group)`](https://docs.pola.rs/api/python/stable/reference/sql/functions/array.html) (read 2026-09-27) - Polars: [`concat_arr`](https://docs.pola.rs/api/python/stable/reference/expressions/functions.html) (read 2026-09-27) - Polars: [`concat_list`](https://docs.pola.rs/api/python/stable/reference/expressions/functions.html) (read 2026-09-27) - Polars: [`json_normalize`](https://docs.pola.rs/api/python/stable/reference/functions.html) (read 2026-09-27) - Polars: [`list`](https://docs.pola.rs/api/python/stable/reference/expressions/functions.html) (read 2026-09-27) - Polars: [`struct`](https://docs.pola.rs/api/python/stable/reference/expressions/functions.html) (read 2026-09-27) - Power Query M: [`Binary functions`](https://learn.microsoft.com/en-us/powerquery-m/binary-functions) (read 2026-09-27) - Power Query M: [`Json.FromValue`](https://learn.microsoft.com/en-us/powerquery-m/accessing-data-functions) (read 2026-09-27) - Power Query M: [`List functions`](https://learn.microsoft.com/en-us/powerquery-m/list-functions) (read 2026-09-27) - Power Query M: [`Record functions`](https://learn.microsoft.com/en-us/powerquery-m/record-functions) (read 2026-09-27) - Power Query M: [`Table.CombineColumnsToRecord`](https://learn.microsoft.com/en-us/powerquery-m/table-functions#transformation) (read 2026-09-27) - Power Query M: [`Table.ExpandRecordColumn`](https://learn.microsoft.com/en-us/powerquery-m/table-functions#transformation) (read 2026-09-27) - Power Query M: [`Table.FromColumns`](https://learn.microsoft.com/en-us/powerquery-m/table-functions#table-construction) (read 2026-09-27) - Power Query M: [`Table.FromList`](https://learn.microsoft.com/en-us/powerquery-m/table-functions#table-construction) (read 2026-09-27) - Power Query M: [`Table.FromRecords`](https://learn.microsoft.com/en-us/powerquery-m/table-functions#table-construction) (read 2026-09-27) - Power Query M: [`Table.FromRows`](https://learn.microsoft.com/en-us/powerquery-m/table-functions#table-construction) (read 2026-09-27) - Power Query M: [`Table.FromValue`](https://learn.microsoft.com/en-us/powerquery-m/table-functions#table-construction) (read 2026-09-27) - Power Query M: [`Table.ToColumns`](https://learn.microsoft.com/en-us/powerquery-m/table-functions#conversions) (read 2026-09-27) - Power Query M: [`Table.ToList`](https://learn.microsoft.com/en-us/powerquery-m/table-functions#conversions) (read 2026-09-27) - Power Query M: [`Table.ToRecords`](https://learn.microsoft.com/en-us/powerquery-m/table-functions#conversions) (read 2026-09-27) - Power Query M: [`Table.ToRows`](https://learn.microsoft.com/en-us/powerquery-m/table-functions#conversions) (read 2026-09-27) - Power Query M: [`Uri functions`](https://learn.microsoft.com/en-us/powerquery-m/uri-functions) (read 2026-09-27) - RapidMiner Studio: [`Data To JSON`](https://docs.rapidminer.com/latest/studio/operators/extensions/Text%20Processing/utility/data_to_json.html) (read 2026-09-27) - RapidMiner Studio: [`Decode URLs`](https://docs.rapidminer.com/latest/studio/operators/extensions/Web%20Mining/utility/decode_urls.html) (read 2026-09-27) - RapidMiner Studio: [`Encode URLs`](https://docs.rapidminer.com/latest/studio/operators/extensions/Web%20Mining/utility/encode_urls.html) (read 2026-09-27) - RapidMiner Studio: [`Extract Content`](https://docs.rapidminer.com/latest/studio/operators/extensions/Web%20Mining/html_processing/extract_html_text_content.html) (read 2026-09-27) - RapidMiner Studio: [`Extract Information`](https://docs.rapidminer.com/latest/studio/operators/extensions/Text%20Processing/extraction/extract_information.html) (read 2026-09-27) - RapidMiner Studio: [`Generate Extract`](https://docs.rapidminer.com/latest/studio/operators/extensions/Text%20Processing/generation/generate_extract.html) (read 2026-09-27) - RapidMiner Studio: [`HTML to XML`](https://docs.rapidminer.com/latest/studio/operators/extensions/Text%20Processing/transformation/html_to_xml.html) (read 2026-09-27) - RapidMiner Studio: [`JSON To Data`](https://docs.rapidminer.com/latest/studio/operators/extensions/Text%20Processing/utility/json_to_data.html) (read 2026-09-27) - RapidMiner Studio: [`JSON to XML`](https://docs.rapidminer.com/latest/studio/operators/extensions/Web%20Mining/utility/json_to_xml.html) (read 2026-09-27) - RapidMiner Studio: [`Process XSLT`](https://docs.rapidminer.com/latest/studio/operators/extensions/Text%20Processing/transformation/process_xslt.html) (read 2026-09-27) - Apache SeaTunnel: [`JsonPath`](https://seatunnel.apache.org/docs/2.3.13/transforms/jsonpath) (read 2026-09-27) - Talend: [`tDSQL4JSON`](https://help.qlik.com/talend/en-US/components/8.0/data-mapping/data-mapping-component) (read 2026-09-27) - Talend: [`tEDIFACTtoXML`](https://help.qlik.com/talend/en-US/components/8.0/xml/xml-component) (read 2026-09-27) - Talend: [`tExtractDynamicFields`](https://help.qlik.com/talend/en-US/components/8.0/processing/processing-component) (read 2026-09-27) - Talend: [`tExtractJSONFields`](https://help.qlik.com/talend/en-US/components/8.0/processing/processing-component) (read 2026-09-27) - Talend: [`tExtractXMLField`](https://help.qlik.com/talend/en-US/components/8.0/processing/processing-component) (read 2026-09-27) - Talend: [`tWriteAvroFields`](https://help.qlik.com/talend/en-US/components/8.0/processing/processing-component) (read 2026-09-27) - Talend: [`tWriteDynamicFields`](https://help.qlik.com/talend/en-US/components/8.0/processing/processing-component) (read 2026-09-27) - Talend: [`tWriteJSONField`](https://help.qlik.com/talend/en-US/components/8.0/processing/processing-component) (read 2026-09-27) - Talend: [`tWriteXMLField`](https://help.qlik.com/talend/en-US/components/8.0/xml/xml-component) (read 2026-09-27) - Talend: [`tWriteXMLFields`](https://help.qlik.com/talend/en-US/components/8.0/processing/processing-component) (read 2026-09-27) - Talend: [`tXMLMap`](https://help.qlik.com/talend/en-US/components/8.0/txmlmap/txmlmap-component) (read 2026-09-27) - Talend: [`tXSLT`](https://help.qlik.com/talend/en-US/components/8.0/xml/xml-component) (read 2026-09-27) - Trifacta: [`Convert key/value to Object`](https://help.alteryx.com/aac/en/trifacta-classic/reference/transformation-reference.html) (read 2026-09-27) - Trifacta: [`Extract query strings`](https://help.alteryx.com/aac/en/trifacta-classic/reference/transformation-reference.html) (read 2026-09-27) - Trifacta: [`Extractkv Transform`](https://help.alteryx.com/aac/en/trifacta-classic/wrangle-language/language-appendices/transforms.html) (read 2026-09-27) - Trifacta: [`Nest Transform`](https://help.alteryx.com/aac/en/trifacta-classic/wrangle-language/language-appendices/transforms.html) (read 2026-09-27) - Trifacta: [`Nest columns`](https://help.alteryx.com/aac/en/trifacta-classic/reference/transformation-reference.html) (read 2026-09-27) - Trifacta: [`Nested Functions (group)`](https://help.alteryx.com/aac/en/trifacta-classic/wrangle-language/nested-functions.html) (read 2026-09-27) - Trifacta: [`Unnest Transform`](https://help.alteryx.com/aac/en/trifacta-classic/wrangle-language/language-appendices/transforms.html) (read 2026-09-27) - Trifacta: [`Unnest elements`](https://help.alteryx.com/aac/en/trifacta-classic/reference/transformation-reference.html) (read 2026-09-27) - VisiData: [`addcol-selector`](https://github.com/saulpw/visidata/blob/7609212ec2febafa9caba7183cbebfaf49627909/visidata/loaders/scrape.py#L176) (read 2026-09-23) - VisiData: [`addcol-xmlattr`](https://github.com/saulpw/visidata/blob/7609212ec2febafa9caba7183cbebfaf49627909/visidata/loaders/xml.py#L258) (read 2026-09-23) - VisiData: [`contract-col`](https://github.com/saulpw/visidata/blob/7609212ec2febafa9caba7183cbebfaf49627909/visidata/features/expand_cols.py#L191) (read 2026-09-23) - VisiData: [`contract-col-depth`](https://github.com/saulpw/visidata/blob/7609212ec2febafa9caba7183cbebfaf49627909/visidata/features/expand_cols.py#L193) (read 2026-09-23) - VisiData: [`contract-cols`](https://github.com/saulpw/visidata/blob/7609212ec2febafa9caba7183cbebfaf49627909/visidata/features/expand_cols.py#L192) (read 2026-09-23) - VisiData: [`contract-cols-depth`](https://github.com/saulpw/visidata/blob/7609212ec2febafa9caba7183cbebfaf49627909/visidata/features/expand_cols.py#L194) (read 2026-09-23) - VisiData: [`contract-source-cols`](https://github.com/saulpw/visidata/blob/7609212ec2febafa9caba7183cbebfaf49627909/visidata/features/expand_cols.py#L196) (read 2026-09-23) - VisiData: [`dive-xml-table`](https://github.com/saulpw/visidata/blob/7609212ec2febafa9caba7183cbebfaf49627909/visidata/loaders/xml.py#L260) (read 2026-09-23) - VisiData: [`expand-col`](https://github.com/saulpw/visidata/blob/7609212ec2febafa9caba7183cbebfaf49627909/visidata/features/expand_cols.py#L186) (read 2026-09-23) - VisiData: [`expand-col-depth`](https://github.com/saulpw/visidata/blob/7609212ec2febafa9caba7183cbebfaf49627909/visidata/features/expand_cols.py#L188) (read 2026-09-23) - VisiData: [`expand-cols`](https://github.com/saulpw/visidata/blob/7609212ec2febafa9caba7183cbebfaf49627909/visidata/features/expand_cols.py#L187) (read 2026-09-23) - VisiData: [`expand-cols-depth`](https://github.com/saulpw/visidata/blob/7609212ec2febafa9caba7183cbebfaf49627909/visidata/features/expand_cols.py#L189) (read 2026-09-23)