JOLT JSON 将值从一对多转换为一对一

发布于11月29日

我try 使用Jolt将数组中每个值的一个键映射到一个新array. 有没有人能帮我解决这个问题:

我的JSON:

[
  {
    "person_id": "1",
    "resources": ["asd", "zxc"]
  },
  {
    "person_id": "2",
    "resources": ["ghj", "asd"]
  }
]

和我期望的JSON:

[
  {
    "person_id": "1",
    "resource": "asd"
  },
  {
    "person_id": "1",
    "resource": "zxc"
  },
  {
    "person_id": "2",
    "resource": "ghj"
  },
  {
    "person_id": "2",
    "resource": "asd"
  }
]

我试过这个Jolt规格

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "resources": {
          "*": {
            "@(2,person_id)": "[&].person_id",
            "@": "[&].resource"
          }
        }
      }
    }
  }
]

但不幸的是，它总是将同一索引中的所有值映射到一个array.

推荐答案

通过遍历第一个转换规范中的100数组，可以使用两个连续的shift转换规范

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*s": { // this tecnique stands for extracting by the replacement of the asterisk through use of &(2,1) below
          "*": {
            "@(2,person_id)": "[&3].&1.person_id", // to separate by indexes of the array to generate three level for three independent objects
            "@": "[&3].&1.&(2,1)"
          }
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*": ""
      }
    }
  }
]

站点http://jolt-demo.appspot.com/上的101是