OData服务未返回完整响应
|
我正在使用Odata RESTful服务读取Sharepoint列表数据（> 20000个条目），如此处所述-http：//blogs.msdn.com/b/ericwhite/archive/2010/12/09/getting-started-using-the-odata -rest-api-a-sharepoint-list.aspx查询
我能够读取数据，但仅获得前1000条记录。我还检查了Sharepoint服务器上的“列表视图限制”是否设置为5000。好心提醒。
更新：
@Turker：你的答案就在眼前！！非常感谢你。我能够在第一次迭代中获得前2000条记录。但是，我在while循环的每次迭代中都得到相同的记录。我的代码如下-
...initial code...
int skipCount =0;
while (((QueryOperationResponse)query).GetContinuation() != null)
{
//query for the next partial set of customers
query = dc.Execute<CATrackingItem>(
((QueryOperationResponse)query).GetContinuation().NextLinkUri
);
//Add the next set of customers to the full list
caList.AddRange(query.ToList());
var results = from d in caList.Skip(skipCount)
select new
{
Actionable = Actionable,
}; Created = d.Created,
foreach (var res in results)
{
structListColumns.Actionable = res.Actionable;
structListColumns.Created= res.Created;
}
skipCount = caList.Count;
}//Close of while loop
没有找到相关结果
已邀请:
3 个回复
刷骸码
提要的末尾，这表示该服务正在实现服务器端分页，您需要发送查询以获取下一组结果。讹巳漓把备
DataServiceContext ctx = new DataServiceContext(new Uri(\"http://services.odata.org/Northwind/Northwind.svc\")); QueryOperationResponse<Customer> response = (QueryOperationResponse<Customer>)ctx.CreateQuery<Customer>(\"Customers\").Execute(); do { foreach (Customer c in response) { Console.WriteLine(c.CustomerID); } DataServiceQueryContinuation<Customer> continuation = response.GetContinuation(); if (continuation != null) { response = ctx.Execute(continuation); } else { response = null; } } while (response != null);皇小福另届
public static List<T> GetAlltems<T>(this DataServiceContext context) { return context.GetAlltems<T>(null); } public static List<T> GetAlltems<T>(this DataServiceContext context, IQueryable<T> queryable) { List<T> allItems = new List<T>(); DataServiceQueryContinuation<T> token = null; EntitySetAttribute attr = (EntitySetAttribute)typeof(T).GetCustomAttributes(typeof(EntitySetAttribute), false).First(); // Execute the query for all customers and get the response object. DataServiceQuery<T> query = null; if (queryable == null) { query = context.CreateQuery<T>(attr.EntitySet); } else { query = (DataServiceQuery<T>) queryable; } QueryOperationResponse<T> response = query.Execute() as QueryOperationResponse<T>; // With a paged response from the service, use a do...while loop // to enumerate the results before getting the next link. do { // If nextLink is not null, then there is a new page to load. if (token != null) { // Load the new page from the next link URI. response = context.Execute<T>(token); } allItems.AddRange(response); } // Get the next link, and continue while there is a next link. while ((token = response.GetContinuation()) != null); return allItems; }