从ServiceNow Rest API访问C#中的JSON键

Question

var client = new RestClient("https://mydevInstance.service-now.com/api/now/v1/table/incident?sysparm_limit=1");
client.Timeout = -1;
var request = new RestRequest(Method.GET);
request.AddHeader("Authorization", "Basic myAuthKey");
IRestResponse response = client.Execute(request);

它在RESTSharp中返回的JSON如下所示。

{
    "result": [
        {
            "parent": "",
            "made_sla": "true",
            "caused_by": "",
            "watch_list": "",
            "upon_reject": "cancel",
            "resolved_by": {
                "link": "https://mydevInstance.service-now.com/api/now/v1/table/sys_user/5137153cc611227c000bbd1bd8cd2007",
                "value": "5137153cc611227c000bbd1bd8cd2007"
            },
            "approval_history": "",
            "number": "INC0000060"
        }
    ]
}

如何在result下创建所有键的C#列表或数组？我不能用JSON.NET序列化对象，因为随着时间的推移，可能会添加额外的键。

Answer 1

您需要获取JSON内容的示例，然后使用我描述的“粘贴特殊”选项创建一个C#类。

然后，可以使用jsonconvert.deserializeObject （在Newtonsoft的nuget包中）在C#对象实例中反序列化web服务响应。

以下是我在JSON对象未改变的情况下生成的C#类：

public class Rootobject
{
    public Result[] result { get; set; }
}

public class Result
{ 
    public string parent { get; set; }
    public string made_sla { get; set; }
    public string caused_by { get; set; }
    public string watch_list { get; set; }
    public string upon_reject { get; set; }
    public Resolved_By resolved_by { get; set; }
    public string approval_history { get; set; }
    public string number { get; set; }
}

public class Resolved_By
{
    public string link { get; set; }
    public string value { get; set; }
}

var json = "t-b-d"; // From Web Service call
Rootobject response = JsonConvert.DeserializeObject<Rootobject>(json);
// use the response object.

var response = JsonConvert.DeserializeObject<Dictionary<string,string>>(json);