Json 删除 JOLT 中的方括号

发布于07月21日

我有下面的震荡input:

{
  "pnum": "4545",
  "clascode": null,
  "retun": "NN",
  "skcmm": [
    "AA",
    "EE",
    "KN",
    "NH",
    "NL"
  ]
}

我的current spec:

[
  {
    "operation": "shift",
    "spec": {
      "*": "&"
    }
  },
  {
    "operation": "modify-default-beta",
    "spec": {
      "SMS_SPMFORMAT": "${spm_format}",
      "SMS_PRODUCTIONFORMAT": "${partNumberConverted}"
    }
  }
]

目前的output:

{
  "pnum" : "4545",
  "clascode" : null,
  "retun" : "NN",
  "skcmm" : [ "AA", "EE", "KN", "NH", "NL" ],
  "SMS_SPMFORMAT" : "${spm_format}",
  "SMS_PRODUCTIONFORMAT" : "${partNumberConverted}"
}

但前expected output名是:

{
  "pnum" : "4545",
  "clascode" : null,
  "retun" : "NN",
  "skcmm" : "AA,EE,KN,NH,NL",
  "SMS_SPMFORMAT" : "${spm_format}",
  "SMS_PRODUCTIONFORMAT" : "${partNumberConverted}"
}

我需要删除列表的square brackets，并将其添加为带有双引号的字符串. 你能帮帮忙吗.

推荐答案

在将modify转换从103转换为104之后，您可以对101使用join函数，以便覆盖现有的101值，例如

[
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "SMS_SPMFORMAT": "${spm_format}",
      "SMS_PRODUCTIONFORMAT": "${partNumberConverted}",
      "skcmm": "=join(',',@(1,&))" // concatenates the components of the array comma-separatedly
    }
  }
]

顺便说一句，使用现有的shift转换是多余的，它精确地复制了整个内容.

现场http://jolt-demo.appspot.com/上的101个是: