ColumnSet XML Schema
This is a parameter that is passed into many API methods that retrieve data from the Microsoft CRM database. The following describes the schema for this parameter:
ColumnSetXml :=
<columnset
(page='page-number')?
(count='items-per-page')? >
( ColumnXml | OrderXml | FilterXml ) *
</columnset>
ColumnXml :=
<column>column-name</column>
OrderXml := AscendXml | DescendXml
AscendXml :=
<ascend>column-name</ascend>
DescendXml :=
<descend>column-name</descend>
FilterXml := SingleFilterXml | MultipleFilterXml
SingleFilterXml :=
<filter
column='column-name'
(attribute='attribute-name')?
operator=('eq' | 'neq' | 'like' )
value='value-data' />
MultipleFilterXml :=
<filter
attribute='column-name'
operator='in'
value='(value-data)?(,value-data)*' />
The following table shows the valid operators for filter.
Operator | Description |
Eq | Attribute equals value |
Neq | Attribute does not equal value |
Like | Attribute begins with value |