Show TOC

XMLDoc Stream to ESP Formatter Module ConfigurationLocate this document in the navigation structure

The XMLDoc Stream to ESP formatter parses XML format strings, extracts data according to the schema file specified in the adapter configuration file, and translates this data to AepRecord objects. Set values for this formatter in the adapter configuration file.

This formatter is streaming based and can connect two streaming based transporters rather than row based transporters.
XML Element Description
XmlElemMappingRowPattern

Type: string

(Required) Specify a pattern to indicate which XML elements in the XML doc are processed by the formatter. The matched elements are mapped to ESP rows whose attributes and child elements are mapped as columns of a row. The adapter ignores any XML elements that do not match this pattern.

This pattern is a subset of XPath expressions. The [/]?NCName[/NCName]* path expression is the only supported expression, where NCName (Non-Colonized Name) is the local name element without a prefix or namespace.

If the elements in the path expression include a namespace URI (prefix), all of these elements belong to the same namespace. Provide the namespace in the XmlElemNamespace element.

Here are some examples of valid path expressions:

  • /RootElement
  • ParentElement
  • ParentElement/ChildElement
  • /RootElement/ParentElement
XmlElemNamespace

Type: string

(Required) Specify the namespace URI for elements that appear in the pattern path expression.
ColsMapping

(Required) Element containing the Column element.
Column

Type: string

(Required) Specify which attributes or child elements of the XML elements, which are matched by pattern path expression, to map to columns of the ESP row. For example, [<Column>XPath expression</Column>]+.

The XPath expression is any valid XPath expression specified by an XPath specification. The XPath expression can begin only from the last XML element that appears in the path pattern expression or its decedent elements.

The first <Column/> element value is mapped to the first column of the ESP row, the second <Column/> element value is mapped to the second column of the ESP row, and so on.
SecondDateFormat

Type: string

(Optional) Format string for parsing SecondDate values.

For example, yyyy-MM-dd'T'HH:mm:ss is the default value.
MSDateFormat

Type: string

(Optional) Format string for parsing MsDate values.

For example, yyyy-MM-dd'T'HH:mm:ss.SSS is the default value.