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);
}
}
