- use data source type
xml
,
connection string: http://SiteName/_vti_bin/Lists.asmx
the query is:
<Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
<Parameters>
<Parameter Name="listName">
<DefaultValue>Library Name</DefaultValue>
</Parameter>
<Parameter Name="viewName">
<DefaultValue>{E0C51281-6D2E-4F24-A600-BCC7D6D05166}</DefaultValue>
</Parameter>
<Parameter Name="rowLimit">
<DefaultValue>30000</DefaultValue>
</Parameter>
<Parameter Name="queryOptions" Type="xml">
<DefaultValue>
<QueryOptions>
<ViewAttributes Scope="Recursive"/>
</QueryOptions>
</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="True">*</ElementPath>
</Query>
view Name get from Library --> change View --> address --> queryString 'view'
comment: if the first row missing data in any field, the field not selected for all rows. so, replace code <ElementPath IgnoreNamespaces="True">*</ElementPath>
and write all columns you whant to select:
<ElementPath IgnoreNamespaces="True">
GetListitemsResponse/GetListItemsResult/listItems/data/row{@ows_ID,@ows_columnnName1,@ows_columnnName2}
</ElementPath>'