Skip to content

XML Document

Type Registry

XML Document

container.object.xml

XML (Extensible Markup Language) document stored as VARCHAR. Structured hierarchical data with tags and attributes. RECURSIVE INFERENCE: When classified as container.object.xml, FineType will: 1. Parse XML and identify root element 2. Extract and classify child element values 3. Return as nested struct (partial, may require schema)

Domain container›object
Casts to VARCHAR
Scope Universal

Try it

CLI 
$ finetype infer -i "<root><name>John</name><age>30</age></root>"
→ container.object.xml

DuckDB

Detect 
SELECT finetype('<root><name>John</name><age>30</age></root>');
-- → 'container.object.xml'
Cast expression 
CAST({col} AS VARCHAR)
Safe cast pipeline 
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'container.object.xml';

Decompose

RECURSIVE_INFER_ON_XML_CHILDREN({col})

JSON Schema

finetype schema container.object.xml 
{
  "$id": "https://noon.sh/schemas/container.object.xml",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "XML (Extensible Markup Language) document stored as VARCHAR. Structured hierarchical data with tags and attributes.\nRECURSIVE INFERENCE: When classified as container.object.xml, FineType will: 1. Parse XML and identify root element 2. Extract and classify child element values 3. Return as nested struct (partial, may require schema)",
  "examples": [
    "<root><name>John</name><age>30</age></root>",
    "<user id=\"123\"><email>[email protected]</email></user>"
  ],
  "pattern": "^<.*>.*</.*>$",
  "title": "XML Document",
  "type": "string"
}

Examples

<root><name>John</name><age>30</age></root><user id="123"><email>[email protected]</email></user>

Also known as

xml_document

Types in container