雪花云数据平台无法解析带双引号的JSON对象

Question

我无法解析带有双引号的嵌套JSON，这里是示例对象。压扁了不要得到"；RawRequest"；密钥，尽管其有效json:

"Business ID":"Sajidbutta",
"Acout":"Saji_12"
"Report": {
"ReportPDF": {
"RawRequest": "{ "subcode" : "35656", "Hoppoes" :"Hello" ,"Hoppoes":[{"tsn" : "44544545", "title" : "Owner"}] }"
}    
}
}

Answer 1

您有两个问题。

首先，您缺少"之间的逗号；Saji_12"；以及"；报告"：

"Acout":"Saji_12" "Report": 

第二个是你错过了在"；JSON字符串中。考虑以下

{
"Business ID": "Sajidbutta",
"Acout": "Saji_12",
"Report": {
"ReportPDF": {
"RawRequest": "{  "subcode" : "35656", "Hoppoes" :"Hello" ,"Hoppoes":[{"tsn" : "44544545", "title" : "Owner"}] }"
}
}
}

如果"；RawRequest"；实际上是一个json，那么下面的内容是合适的(注意RawRequest键后面没有引号：

{
"Business ID": "Sajidbutta",
"Acout": "Saji_12",
"Report": {
"ReportPDF": {
"RawRequest": {
"subcode": "35656",
"Hoppoes": "Hello",
"Hoppoes": [
{
"tsn": "44544545",
"title": "Owner"
}
]
}
}
}
}

还应注意重复键"；Hoppoes"：(