以下是我在成功创建新的工作代码"条目后从 REST API 获得的(略微)精简的响应.我需要将响应反序列化为某些类,但我很难过.
Below is a (slightly) stripped down response I get from a REST API upon successful creation of a new "job code" entry. I need to deserialize the response into some classes, but I'm stumped.
作为参考,我在 .NET 3.5 中使用 JSON.NET(在 SQL Server 2008 R2 的 SSIS 脚本中运行)来尝试反序列化.这是 JSON - 我显然无法控制它,因为它来自其他人的 API:
For reference, I'm using JSON.NET in .NET 3.5 (running in a SSIS script in SQL Server 2008 R2) to attempt my deserialization. Here's the JSON - which I obviously have no control over as it's coming from someone else's API:
{
"results":{
"jobcodes":{
"1":{
"_status_code":200,
"_status_message":"Created",
"id":444444444,
"assigned_to_all":false,
"billable":true,
"active":true,
"type":"regular",
"name":"1234 Main Street - Jackson"
},
"2":{
"_status_code":200,
"_status_message":"Created",
"id":1234567890,
"assigned_to_all":false,
"billable":true,
"active":true,
"type":"regular",
"name":"4321 Some Other Street - Jackson"
}
}
}
}
在我的 C# 代码中,我确实定义了一个JobCode"类,它仅将 JSON 值部分映射到属性 - 我对返回给我的所有数据不感兴趣:
In my C# code, I do have a "JobCode" class defined which only partially maps the JSON values to properties - I'm not interested in all of the data that's returned to me:
[JsonObject]
class JobCode
{
[JsonProperty("_status_code")]
public string StatusCode { get; set; }
[JsonProperty("_status_message")]
public string StatusMessage { get; set; }
[JsonProperty("id")]
public string Id {get; set;}
[JsonProperty("name")]
public string Name { get; set; }
//-------------------------------------------------------------------------------
// Empty constructor for JSON serialization support
//-------------------------------------------------------------------------------
public JobCode() { }
}
我正在尝试通过此调用反序列化数据:
I'm attempting to deserialize the data via this call:
newResource = JsonConvert.DeserializeObject<JobCode>(jsonResponse);
其中 jsonResponse 是上面输出的代码.
当我执行代码时,newResource"总是返回为空 - 这并不意外,因为我知道数据中实际上有多个作业代码,并且此代码试图将其反序列化为单个 JobCode 对象.我尝试创建一个名为JobCodes"的新类,如下所示:
Where jsonResponse is the code outputted above.
When I execute the code, "newResource" always comes back as null - which is not unexpected because I know that there are actually multiple jobcodes in the data and this code is trying to deserialize it into a single JobCode object. I tried creating a new class called "JobCodes" that looks like this:
class JobCodes
{
[JsonProperty("jobcodes")]
public List<JobCode>_JobCodes { get; set; }
}
然后我尝试调用这个:
newResource = JsonConvert.DeserializeObject<JobCodes>(jsonResponse);
但问题仍然存在 - 我的返回对象为空.我认为让我失望的是1"和2"标识符的存在.我不知道如何在我的对象设计和/或 JSON.NET 类/属性属性(如 [JsonObject]、[JsonProperty] 等)的使用中说明它们的存在.
But the issue persists - my return object is null. What's throwing me off, I think, is the presence of the "1" and "2" identifiers. I don't know how to account for their presence in my object design and/or usage of the JSON.NET class / property attributes like [JsonObject],[JsonProperty], etc.
当我通过 JSON2CSharp 运行 JSON 数据时,它会构造一些看起来很奇怪的类,因此这并没有被证明太有效.我已经用几个不同的验证器验证了 JSON 并且一切都检查出来了——我只是不知道我在这里缺少什么.
When I run the JSON data through JSON2CSharp, it constructs some weird-looking classes, so that hasn't proven too effective. I've validated the JSON with several different validators and it all checks out - I just don't know what I'm missing here.
最终,我想从 JSON 数据中返回一个 List,但我不知道我需要做什么才能实现这一目标.
Ultimately, I'd like to return a List from the JSON data, but I'm stumped on what I need to do to make that happen.
你的问题是双重的:
Dictionary
.普通课程对此不起作用;List<T>
也不会.Dictionary<string, T>
. A regular class won't work for that; neither will a List<T>
.让你的课程像这样:
class RootObject
{
[JsonProperty("results")]
public Results Results { get; set; }
}
class Results
{
[JsonProperty("jobcodes")]
public Dictionary<string, JobCode> JobCodes { get; set; }
}
class JobCode
{
[JsonProperty("_status_code")]
public string StatusCode { get; set; }
[JsonProperty("_status_message")]
public string StatusMessage { get; set; }
[JsonProperty("id")]
public string Id { get; set; }
[JsonProperty("name")]
public string Name { get; set; }
}
然后,像这样反序列化:
Then, deserialize like this:
RootObject obj = JsonConvert.DeserializeObject<RootObject>(json);
这里的工作演示
这篇关于将 JSON 反序列化为 C# 类的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!