I am working in c# and I have a list of strings which contains the projectid of the SharePoint list
List<string> guidlist = new List<string>(); // contains project ids
On the basis of this list I want to retrieve the data from the SharePoint list. i.e To get all the rows from the SharePoint list where projectid exists in guidlist.
var list = clientContext.Web.Lists.GetByTitle("testlist"); CamlQuery query = new CamlQuery(); query.ViewXml = "<View/>"; ListItemCollection projects = list.GetItems(query); clientContext.Load(projects); clientContext.ExecuteQuery();
Currently I am just getting all the rows from the list how can I filter it to my needs. I am beginner and any help would be useful