Jolt Transform using two 2 values to create a new key/value pair

Question

I have a JSON input that I am transform using JOLT shift. My problem is I want to use the value of an input key, as a new key in the output data, and in parallel add another value into that new outputted key. Here is my input:

"Description": {
  "Name": "John",
  "KeyNameId": "John123",
  "Description": "John's description"
}

And I want my output to be:

"Description": {
  "John123": "John's description"
}

Anyway to do this without using two shift operations? Or with two shifts if one isn't possible?

score 3 · Answer 1 · answered Aug 04 '17 at 22:53

Yes, it can be done in a single shift using the "@(Number,words)" operator.

Input - slightly modified for clarity

{
  "Top": {
    "Name": "John",
    "KeyNameId": "John123",
    "Description": "John's description"
  }
}

Spec

[
  {
    "operation": "shift",
    "spec": {
      "Top": {
        // match the key "Description" and copy it's value to the Output.
        // The Output path being defined by @(1,KeyNameId), which means
        //  go back up the tree 2 levels (0,1) and lookup the value of 
        //  "KeyNameId"
        "Description": "@(1,KeyNameId)"
      }
    }
  }
]

score 0 · Answer 2 · answered Feb 20 '19 at 18:03

0

To be more precise,

[
  {
    "operation": "shift",
    "spec": {
      "Description": {
        "@Description": "Description.@KeyNameId"
      }
    }
  }
]

answered Feb 20 '19 at 18:03

Magesh

427
3
12

Jolt Transform using two 2 values to create a new key/value pair

2 Answers2