在C#中为来自Salesforce REST API的嵌套JSON数据设置DataContract
本文关键字:嵌套 JSON 数据 DataContract 设置 API REST Salesforce | 更新日期: 2023-09-27 18:19:35
我需要帮助了解如何将JSON数据获取到我的C#应用程序中,该应用程序正在从Salesforce REST API获取数据。
首先,我有一些JSON数据,看起来像这样:
{
"attributes" : {
"type" : "Object__c",
"url" : "/services/data/v34.0/sobjects/Object__c/a0FF000000CaEggEMA"
},
"Id" : "a0FF000000CaEggEMA",
"Advertising__c" : 1720.0
}
我能够创建一个带有DataContract的类,如下所示:
using System.Runtime.Serialization;
using System.Runtime.Serialization.Json;
namespace MyNamespace
{
[DataContract]
public class Response
{
[DataMember(Name = "Advertising__c")]
public decimal decAdvertising { get; set; }
}
}
而且,我能够使用以下代码将数据输入我的程序并访问数据。。。
public static Response MakeRequest(string requestUrl)
{
try
{
HttpWebRequest request = WebRequest.Create(requestUrl) as HttpWebRequest;
request.Headers["X-PrettyPrint"] = "1";
request.Headers["Authorization"] = "OAuth [OAuthKeyGoesHere]";
using (HttpWebResponse response = request.GetResponse() as HttpWebResponse)
{
if (response.StatusCode != HttpStatusCode.OK)
throw new Exception(String.Format(
"Server error (HTTP {0}: {1}).",
response.StatusCode,
response.StatusDescription));
DataContractJsonSerializer jsonSerializer = new DataContractJsonSerializer(typeof(Response));
object objResponse = jsonSerializer.ReadObject(response.GetResponseStream());
Response jsonResponse = objResponse as Response;
return jsonResponse;
}
}
catch (Exception e)
{
System.Windows.Forms.MessageBox.Show(e.Message);
return null;
}
}
然而,在上面的示例中,每个JSON响应只有一个Id
和一个Advertising__c
。因此,DataContract似乎运行良好。
现在我想做的是从以下JSON:中获得一个项目的集合/列表/数组(任何我可以迭代的东西)
{
"totalSize" : 4,
"done" : true,
"nextRecordsUrl" : "/services/data/v34.0/query/a1gF000003uAsG6IaO-2000",
"records" : [ {
"attributes" : {
"type" : "Object__c",
"url" : "/services/data/v34.0/sobjects/Object__c/a0FF000000FdAc6MAD"
},
"Id" : "a0FF000000FdAc6MAD",
"Name" : "Name 1"
}, {
"attributes" : {
"type" : "Object__c",
"url" : "/services/data/v34.0/sobjects/Object__c/a0FF000000lkUJMATg"
},
"Id" : "a0FF000000lkUJMATg",
"Name" : "Name 2"
}, {
"attributes" : {
"type" : "Object__c",
"url" : "/services/data/v34.0/sobjects/Object__c/a0FF000000CHaPkkMA"
},
"Id" : "a0FF000000CHaPkkMA",
"Name" : "Name 3"
}, {
"attributes" : {
"type" : "Object__c",
"url" : "/services/data/v34.0/sobjects/Object__c/a0FF000000CIoiUZMA"
},
"Id" : "a0FF000000CIoiUZMA",
"Name" : "Name 4"
} ]
}
我尝试将以下代码添加到DataContract
类中:
[DataContract]
public class Response2
{
[DataMember(Name = "records")]
public Response3 r3entry;
}
[DataContract]
public class Response3
{
[DataMember(Name = "Id")]
public string strId { get; set; }
[DataMember(Name = "Name")]
public string strName { get; set; }
}
现在我只得到两个字段的NULLs
。事实上,我实际上需要done
字段,这样我就知道是否要返回并获取另一批数据。
在一个完美的世界里,我想获得某种集合/列表/数组来迭代并获取strId
,然后将该strId
反馈到顶部的代码中,以获得每个条目的详细信息。
这里有人帮忙吗?
您的Response2
类应该如下所示:
public class Response2
{
[DataMember(Name = "done")]
public bool done;
[DataMember(Name = "records")]
public List<Response3> r3entry;
}