json数组嵌套，如何获取内存数组并返回到表格中。

小萝卜David

本帖最后由 olookok 于 2025-3-6 20:50 编辑

复制代码

要childrenvo中的内容并返回到表格。

[
{
      "parentvo": {
         "docislevflag": false,
         "doclistcode": "lf002",
         "doclistname": "分期公司",
         "doclistsystype": "2",
         "dr": "0",
         "iscorpcanchg": false,
         "pk_defdoclist": "0001F910000000000518",
         "ts": "2022-12-24 11:35:31"
      },
      "childrenvo": [
         {
            "doccode": "01",
            "docname": "莲花金融",
            "docsystype": "1",
            "dr": "0",
            "pk_corp": "0001",
            "unitcode": "0001",
            "unitname": "集团",
            "pk_defdoc": "0001F91000000000051J",
            "pk_defdoclist": "0001F910000000000518",
            "ts": "2022-12-24 11:37:31"
         },
         {
            "doccode": "02",
            "docname": "上汽金融",
            "docsystype": "1",
            "dr": "0",
            "pk_corp": "0001",
            "unitcode": "0001",
            "unitname": "集团",
            "pk_defdoc": "0001F91000000000051K",
            "pk_defdoclist": "0001F910000000000518",
            "ts": "2022-12-24 11:37:31"
         },
         {
            "doccode": "17",
            "docname": "天津恒通嘉合",
            "docsystype": "1",
            "dr": "0",
            "pk_corp": "0001",
            "unitcode": "0001",
            "unitname": "集团",
            "pk_defdoc": "0001F91000000000BIVI",
            "pk_defdoclist": "0001F910000000000518",
            "ts": "2023-01-31 16:34:33"
         }

}
]

小萝卜David · 小萝卜David

确定只有一个的话，可以用.0取数组第一项。
活字格9.0新功能解密：三十五、易用性 - 数组操作支持增强 - 活字格专区 - 专题教程 - 葡萄城开发者社区

小白学员 · 小白学员

你个老司机。居然抛锚了？

取childrenvo，然后循环就可以得到了。
还有，你这个JSON有错，貌似差一个"]"

olookok · olookok

本帖最后由 olookok 于 2025-3-7 08:24 编辑

小白学员发表于 2025-3-6 22:16
你个老司机。居然抛锚了？

取childrenvo，然后循环就可以得到了。

已经解决，没有用循环，想看看还有啥高招。是少了一个]

[
{
      "parentvo": {
         "docislevflag": false,
         "doclistcode": "lf002",
         "doclistname": "分期公司",
         "doclistsystype": "2",
         "dr": "0",
         "iscorpcanchg": false,
         "pk_defdoclist": "0001F910000000000518",
         "ts": "2022-12-24 11:35:31"
      },
      "childrenvo": [
         {
            "doccode": "01",
            "docname": "莲花金融",
            "docsystype": "1",
            "dr": "0",
            "pk_corp": "0001",
            "unitcode": "0001",
            "unitname": "集团",
            "pk_defdoc": "0001F91000000000051J",
            "pk_defdoclist": "0001F910000000000518",
            "ts": "2022-12-24 11:37:31"
         },
         {
            "doccode": "02",
            "docname": "上汽金融",
            "docsystype": "1",
            "dr": "0",
            "pk_corp": "0001",
            "unitcode": "0001",
            "unitname": "集团",
            "pk_defdoc": "0001F91000000000051K",
            "pk_defdoclist": "0001F910000000000518",
            "ts": "2022-12-24 11:37:31"
         },
         {
            "doccode": "17",
            "docname": "天津恒通嘉合",
            "docsystype": "1",
            "dr": "0",
            "pk_corp": "0001",
            "unitcode": "0001",
            "unitname": "集团",
            "pk_defdoc": "0001F91000000000BIVI",
            "pk_defdoclist": "0001F910000000000518",
            "ts": "2023-01-31 16:34:33"
         }
      ]
}
]