MeridianMERIDIAN

XML Document

XML (Extensible Markup Language) document stored as VARCHAR. Structured hierarchical data with tags and attributes.

XML Document

container.object.xml

XML (Extensible Markup Language) document stored as VARCHAR. Structured hierarchical data with tags and attributes.

Domain
container
Category
object
Casts to
VARCHAR
Scope
Universal

Try it

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

DuckDB

Detect
SELECT ft_infer('<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(ft_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE ft_infer(my_column) = 'container.object.xml';

Decompose

Expression
RECURSIVE_INFER_ON_XML_CHILDREN({col})

JSON Schema

finetype taxonomy container.object.xml -o json-schema
{
  "$id": "https://meridian.online/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",
  "x-finetype-label": "container.object.xml",
  "x-finetype-pii": false
}

Examples

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

Aliases

xml_document

Type Registry