SharePoint2007Provider::QueryListItems
This procedure of the Site Data service performs a query against the specified SharePoint list.
Arguments
| Input Arguments | Required | Description |
|---|---|---|
<target> |
Yes |
The URL of the Windows SharePoint Services administration site. |
<siteGUID> |
Yes |
The globally unique identifier (GUID) of the Windows SharePoint Services site collection. |
<subSiteGUID> |
Yes |
The GUID of the subsite. |
<list> |
Yes |
The GUID of the list enclosed in curly braces ({}). This GUID is returned by GetLists. |
<rowLimit> |
Yes |
A 32-bit unsigned integer that specifies the number of rows to return in the query. |
<Where> |
Yes |
The Where clause that specifies a filter for the query. |
<ViewFields> |
Yes |
A ViewFields element that specifes which fields to return in the query. |
Remarks
No remarks.
Sample Code
Example XML Request
<request>
<procedure>
<execute namespace="SharePoint2007Provider" procedure="QueryListItems" impersonate="1">
<executeData>
<target>https://WSSFE:8080</target>
<siteGUID>103d9567-521e-4c06-b80d-54372264d43d</siteGUID>
<subSiteGUID>505da4d2-9831-4b3e-9b33-7d372dc16c2a</subSiteGUID>
<list>{01515d5a-3a99-4b94-8ad2-ab54075ed978}</list>
<rowLimit>1000</rowLimit>
<where>
<lt>
<fieldRef name="ID" />
<value type="Counter">3</value>
</lt>
</where>
<viewFields>
<fieldRef name="ID" />
<fieldRef name="Title" />
</viewFields>
</executeData>
<after source="executeData" destination="data" mode="merge" />
</execute>
</procedure>
<context>
<securityContext>
<authentication>
<basic username="Fabrikam\Administrator" password="Pa$$word" />
</authentication>
</securityContext>
</context>
</request>
Example XML Response
An xml element that contains a schema and the data returned through the query.
<response>
<data>
<xml><xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='eltOnly' rs:CommandTimeout='30'>
<s:AttributeType name='ows_ID' rs:name='ID' rs:number='1'>
<s:datatype dt:type='i4' dt:maxLength='4' />
</s:AttributeType>
<s:AttributeType name='ows_ContentTypeId' rs:name='Content Type ID' rs:number='2'>
<s:datatype dt:type='int' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_ContentType' rs:name='Content Type' rs:number='3'>
<s:datatype dt:type='string' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_Title' rs:name='Title' rs:number='4'>
<s:datatype dt:type='string' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_Modified' rs:name='Modified' rs:number='5'>
<s:datatype dt:type='datetime' dt:maxLength='8' />
</s:AttributeType>
<s:AttributeType name='ows_Created' rs:name='Created' rs:number='6'>
<s:datatype dt:type='datetime' dt:maxLength='8' />
</s:AttributeType>
<s:AttributeType name='ows_Author' rs:name='Created By' rs:number='7'>
<s:datatype dt:type='string' dt:lookup='true' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_Editor' rs:name='Modified By' rs:number='8'>
<s:datatype dt:type='string' dt:lookup='true' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows__HasCopyDestinations' rs:name='Has Copy Destinations' rs:number='9'>
<s:datatype dt:type='boolean' dt:maxLength='1' />
</s:AttributeType>
<s:AttributeType name='ows__CopySource' rs:name='Copy Source' rs:number='10'>
<s:datatype dt:type='string' dt:maxLength='1073741823' />
</s:AttributeType>
<s:AttributeType name='ows_owshiddenversion' rs:name='owshiddenversion' rs:number='11'>
<s:datatype dt:type='i4' dt:maxLength='4' />
</s:AttributeType>
<s:AttributeType name='ows_WorkflowVersion' rs:name='Workflow Version' rs:number='12'>
<s:datatype dt:type='i4' dt:maxLength='4' />
</s:AttributeType>
<s:AttributeType name='ows__UIVersion' rs:name='UI Version' rs:number='13'>
<s:datatype dt:type='i4' dt:maxLength='4' />
</s:AttributeType>
<s:AttributeType name='ows__UIVersionString' rs:name='Version' rs:number='14'>
<s:datatype dt:type='string' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_Attachments' rs:name='Attachments' rs:number='15'>
<s:datatype dt:type='boolean' dt:maxLength='1' />
</s:AttributeType>
<s:AttributeType name='ows__ModerationStatus' rs:name='Approval Status' rs:number='16'>
<s:datatype dt:type='i4' dt:maxLength='4' />
</s:AttributeType>
<s:AttributeType name='ows__ModerationComments' rs:name='Approver Comments' rs:number='17'>
<s:datatype dt:type='string' dt:maxLength='1073741823' />
</s:AttributeType>
<s:AttributeType name='ows_LinkTitleNoMenu' rs:name='Title' rs:number='18'>
<s:datatype dt:type='string' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_LinkTitle' rs:name='Title' rs:number='19'>
<s:datatype dt:type='string' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_SelectTitle' rs:name='Select' rs:number='20'>
<s:datatype dt:type='i4' dt:maxLength='4' />
</s:AttributeType>
<s:AttributeType name='ows_InstanceID' rs:name='Instance ID' rs:number='21'>
<s:datatype dt:type='i4' dt:maxLength='4' />
</s:AttributeType>
<s:AttributeType name='ows_Order' rs:name='Order' rs:number='22'>
<s:datatype dt:type='float' dt:maxLength='8' />
</s:AttributeType>
<s:AttributeType name='ows_GUID' rs:name='GUID' rs:number='23'>
<s:datatype dt:type='string' dt:maxLength='38' />
</s:AttributeType>
<s:AttributeType name='ows_WorkflowInstanceID' rs:name='Workflow Instance ID' rs:number='24'>
<s:datatype dt:type='string' dt:maxLength='38' />
</s:AttributeType>
<s:AttributeType name='ows_FileRef' rs:name='URL Path' rs:number='25'>
<s:datatype dt:type='string' dt:lookup='true' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_FileDirRef' rs:name='Path' rs:number='26'>
<s:datatype dt:type='string' dt:lookup='true' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_Last_x0020_Modified' rs:name='Modified' rs:number='27'>
<s:datatype dt:type='datetime' dt:lookup='true' dt:maxLength='8' />
</s:AttributeType>
<s:AttributeType name='ows_Created_x0020_Date' rs:name='Created' rs:number='28'>
<s:datatype dt:type='datetime' dt:lookup='true' dt:maxLength='8' />
</s:AttributeType>
<s:AttributeType name='ows_FSObjType' rs:name='Item Type' rs:number='29'>
<s:datatype dt:type='ui1' dt:lookup='true' dt:maxLength='4' />
</s:AttributeType>
<s:AttributeType name='ows_PermMask' rs:name='Effective Permissions Mask' rs:number='30'>
<s:datatype dt:type='string' dt:maxLength='1073741823' />
</s:AttributeType>
<s:AttributeType name='ows_FileLeafRef' rs:name='Name' rs:number='31'>
<s:datatype dt:type='string' dt:lookup='true' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_UniqueId' rs:name='Unique Id' rs:number='32'>
<s:datatype dt:type='string' dt:lookup='true' dt:maxLength='38' />
</s:AttributeType>
<s:AttributeType name='ows_ProgId' rs:name='ProgId' rs:number='33'>
<s:datatype dt:type='string' dt:lookup='true' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_ScopeId' rs:name='ScopeId' rs:number='34'>
<s:datatype dt:type='string' dt:lookup='true' dt:maxLength='38' />
</s:AttributeType>
<s:AttributeType name='ows_File_x0020_Type' rs:name='File Type' rs:number='35'>
<s:datatype dt:type='string' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_HTML_x0020_File_x0020_Type' rs:name='HTML File Type' rs:number='36'>
<s:datatype dt:type='string' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows__EditMenuTableStart' rs:name='Edit Menu Table Start' rs:number='37'>
<s:datatype dt:type='string' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows__EditMenuTableEnd' rs:name='Edit Menu Table End' rs:number='38'>
<s:datatype dt:type='i4' dt:maxLength='4' />
</s:AttributeType>
<s:AttributeType name='ows_LinkFilenameNoMenu' rs:name='Name' rs:number='39'>
<s:datatype dt:type='string' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_LinkFilename' rs:name='Name' rs:number='40'>
<s:datatype dt:type='string' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_DocIcon' rs:name='Type' rs:number='41'>
<s:datatype dt:type='string' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_ServerUrl' rs:name='Server Relative URL' rs:number='42'>
<s:datatype dt:type='string' dt:maxLength='1073741823' />
</s:AttributeType>
<s:AttributeType name='ows_EncodedAbsUrl' rs:name='Encoded Absolute URL' rs:number='43'>
<s:datatype dt:type='string' dt:maxLength='1073741823' />
</s:AttributeType>
<s:AttributeType name='ows_BaseName' rs:name='File Name' rs:number='44'>
<s:datatype dt:type='string' dt:maxLength='1073741823' />
</s:AttributeType>
<s:AttributeType name='ows_MetaInfo' rs:name='Property Bag' rs:number='45'>
<s:datatype dt:type='int' dt:lookup='true' dt:maxLength='2147483646' />
</s:AttributeType>
<s:AttributeType name='ows__Level' rs:name='Level' rs:number='46'>
<s:datatype dt:type='ui1' dt:maxLength='1' />
</s:AttributeType>
<s:AttributeType name='ows__IsCurrentVersion' rs:name='Is Current Version' rs:number='47'>
<s:datatype dt:type='boolean' dt:maxLength='1' />
</s:AttributeType>
<s:AttributeType name='ows_Priority' rs:name='Priority' rs:number='48'>
<s:datatype dt:type='string' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_Status' rs:name='Status' rs:number='49'>
<s:datatype dt:type='string' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_PercentComplete' rs:name='% Complete' rs:number='50'>
<s:datatype dt:type='float' dt:maxLength='8' />
</s:AttributeType>
<s:AttributeType name='ows_AssignedTo' rs:name='Assigned To' rs:number='51'>
<s:datatype dt:type='string' dt:lookup='true' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_TaskGroup' rs:name='Task Group' rs:number='52'>
<s:datatype dt:type='string' dt:lookup='true' dt:maxLength='512' />
</s:AttributeType>
<s:AttributeType name='ows_Body' rs:name='Description' rs:number='53'>
<s:datatype dt:type='string' dt:maxLength='1073741823' />
</s:AttributeType>
<s:AttributeType name='ows_StartDate' rs:name='Start Date' rs:number='54'>
<s:datatype dt:type='datetime' dt:maxLength='8' />
</s:AttributeType>
<s:AttributeType name='ows_DueDate' rs:name='Due Date' rs:number='55'>
<s:datatype dt:type='datetime' dt:maxLength='8' />
</s:AttributeType>
</s:ElementType></s:Schema><rs:data ItemCount="1">
<z:row ows_ID='1' ows_ContentTypeId='0x01080054232E370568C340B366031BCE2831CF' ows_ContentType='Task' ows_Title='Task1' ows_Modified='2007-06-01 14:44:16' ows_Created='2007-06-01 14:44:16' ows_Author='3;#Administrator' ows_Editor='3;#Administrator' ows_owshiddenversion='1' ows_WorkflowVersion='1' ows__UIVersion='512' ows__UIVersionString='1.0' ows_Attachments='1' ows__ModerationStatus='0' ows_LinkTitleNoMenu='Task1' ows_LinkTitle='Task1' ows_SelectTitle='1' ows_Order='100.000000000000' ows_GUID='{1C2E29CD-47EA-43EF-9FBD-378414C1D3B0}' ows_FileRef='1;#sites/Test/Lists/Tasks/1_.000' ows_FileDirRef='1;#sites/Test/Lists/Tasks' ows_Last_x0020_Modified='1;#2007-06-01 14:44:16' ows_Created_x0020_Date='1;#2007-06-01 14:44:16' ows_FSObjType='1;#0' ows_PermMask='0x7fffffffffffffff' ows_FileLeafRef='1;#1_.000' ows_UniqueId='1;#{9A4C1FA8-80EB-4A0B-B3B9-84E0AE02D374}' ows_ProgId='1;#' ows_ScopeId='1;#{B0788E2F-031E-47B4-AA33-E6A859BC515D}' ows__EditMenuTableStart='1_.000' ows__EditMenuTableEnd='1' ows_LinkFilenameNoMenu='1_.000' ows_LinkFilename='1_.000' ows_ServerUrl='/sites/Test/Lists/Tasks/1_.000' ows_EncodedAbsUrl='https://wssfe:8888/sites/Test/Lists/Tasks/1_.000' ows_BaseName='1_' ows_MetaInfo='1;#' ows__Level='1' ows__IsCurrentVersion='1' ows_Priority='(2) Normal' ows_Status='Not Started' ows_Body='&lt;div&gt;&lt;/div&gt;' ows_StartDate='2007-06-01 00:00:00' />
</rs:data>
</xml></xml>
</data>
</response>
Applies To
Hosted Messaging and Collaboration version 4.5
Hosted Messaging and Collaboration version 4.0