public void UpdateField(string itemId, string fieldName, string value) { using (var clientContext = new SharePointAdalClientContext(_contextUrl)) { var itemCreateInfo = new ListItemCreationInformation(); var list = clientContext.Web.Lists.GetByTitle(_listName); var listItem = list.GetItemById(itemId); listItem[fieldName] = value; listItem.Update(); clientContext.ExecuteQuery(); } }
public void AddItem(Dictionary <string, string> fieldValues) { using (var clientContext = new SharePointAdalClientContext(_contextUrl)) { var itemCreateInfo = new ListItemCreationInformation(); var list = clientContext.Web.Lists.GetByTitle(_listName); var listItem = list.AddItem(itemCreateInfo); foreach (var v in fieldValues) { listItem[v.Key] = v.Value; } listItem.Update(); clientContext.ExecuteQuery(); } }
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); } }