Summary of XML and JSON Output Formats

For examples of output formats, see Database Query Results in Result Details.

xml Retrieved rows will be formatted as XML. Applies to "SELECT FROM" statements only. The root node of the XML document is Output, which contains the Results element that contains one or more Result elements for multiple results. Each result contains one Data element.
xml-with-summary Retrieved rows will be formatted as XML with summary element. Applies to "SELECT FROM" statements only. The root node of the XML document is Output, which contains the Results element that contains one or more Result elements for multiple results. Each result contains the Summary and Data elements. The summary element contains some information about the columns specified in the "SELECT FROM" statement, including column name, column (data) type, and approximate column size.
json Retrieved rows will be formatted as JSON. Applies to "SELECT FROM" statements only. The top level tag is output. The tag at the next level is results, which for a JSON object contains one or more results represented by a JSON array. Each result contains one JSON object with the data tag.
json-with-summary Retrieved rows will be formatted as JSON with summary. Applies to "SELECT FROM" statements only. The top level tag is output. The tag at the next level is results which for a JSON object contains one or more results represented by a JSON array. Each result contains two JSON objects with the summary and data The summary value contains some information about the columns specified in the "SELECT FROM" statement, including column name, column (data) type, and approximate column size.