|
|
相关文章推荐
|
茫然的小虾米 · 在Windows中运行Linux ...· 10 月前 · |
|
|
不爱学习的电梯 · alamofire parse json ...· 1 年前 · |
|
|
不要命的芒果 · 将标题添加到pandas hist ...· 1 年前 · |
|
|
爱玩的金鱼 · 设置setInterval定时器、postM ...· 1 年前 · |
C#解析从GraphQL - Monday.com返回的Json字符串
问
C#解析从GraphQL - Monday.com返回的Json字符串
EN
EN
Stack Overflow用户
提问于
2022-02-24 01:09:10
回答 2
查看 475
关注 0
票数 0
我遇到了解析来自GraphQL的json响应的问题。问题是，数组将返回更多的数组的一半时间。我的代码已经失控了，太丑了。
Json文件(稍微修剪了一下)。它可以是20+数据数组)
代码语言：
javascript
复制
{
"activity_logs": [
"data": "{\"board_id\":2165785546,\"group_id\":\"new_group2051\",\"is_top_group\":false,\"pulse_id\":2165787062,\"pulse_name\":\"Tyler\",\"column_id\":\"email_address\",\"column_type\":\"email\",\"column_title\":\"Email Address\",\"value\":{\"column_settings\":{\"includePulseInSubject\":true,\"ccPulse\":true,\"bccList\":\"\"}},\"previous_value\":{\"email\":\"tyler@email.com\",\"text\":\"tyler@email.com\",\"changed_at\":\"2022-02-15T21:18:48.297Z\",\"column_settings\":{\"includePulseInSubject\":true,\"ccPulse\":true,\"bccList\":\"\"}},\"is_column_with_hide_permissions\":false,\"previous_textual_value\":\"tyler@email.com\"}"
"data": "{\"board_id\":2165785546,\"group_id\":\"new_group2051\",\"is_top_group\":false,\"pulse_id\":216578711,\"pulse_name\":\"Nicholas \",\"column_id\":\"email_address\",\"column_type\":\"email\",\"column_title\":\"Email Address\",\"value\":{\"column_settings\":{\"includePulseInSubject\":true,\"ccPulse\":true,\"bccList\":\"\"}},\"previous_value\":{\"email\":\"nicholas@email.com\",\"text\":\"nicholas@email.com\",\"changed_at\":\"2022-02-16T04:44:52.046Z\",\"column_settings\":{\"includePulseInSubject\":true,\"ccPulse\":true,\"bccList\":\"\"}},\"is_column_with_hide_permissions\":false,\"previous_textual_value\":\"nicholas@email.com\"}"
"data": "{\"board_id\":2165785546,\"group_id\":\"new_group2051\",\"is_top_group\":false,\"pulse_id\":216578711,\"pulse_name\":\"Nicholas \",\"column_id\":\"batch_5\",\"column_type\":\"text\",\"column_title\":\"Batch #\",\"value\":{\"value\":\"75\"},\"previous_value\":{\"value\":\"74\"},\"is_column_with_hide_permissions\":false}"
"data": "{\"board_id\":2165785546,\"group_id\":\"new_group2051\",\"pulse_id\":216578711,\"is_top_group\":false,\"value\":{\"name\":\"Nicholas \"},\"previous_value\":{\"name\":\"Nicholas \"},\"column_type\":\"name\",\"column_title\":\"Name\"}"
}放弃制作后的随机“让它工作”的尝试是一个基于类的列表。IContainers在IContainers内部变得非常复杂。
代码语言：
javascript
复制
var responseData = JObject.Parse(responseText).SelectToken("data").SelectToken("boards").SelectToken("activity_logs");
dynamic updatedRecords = JsonConvert.DeserializeObject(responseData.ToString());
foreach (var record in updatedRecords)
List<Dictionary<string, string>> records = new List<Dictionary<string, string>>();
Dictionary<string, string> fields = new Dictionary<string, string>();
dynamic updates = JsonConvert.DeserializeObject(JObject.Parse(record.ToString()).SelectToken("data").ToString());
foreach(var update in updates)
switch (update.Name.ToString())
case "column_id":
fields.Add(update.Name.ToString(), update.Value.ToString());
break;
case "pulse_name":
fields.Add(update.Name.ToString(), update.Value.ToString());
break;
case "value":
dynamic values = JsonConvert.DeserializeObject(JObject.Parse(update.Value.ToString()));
if (update.Name.ToString().Contains("column_settings"))
foreach (var value in values)
dynamic columns = JsonConvert.DeserializeObject(JObject.Parse(value.Value.ToString()));
foreach(var column in columns)
fields.Add($"Value_{column.Name.ToString()}", column.Value.ToString());
foreach (var value in values)
fields.Add($"Value_{value.Name.ToString()}", value.Value.ToString());
break;
case "previous_value":
dynamic prevValues = JsonConvert.DeserializeObject(JObject.Parse(update.Value.ToString()));
foreach (var prevalue in prevValues)
fields.Add($"Prevalue_{prevalue.Name.ToString()}", prevalue.Value.ToString());
break;
case "previous_textual_value":
fields.Add(update.Name.ToString(), update.Value.ToString());
break;
if (fields.Count > 0)
records.Add(fields);
fields.Clear();
}我的错误当我到达：
代码语言：
javascript
复制
dynamic values = JsonConvert.DeserializeObject(JObject.Parse(update.Value.ToString()));
代码语言：
javascript
复制
- $exception {"The best overloaded method match for 'Newtonsoft.Json.JsonConvert.DeserializeObject(string)' has some invalid arguments"} Microsoft.CSharp.RuntimeBinder.RuntimeBinderException解决方案是一个很大的帮助，并导致了我的答案。问题是activity_logs数据中带有转义字符，因此字符串包含\“。我必须用替换(”\“、"{")和替换( "}")和替换(”}“)来格式化数据部分。这使得字符串可读为Json文件。
EN
Stack Overflow用户
回答已采纳
发布于 2022-02-24 02:57:00
您必须将字符串传递给
DeserializeObject
而不是JSON对象。
另一种方法是将JSON映射到POCO类型，如下所示，简单的方法是在Visual上(复制JSON内容，在Visual上创建一个新的空类->编辑->过去的特殊->粘贴JSON作为类)
代码语言：
javascript
复制
public class LogsRoot
public Activity_Logs[] activity_logs { get; set; }
public class Activity_Logs
public string data { get; set; }
public class DataRoot
public long board_id { get; set; }
public string group_id { get; set; }
public bool is_top_group { get; set; }
public long pulse_id { get; set; }
public string pulse_name { get; set; }
public string column_id { get; set; }
public string column_type { get; set; }
public string column_title { get; set; }
public Value value { get; set; }
public Previous_Value previous_value { get; set; }
public bool is_column_with_hide_permissions { get; set; }
public string previous_textual_value { get; set; }
public class Value
public Column_Settings column_settings { get; set; }
public class Column_Settings
public bool includePulseInSubject { get; set; }
public bool ccPulse { get; set; }
public string bccList { get; set; }
public class Previous_Value
public string email { get; set; }
public string text { get; set; }
public DateTime changed_at { get; set; }
public Column_Settings1 column_settings { get; set; }
public class Column_Settings1
public bool includePulseInSubject { get; set; }
public bool ccPulse { get; set; }
public string bccList { get; set; }
}然后按如下方式加载JSON并进行操作，
代码语言：
javascript
复制
var json = File.ReadAllText("data.json");
var rootLogs = JsonConvert.DeserializeObject<LogsRoot>(json);
Dictionary<string, string> fields = new Dictionary<string, string>();
foreach (var logJson in rootLogs.activity_logs)
推荐文章