How will the JOLT spec look to achieve desired result with the following input?

Question

I am having troubles transforming JSON payload into the desired document.

I have following input:

{
  "events": [
    {
      "recipientId": "r0001"
    },
    {
      "recipientId": "r0002"
    }
  ],
  "networkResponseTime": 1234
}

Desired output:

{
  "events": [
    {
      "recipientIds": "r0001",
      "networkResponseTime": 1234"
    },
    {
      "recipientIds": "r0002",
      "networkResponseTime": 1234"
    }
  ]
}

How will the JOLT spec look like for this example?

So far I have smth like this:

[{
    "operation": "shift",
    "spec": {
      "events": {
        "*": {
          "recipientId": "events[&1].recipientIds"
        }
      }
    }
}]

score 1 · Accepted Answer · answered Oct 19 '17 at 18:11

Spec

[{
  "operation": "shift",
  "spec": {
    "events": {
      "*": {
        "recipientId": "events[&1].recipientIds",
        //
        // go back up to the root of the tree, and then 
        //  come back down the key "networkResponseTime", and
        //  send it's value to "events[&1].networkResponseTime"
        "@(2,networkResponseTime)": "events[&1].networkResponseTime"
      }
    }
  }
}]

How will the JOLT spec look to achieve desired result with the following input?

1 Answers1