public SharePointOutput UpdateList(string listName, string id, Dictionary <string, string> fields)
{
SharePointOutput result = new SharePointOutput();
try
{
var listItemFullName = GetLIFullName(listName);
if (!listItemFullName.Success)
{
throw listItemFullName.Exception;
}
if (_spo == null)
{
_spo = SpoAuthUtility.Create(new Uri(_siteUrl), _username, WebUtility.HtmlEncode(_password), false);
}
string odataQuery = $"/_api/web/lists/GetByTitle('{listName}')/items({id})";
var jsonDataString = string.Format("{{ '__metadata': {{ 'type': '{1}' }}, {0} }}", ConvertDictionaryToJsonFormat(fields), listItemFullName.SPRestData.d.ListItemEntityTypeFullName);
byte[] content = ASCIIEncoding.ASCII.GetBytes(jsonDataString);
string digest = _spo.GetRequestDigest();
Uri url = new Uri(String.Format("{0}/{1}", _spo.SiteUrl, odataQuery));
// Set X-RequestDigest
var webRequest = (HttpWebRequest)HttpWebRequest.Create(url);
webRequest.Headers.Add("X-RequestDigest", digest);
webRequest.Headers.Add("X-HTTP-Method", "MERGE");
webRequest.Headers.Add("IF-MATCH", "*");
// Send a json odata request to SPO rest services to fetch all list items for the list.
var response = HttpHelper.SendODataJsonRequest(url, "POST", content, webRequest, _spo);
if (!response.Success)
{
result.Success = false;
result.Exception = new Exception($"Failed to process the action on Sharepoint. HTTP Staus Code - {response.Status} ");
}
else
{
var responseJson = Encoding.UTF8.GetString(response.Response, 0, response.Response.Length);
// Response from Sharepoint REST API is 0 byte length (surprise :O)
// So no meaning of converting any thing from here..
// If you want the full list item to return, do a service call again over here and return the obj..
}
}
catch (Exception ex)
{
result.Success = false;
result.Exception = ex;
}
return(result);
}
public SharePointOutput GetLIFullName(string listName)
{
SharePointOutput result = new SharePointOutput();
if (_spo == null)
{
_spo = SpoAuthUtility.Create(new Uri(_siteUrl), _username, WebUtility.HtmlEncode(_password), false);
}
string odataQuery = $"_api/web/lists/GetByTitle('{listName}')";
string digest = _spo.GetRequestDigest();
Uri url = new Uri(String.Format("{0}/{1}", _spo.SiteUrl, odataQuery));
// Set X-RequestDigest
var webRequest = (HttpWebRequest)HttpWebRequest.Create(url);
webRequest.Headers.Add("X-RequestDigest", digest);
// Send a json odata request to SPO rest services to fetch all list items for the list.
var response = HttpHelper.SendODataJsonRequest(url, "GET", null, webRequest, _spo);
if (!response.Success)
{
result.Success = false;
result.Exception = new Exception($"Failed to process the action on Sharepoint. HTTP Staus Code - {response.Status} ");
}
else
{
var responseJson = Encoding.UTF8.GetString(response.Response, 0, response.Response.Length);
SharepointRestData spObj = null;
try
{
spObj = Searilizer.DeserilizeSPJsonString(responseJson);
}
catch (Exception ex)
{
result.Success = false;
result.Exception = new Exception("Failed to deserialize Sharepoint REST Json string. Please see Inner Exception", ex);
return(result);
}
result.SPRestData = spObj;
}
return(result);
}
/// <summary>
/// The method will request the SP ContextInfo and return its FormDigestValue as a String
/// The FormDigestValue is a second layer of authentication required for several REST queries
/// </summary>
/// <returns>FormDigestValue</returns>
public string GetRequestDigest()
{
string digest = String.Empty;
Uri url = new Uri(String.Format("{0}/{1}", SiteUrl, contextInfoQuery));
var result = HttpHelper.SendODataJsonRequest(
url,
"POST", // Retrieving the Context Info needs a POST Method
new byte[0],
(HttpWebRequest)HttpWebRequest.Create(url),
this // pass in the helper object that allows us to make authenticated calls to SPO rest services
);
ContextInfo ci = Deserialize <ContextInfo>(result.Response);
digest = (ci != null) ? ci.FormDigestValue : String.Empty;
return(digest);
}
public SharePointOutput CreateListItem(string listName, Dictionary <string, string> fields)
{
SharePointOutput result = new SharePointOutput();
try
{
var listItemFullName = GetLIFullName(listName);
if (!listItemFullName.Success)
{
throw listItemFullName.Exception;
}
if (_spo == null)
{
_spo = SpoAuthUtility.Create(new Uri(_siteUrl), _username, WebUtility.HtmlEncode(_password), false);
}
//string odataQuery = $"/_api/web/lists/GetByTitle('Leads from Flow')/items({id})";
string odataQuery = $"_api/web/lists/GetByTitle('{listName}')/items";
var jsonDataString = string.Format("{{ '__metadata': {{ 'type': '{1}' }}, {0} }}", ConvertDictionaryToJsonFormat(fields), listItemFullName.SPRestData.d.ListItemEntityTypeFullName);
byte[] content = ASCIIEncoding.ASCII.GetBytes(jsonDataString);
string digest = _spo.GetRequestDigest();
Uri url = new Uri(String.Format("{0}/{1}", _spo.SiteUrl, odataQuery));
// Set X-RequestDigest
var webRequest = (HttpWebRequest)HttpWebRequest.Create(url);
webRequest.Headers.Add("X-RequestDigest", digest);
//var webRequest = (HttpWebRequest)HttpWebRequest.Create(url);
//webRequest.Headers.Add("X-RequestDigest", digest);
//webRequest.Headers.Add("X-HTTP-Method","MERGE");
//webRequest.Headers.Add("IF-MATCH", "*");
// Send a json odata request to SPO rest services to fetch all list items for the list.
var response = HttpHelper.SendODataJsonRequest(url, "POST", content, webRequest, _spo);
if (!response.Success)
{
result.Success = false;
result.Exception = new Exception($"Failed to process the action on Sharepoint. HTTP Staus Code - {response.Status} ");
}
else
{
var responseJson = Encoding.UTF8.GetString(response.Response, 0, response.Response.Length);
SharepointRestData spObj = null;
try
{
spObj = Searilizer.DeserilizeSPJsonString(responseJson);
}
catch (Exception ex)
{
result.Success = false;
result.Exception = new Exception("Failed to deserialize Sharepoint REST Json string. Please see Inner Exception", ex);
return(result);
}
result.SPRestData = spObj;
}
}
catch (Exception ex)
{
result.Success = false;
result.Exception = ex;
}
return(result);
}