Jolt Json转换：使用属性值过滤键

Question

我正在尝试使用 Jolt 转换来转换 Json，在这里寻找一些输入。我正在尝试过滤一个键，该键是另一个属性的值。这是我的输入和预期输出

{
    "pid": "[e-mail]",
    "eventType": "new",
    "details": {   
        "participants": {
            "[e-mail]": {
                "id": "[e-mail]",
                "type": "Customer"
            },
            "[e-mail]": {           
                "id": "[e-mail]",               
                "name": "participantAgent1",
                "joinTime": 1617634021103, 
                "type":"Agent"              
               
            },
            "[e-mail]": {           
                "id": "[e-mail]",                
                "name": "participantAgent1",
                "joinTime": 1617634022303,
                "type":"Agent"
                
            }
        }        
    },
    "interactionId": "c5804d49-961d-11eb-9650-7fb32f44d8a5"  
}

我看到的输出是

{
    "pid": "[e-mail]",      
    "name": "participantAgent1",
    "joinTime": 1617634021103,
    "type":"Agent"
}

我试过的规格是

[
  {
    "operation": "shift",
    "spec": {
      "participants": {
        "@(2,pid)": {
          "@(3,pid)": "pid",
          "pType": "type",
          "name": "name",
          "joinTime":"joinTime"
        }
      }
    }
  }
]

但是我没有得到预期的输出。我也尝试了一些其他组合，但未能获得正确的输出。有人能帮忙吗？

Answer 1

[ // converting the matching value as the key to the value of the details.
  {
    "operation": "shift",
    "spec": {
      "details": "@(1,pid)"
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": {
        "participants": {
            "&1": { // matching with the target converted key
            "id": "pid",
            "type": "type",
            "name": "name",
            "joinTime": "joinTime"
          }
        }
      }
    }
  }
]