Can't extract a value inside nested JSON using Jolt Transform

I have this problem.

Given this sample JSON

[
  {
    "aaa": "-",
    "name": "something_val",
    "bbb": "-",
    "is_active": true,
    "repository": null,
    "image_url": "some_val",
    "ccc_id_tmp": 2,
    "ddd_id_tmp": 3,
    "ccc_created_at": "timestamp",
    "updated_at": "timestamp",
    "result_ccc_id_lookup": {
      "ccc_id": "some_uuid"
    },
    "result_ddd_id_lookup": {
      "ddd_id": "some_uuid"
    }
  },
  {
    "aaa": "hi",
    "name": "something_val",
    "bbb": "yooo",
    "is_active": false,
    "repository": null,
    "image_url": "some_val",
    "ccc_id_tmp": 4,
    "ddd_id_tmp": 5,
    "ccc_created_at": "timestamp",
    "updated_at": "timestamp",
    "result_ccc_id_lookup": {
      "ccc_id": "some_uuid_2"
    },
    "result_ddd_id_lookup": {
      "ddd_id": "some_uuid_2"
    }
  }
]

The goal is I want to use Jolt Transform to extract the values inside result_ccc_id_lookup and result_ddd_id_lookup, meaning I will extract the ccc_id and ddd_id values.

So, the expected output will be like this

{
  "aaa": "-",
  "name": "something_val",
  "bbb": "-",
  "is_active": true,
  "repository": null,
  "image_url": "some_val",
  "ccc_id_tmp": 2,
  "ddd_id_tmp": 3,
  "ccc_created_at": "timestamp",
  "updated_at": "timestamp",
  "ccc_id": "some_uuid",
  "ddd_id": "some_uuid"
}

Right now, I'm using this Jolt Transform to extract the value like the expected output

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "aaa": "[&1].aaa",
        "bbb": "[&1].bbb",
        "objective": "[&1].objective",
        "is_active": "[&1].is_active",
        "repository": "[&1].repository",
        "image_url": "[&1].image_url",
        "ccc_id_tmp": "[&1].ccc_id_tmp",
        "ddd_id_tmp": "[&1].ddd_id_tmp",
        "ccc_created_at": "[&1].ccc_created_at",
        "updated_at": "[&1].updated_at",
        "result_ccc_id_lookup": {
          "ccc_id": "[&1].ccc_id"
        },
        "result_ddd_id_lookup": {
          "ddd_id": "[&1].ddd_id"
        }
      }
    }
  }
]

But, the output is only like this. The ccc_id and ddd_id are missing

{
  "aaa": "-",
  "name": "something_val",
  "bbb": "-",
  "is_active": true,
  "repository": null,
  "image_url": "some_val",
  "ccc_id_tmp": 2,
  "ddd_id_tmp": 3
}

Can you help me with this one? maybe something is wrong with my Jolt Transform?

Thank you

Solution

No need to articulate every attribute one by one, but the following transformation is enough to express all

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*": "[&1].&",  // replicate all attributes those have the key which don't start with "result" 
        "result*": {    // other elements taken from the deeper level of one step
          "*": "[&2].&" // so increment the degree of identifier by 1, eg. [&1]->[&2]
        }
      }
    }
  }
]

the demo on the site http://jolt-demo.appspot.com/ is :