Specifies the format of the XML document.

Possible Values

XML, XMLTABLE

Data Type

string

Default Value

"XML"

Remarks

The following XMLFormat configurations are available.

XML

XML is the default format, and should be used most of the time. This format uses the element or attribute name containing each value as that value's column name.

XMLTable

Use this format when the column name is separate from the data contained in that column. This is useful when the element or attribute containing the data has a generic name (like "Value"), instead of being specific to each column.

Note: When XMLFormat = XMLTable, DataModel does not need to be configured.

Example:

    <Report>
      <Table>
          <Row>
              <Value label="Customer">Mark Rodgers</Value>
              <Value label="SupportCost">89.28</Value>
              <Value label="ContractValue">299.99</Value>
          </Row>
          <Row>
              <Value label="Customer">Hank Howards</Value>
              <Value label="SupportCost">225.63</Value>
              <Value label="ContractValue">0.00</Value>
          </Row>
      </Table>
    </Report>
  

The XPath property requires special syntax to identify the column and row paths. Each path is given with a prefix, depending on the type of path it is. All of the following are required:

• row: The XPath of the element that contains each row's data. In the above example, this is row:/Report/Table/Row
• name: The XPath of the element containing the column name. In the above example, this is column:/Report/Table/Row/Value@label
• value: The XPath of the element that contains each column's data inside the row. In the above example, this is value:/Report/Table/Row/Value

Each of these paths is separated by a semicolon, so the complete XPath for the above example is: row:/Report/Table/Row;name:/Report/Table/Row/Value@label;value:/Report/Table/Row/Value