/// <summary>
/// Retrieves a record set in the response (as a list) based on the query result.
/// </summary>
/// <param name="query">A standard service-now table query.</param>
/// <returns>A RestResponse containing a result list of T (if successful) along with any error messages (if any).</returns>
public RESTQueryResponse <T> GetByQuery(string query)
{
var response = new RESTQueryResponse <T>();
try
{
response.RawJSON = ServiceNowClient.DownloadString(URL + "?&sysparm_fields=" + _FieldList + "&sysparm_query=" + query);
}
catch (WebException ex)
{
response.ErrorMsg = ParseWebException(ex);
}
catch (Exception ex)
{
response.ErrorMsg = "An error occured retrieving the REST response: " + ex.Message;
}
RESTQueryResponse <T> tmp = JsonConvert.DeserializeObject <RESTQueryResponse <T> >(response.RawJSON);
if (tmp != null)
{
response.Result = tmp.Result;
}
return(response);
}
public RESTQueryResponse <TResult> GetByQuery <TResult, TParam>(TParam param) where TParam : class
{
var response = new RESTQueryResponse <TResult>();
try
{
var query = ParameterParser.Parse(param);
_TableName = TableResolver.GetTableName <TResult>();
var request = new RestRequest(Method.GET);
ServiceNowClient.BaseUrl = new Uri($"{URL}?{query}");
IRestResponse res = ServiceNowClient.Execute(request);
if (res.StatusCode == HttpStatusCode.OK)
{
RESTQueryResponse <TResult> tmp = JsonConvert.DeserializeObject <RESTQueryResponse <TResult> >(res.Content);
if (tmp != null)
{
response.Result = tmp.Result;
}
}
}
catch (WebException ex)
{
response.ErrorMsg = ParseWebException(ex);
}
catch (Exception ex)
{
response.ErrorMsg = "An error occured retrieving the REST response: " + ex.Message;
}
return(response);
}
/// <summary>
/// Retrieves all record..
/// </summary>
public RESTQueryResponse <T> GetByQuery <T>(string query)
{
var response = new RESTQueryResponse <T>();
try
{
_TableName = TableResolver.GetTableName <T>();
var request = new RestRequest(Method.GET);
ServiceNowClient.BaseUrl = new Uri(URL);
IRestResponse res = ServiceNowClient.Execute(request);
if (res.StatusCode == HttpStatusCode.OK)
{
RESTQueryResponse <T> tmp = JsonConvert.DeserializeObject <RESTQueryResponse <T> >(res.Content);
if (tmp != null)
{
response.Result = tmp.Result;
}
}
}
catch (WebException ex)
{
response.ErrorMsg = ParseWebException(ex);
}
catch (Exception ex)
{
response.ErrorMsg = "An error occured retrieving the REST response: " + ex.Message;
}
return(response);
}
public RESTQueryResponse <Problem> Get(string problemId, string startDate, string endDate, string limit)
{
if (!DateTime.TryParse(startDate, out DateTime start))
{
// handle failure..
}
if (!DateTime.TryParse(endDate, out DateTime end))
{
// handle failure..
}
//var query = "?sysparm_limit=10&sysparm_query=business_service=";
var query = "?sysparm_limit=" + limit + "&sysparm_query=business_service=";
RESTQueryResponse <Problem> result = _problemService.GetByQueryAndId(query, problemId, start, end);
return(result);
}
