使用ASP.NETCore反序列化多维JSON数组

我已经尝试了几天才能找到这个问题，也许我遗漏了一些东西。

当我基于GitHub构建示例应用程序时，我遵循了microsoft的建议：
https://docs.microsoft.com/en-us/aspnet/core/fundamentals/http-requests?view=aspnetcore-3.1

不幸的是，这段代码似乎不适用于多维数组。

我的应用程序的希望是从我们的Teamwork Desk帐户获取信息，以便我们可以使用ASP.NET应用程序创建报告。

任何有关如何使此工作正常进行的技巧或想法都很好。

这是我的代码：

文件夹（Models.TeamworkDesk）| Customer.cs

using System;
using System.Collections.Generic;
using System.Text.Json.Serialization;
namespace vanilla.Models.TeamworkDesk
{
public class Contact
{
[JsonPropertyName("id")]
public int Id { get; set; }
[JsonPropertyName("value")]
public string Value { get; set; }
[JsonPropertyName("type")]
public string Type { get; set; }
[JsonPropertyName("isMain")]
public bool IsMain { get; set; }
[JsonPropertyName("createdAt")]
public DateTime CreatedAt { get; set; }
}
public class Customer
{
[JsonPropertyName("id")]
public int Id { get; set; }
[JsonPropertyName("timezoneId")]
public int TimezoneId { get; set; }
[JsonPropertyName("avatarURL")]
public string AvatarURL { get; set; }
[JsonPropertyName("email")]
public string Email { get; set; }
[JsonPropertyName("contacts")]
public List Contacts { get; set; }
[JsonPropertyName("externalId")]
public string ExternalId { get; set; }
[JsonPropertyName("extraData")]
public string ExtraData { get; set; }
[JsonPropertyName("firstName")]
public string FirstName { get; set; }
[JsonPropertyName("jobTitle")]
public string JobTitle { get; set; }
[JsonPropertyName("language")]
public string Language { get; set; }
[JsonPropertyName("lastName")]
public string LastName { get; set; }
[JsonPropertyName("address")]
public string Address { get; set; }
[JsonPropertyName("mobile")]
public string Mobile { get; set; }
[JsonPropertyName("notes")]
public string Notes { get; set; }
[JsonPropertyName("organization")]
public string Organization { get; set; }
[JsonPropertyName("phone")]
public string Phone { get; set; }
[JsonPropertyName("trusted")]
public bool Trusted { get; set; }
[JsonPropertyName("welcomeEmailSent")]
public bool WelcomeEmailSent { get; set; }
[JsonPropertyName("facebookURL")]
public string FacebookURL { get; set; }
[JsonPropertyName("googlePlusURL")]
public string GooglePlusURL { get; set; }
[JsonPropertyName("linkedinURL")]
public string LinkedinURL { get; set; }
[JsonPropertyName("twitterHandle")]
public string TwitterHandle { get; set; }
[JsonPropertyName("createdAt")]
public DateTime CreatedAt { get; set; }
[JsonPropertyName("createdBy_users_id")]
public int CreatedBy_Users_Id { get; set; }
[JsonPropertyName("updatedAt")]
public DateTime UpdatedAt { get; set; }
[JsonPropertyName("updatedBy_users_id")]
public int UpdatedBy_Users_Id { get; set; }
[JsonPropertyName("company")]
public object Company { get; set; }
[JsonPropertyName("lastTicketDate")]
public DateTime? LastTicketDate { get; set; }
[JsonPropertyName("numTickets")]
public int NumTickets { get; set; }
}
public class RootObject
{
[JsonPropertyName("customers")]
public List Customers { get; set; }
[JsonPropertyName("totalCustomers")]
public int TotalCustomers { get; set; }
}
}


文件夹（页面）| Teamwork.cshtml.cs

