How to append constant array to another array using Jolt spec transformation

Question

I have the following input JSON:

[
  {
    "id": "id1",
    "projectId": "ALL",
    "composable": "true",
    "schema": {
      "properties": {},
      "required": [ "name", "db_access" ]
    }
  },
  {
    "id": "id2",
    "projectId": "ALL",
    "composable": "true",
    "schema": {
      "properties": {},
      "required": [ "test", "remote" ]
    }
  }
]

Desired JSON:

[
  {
    "id": "id1",
    "projectId": "ALL",
    "composable": "true",
    "schema": {
      "properties": {},
      "required": [ "name", "db_access", "account", "region" ]
    }
  },
  {
    "id": "id2",
    "projectId": "ALL",
    "composable": "true",
    "schema": {
      "properties": {},
      "required": [ "test", "remote", "account", "region" ]
    }
  }
]

I wish to append the "account" and "region" Strings to the beginning or end (it doesn't matter) of the "required" array. How do I achieve that using Jolt spec transformation?

Barbaros Özhan · Accepted Answer · 2022-11-15 14:21:18Z

1

You can use such a shift transformation spec

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*": "[&1].&", // attributes (or objects/arrays other than "schema"
        "schema": {
          "*": "[&2].&1.&", // attributes (or objects/arrays other than "required" 
          "required": {
            "#region|#account": "[&3].&2.&1", // [&3] : represents going three levels up the tree to get values of the indexes in array-wise manner, &2 : replicates "schema", &1 : one level up to grab "required"
            "*": "[&3].&2.&1"
          }
        }
      }
    }
  }
]

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

edited Nov 15, 2022 at 14:21

answered Nov 15, 2022 at 11:42

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

mdzh Over a year ago

Hey, thanks! That works as a charm. I updated my question a bit - the input/output json is now a list. Could you please update your answer to accommodate that?

mdzh Over a year ago

I'm not sure this works as expected. I'm getting: { "id" : [ "id1", "id2" ], "projectId" : [ "ALL", "ALL" ], "composable" : [ "true", "true" ], "schema" : { "properties" : [ { }, { } ], "required" : [ "region", "account", "name", "db_access", "region", "account", "test", "remote" ] } }

Barbaros Özhan Over a year ago

It's important to see the exact picture for the Jolt. I've just edited based on the latest case @mdzh

mdzh Over a year ago

This is better but there's still problem with the spec - the schema part is missing now. 'required' and 'properties' are directly under top level

Barbaros Özhan Over a year ago

excuse me I missed then @mdzh

Collectives™ on Stack Overflow

How to append constant array to another array using Jolt spec transformation

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related