在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反馈到顶部的代码中,以获得每个条目的详细信息。

这里有人帮忙吗?

在C#中为来自Salesforce REST API的嵌套JSON数据设置DataContract

您的Response2类应该如下所示:

public class Response2
{
    [DataMember(Name = "done")]
    public bool done;
    [DataMember(Name = "records")]
    public List<Response3> r3entry;
}