I am querying a SharePoint Online List : /sites/MySite/Lists/People which I can see in the native UI contains 8 items with custom fields 'FirstName' , 'LastName', 'Manager'. These fields all have values in them.
I use the following code to access this list ( ctx & myList defined earlier) , expecting to get the 8 list items back.
Microsoft.SharePoint.Client.CamlQuery camlQuery = new Microsoft.SharePoint.Client.CamlQuery();
camlQuery.ViewXml =@"<View> <RowLimit>5000</RowLimit> </View>";
Microsoft.SharePoint.Client.ListItemCollection items = myList.GetItems(camlQuery);
ctx.Load(items);
ctx.ExecuteQuery();
foreach (Microsoft.SharePoint.Client.ListItem li in items)
{
=processLi(li);
}
I notice that there are over 26 Listitems , the custom field names ( FirstName, LastName etc.. ) are all null, but there is a title field which is populated 'A' , 'B' , 'C' etc....
I suspect that this something to do with a Folder / Filtering feature in the list. Can anyone recommend a way to get the 8 list items. So far I have tried to use
Web.Lists.GetById(guidid); & getByTitle in case those behaved differently - but they dont
Thanks in Advance
Regards Richard