using microsoft.AspNetCore.Mvc.RazorPages;
using System;
using System.Collections.Generic;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Text;
using System.Text.Json;
using System.Threading.Tasks;
using vanilla.Models.TeamworkDesk;
namespace vanilla.Pages
{
public class TeamworkModel : PageModel
{
private readonly IHttpClientFactory _clientFactory;
public IEnumerable Customers { get; private set; }
public bool getcustomersError { get; private set; }
public TeamworkModel(IHttpClientFactory clientFactory)
{
_clientFactory = clientFactory;
}
public async Task OnGet()
{
var request = new HttpRequestMessage(HttpMethod.Get,"https://vanillacompany.teamwork.com/desk/v1/customers.json");
var client = _clientFactory.Createclient();
var byteArray = Encoding.ASCII.GetBytes("myUniqueKey:");
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic",Convert.ToBase64String(byteArray));
var respOnse= await client.SendAsync(request);
if (response.IsSuccessStatusCode)
{
using var respOnseStream= await response.Content.ReadAsStreamAsync();
Customers = await JsonSerializer.DeserializeAsync>(responseStream);
}
else
{
getcustomersError = true;
Customers = Array.Empty();
}
}
}
}


文件夹（页面）| Teamwork.cshtml

@page
@model vanilla.Pages.TeamworkModel
@{
ViewData["Title"] = "Teamwork Customers";
Layout = "~/Pages/Shared/_Layout.cshtml";
}
@if (Model.getcustomersError)
{


Unable to get customers from Teamwork. Please try again later.

JSON示例：

{
"customers": [
{
"id": 94572,"timezoneId": 0,"avatarURL": "https://vanillacompany.teamwork.com/desk/images/examples/noPhoto1.png","email": "testytester@vanillacompany.com","contacts": [
{
"id": 44783,"value": "testytester@vanillacompany.com","type": "email","isMain": true,"createdAt": "0001-01-01T00:00:00Z"
}
],"externalId": "","extraData": "","firstName": "Testy","jobTitle": "Code Tester","language": "en","lastName": "Tester","address": "","mobile": "","notes": "","organization": "vanilla","phone": "","trusted": false,"welcomeEmailSent": false,"facebookURL": "","googlePlusURL": "","linkedinURL": "","twitterHandle": "","createdAt": "0001-01-01T00:00:00Z","createdBy_users_id": 166240,"updatedAt": "0001-01-01T00:00:00Z","updatedBy_users_id": 166240,"company": null,"lastTicketDate": null,"numTickets": 11
},{
"id": 85469,"avatarURL": "https://vanillacompany.teamwork.com/desk/images/examples/noPhoto2.png","email": "codebreaker@vanillacompany.com","contacts": [
{
"id": 45002,"value": "codebreaker@vanillacompany.com","firstName": "Code","jobTitle": "","lastName": "Breaker","updatedAt": "2016-05-04T20:46:10Z","lastTicketDate": "2017-03-22T19:24:47Z","numTickets": 5
},{
"id": 69421,"avatarURL": "https://vanillacompany.teamwork.com/desk/images/examples/noPhoto3.png","email": "enduser@vanillacompany.com","contacts": [
{
"id": 45032,"value": "enduser@vanillacompany.com","createdAt": "2016-02-03T18:57:16Z"
}
],"firstName": "End","language": "","lastName": "User","organization": "","phone": "999-777-8888","createdAt": "2016-02-03T18:57:16Z","createdBy_users_id": 015874,"updatedAt": "2016-04-05T16:49:26Z","updatedBy_users_id": 015874,"lastTicketDate": "2016-04-05T16:48:27Z","numTickets": 23
},],"totalCustomers": 1294
}


谢谢。

您的Json很好，您刚刚混合了一些反序列化的目标。使用您现有的代码，我将进行这些更改。

在类RootObject中，将Customers属性更改为List类型：

public List Customers { get; set; }


在Teamwork.cshtml.cs中，将Customers属性更改为RootObject类型：

public RootObject Customers { get; private set; }


然后将反序列化行更改为：

Customers = await JsonSerializer.DeserializeAsync(responseStream);


最后，根据个人喜好，我将RootObject更改为CustomerList之类的名字。