asked on
IRestResponse<List<Table>> restResponse = restClient.Get<List<Table>>(request);
var resultsContent = restResponse.Content;
doc.LoadXml(resultsContent);
string json = JsonConvert.SerializeXmlNode(doc);
var jObject = JObject.Parse(json);
string test = jObject.GetValue("table").ToString();
var ss = new JsonSerializer();
List<Table> table;
var x = new XmlSerializer(typeof(Table));
using (var r = new StringReader(resultsContent))
{
table = (List<Table>)x.Deserialize(r);
}
[XmlRoot("table")]
public class Table
{
public Row row;
}
public class Row
{
[XmlAttribute]
public string id;
[XmlAttribute]
public string employeeId;
[XmlElement]
public Field[] field;
}
public class Field
{
[XmlAttribute]
public string id;
[XmlText]
public string value;
}
XML
<?xml version="1.0"?>
<table>
<row id="18" employeeId="20">
<field id="date">2017-05-15</field>
<field id="location">test</field>
<field id="department">Production (Direct)</field>
<field id="division">abc</field>
<field id="jobTitle">Stores Material Handler</field>
<field id="reportsTo">abc cde</field>
</row>
<row id="19" employeeId="20">
<field id="date">2017-06-15</field>
<field id="location">test</field>
<field id="department">Production (Direct)</field>
<field id="division">abc</field>
<field id="jobTitle">Stores Material Handler</field>
<field id="reportsTo">abc cdettt</field>
</row>
<row id="20" employeeId="20">
<field id="date">2017-07-15</field>
<field id="location">test</field>
<field id="department">Production (Direct)</field>
<field id="division">abc</field>
<field id="jobTitle">Stores Material Handler</field>
<field id="reportsTo">abc cde111</field>
</row>
</table>
IRestResponse<List<Table>> restResponse = restClient.Get<List<Table>>(request);
var resultsContent = restResponse.Content;
doc.LoadXml(resultsContent);
string json = JsonConvert.SerializeXmlNode(doc);
var json1 = Newtonsoft.Json.JsonConvert.DeserializeObject(json);