public ISharePointListItem GetListItemByLookupField(string fieldName, string value) { using (var clientContext = new SharePointAdalClientContext(_contextUrl)) { var test = "<View><Query><Where><Eq><FieldRef Name='" + fieldName + "' /><Value Type='Lookup'>" + value + "</Value></Eq></Where></Query></View>"; var query = new CamlQuery { ViewXml = test }; var list = clientContext.Web.Lists.GetByTitle(_listName); var sitems = list.GetItems(query); clientContext.Load(sitems, i => i.IncludeWithDefaultProperties(item => item.Id, item => item["Title"])); clientContext.ExecuteQuery(); return(sitems.Count == 1 ? new SharePointListItem(sitems[0]) : null); } }
public ISharePointListItem GetListItemByTitle(string title) { using (var clientContext = new SharePointAdalClientContext(_contextUrl)) { var test = "<View><Query><Where><Eq><FieldRef Name='Title' /><Value Type='Text'>" + title + "</Value></Eq></Where></Query></View>"; // string.Format(Constants.SharePointQueries.GetItemByTitleQuery, title); var query = new CamlQuery { ViewXml = test }; var list = clientContext.Web.Lists.GetByTitle(_listName); var sitems = list.GetItems(query); clientContext.Load(sitems); clientContext.ExecuteQuery(); return(sitems.Count == 1 ? new SharePointListItem(sitems[0]) : null); } }