Jolt列表转换

Question

我正在尝试使用 jolt 转换 JSON，而无需添加新项目以及从键值中删除空格。此外，我想知道如何映射到当前列表。

输入:

[
  {
    "id": "9164339966213408050",
    "actualEndDate": "2022-08-15T14:47:09+03:00",
    "extendedChars": [
      {
        "Total BYOP Tier": {
          "values": [
            {
              "value": "60"
            }
          ],
          "name": "Total BYOP Tier",
          "isMultiple": false,
          "tomsId": "9162933742365468326"
        }
      }
    ],
    "chars": {
      "Total BYOP Tier": "60"
    }
  },
  {
    "id": "9164339966213408051",
    "actualEndDate": "2022-08-15T14:47:09+03:00",
    "extendedChars": [
      {
        "Total BYOP Tier": {
          "values": [
            {
              "value": "60"
            }
          ],
          "name": "Total BYOP Tier",
          "isMultiple": false,
          "tomsId": "9162933742365468325"
        }
      }
    ],
    "chars": {
      "Total BYOP Tier": "60"
    }
  }
]

预期产出:

[
  {
    "id": "9164339966213408050",
    "actualEndDate": "2022-08-15T14:47:09+03:00",
    "extendedChars": [
      {
        "values": [
          {
            "value": "60"
          }
        ],
        "name": "Total BYOP Tier",
        "isMultiple": false,
        "tomsId": "9162933742365468326",
        "TotalBYOPTier": {
          "values": [
            {
              "value": "60"
            }
          ],
          "name": "Total BYOP Tier",
          "isMultiple": false,
          "tomsId": "9162933742365468326"
        }
      }
    ],
    "chars": {
      "TotalBYOPTier": "60"
    }
  },
  {
    "id": "9164339966213408051",
    "actualEndDate": "2022-08-15T14:47:09+03:00",
    "extendedChars": [
      {
        "values": [
          {
            "value": "60"
          }
        ],
        "name": "Total BYOP Tier",
        "isMultiple": false,
        "tomsId": "9162933742365468325",
        "TotalBYOPTier": {
          "values": [
            {
              "value": "60"
            }
          ],
          "name": "Total BYOP Tier",
          "isMultiple": false,
          "tomsId": "9162933742365468325"
        }
      }
    ],
    "chars": {
      "TotalBYOPTier": "60"
    }
  }
]

规格已尝试:

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "@": "CustomerProductArray"
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "CustomerProductArray": {
        "*": {
          "extendedChars": {
            "*": {
              "* * *": "CustomerProductArray.&(0,1)&(0,2)&(0,3)",
              "*": {
                "name": "CustomerProductArray[].extendedChars[]..name",
                "isMultiple": "CustomerProductArray[].extendedChars[].isMultiple",
                "tomsId": "CustomerProductArray[].extendedChars[].tomsId",
                "values": "CustomerProductArray[].extendedChars[].values"
              }
            }
          },
          "chars": {
            "* * *": "CustomerProductArray[].chars.&(0,1)&(0,2)&(0,3)"
          }
        }
      }
    }
  }
]

Answer 1

当您想要复制嵌套在对象内外的Total BYOP Tier数组的内容时，请使用以下规范

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*": "&1.&",
        "extendedChars": {
          "*": {
            "Total BYOP Tier": {
              "*": {
                "@": "&5.&4[&3].&" // &5 : (going up the tree five levels) replicates the index of the outermost array, &4[&3] : stands for "extendedChars"(&4) along strolling through with its indexes([&3])
              },
              "@": "&4.&3[&2].&1"
            }
          }
        }
      }
    }
  },
  {
   // get rid of object labels
    "operation": "shift",
    "spec": {
      "*": ""
    }
  }
]

http://jolt-demo.appspot.com/网站上的演示是