Get outer json key value into very json in the nested json array using JOLT

Question

I have a JSON like this

{
  "id": "1234",
  "name": "something",
  "list": [
    {
      "A": "Something"
    },
    {
      "B": "Something1"
    }
  ]
}

What I would like is to do is add id and name to both the JSON's present inside list I've gone through a couple of questions and I couldn't find anywhere where somebody had done this.

James · Accepted Answer · 2017-04-19 15:46:46Z

4

I believe the following Shift spec will work:

{
    "id|name": "&",
    "list": {
      "*": {
        "@(2,id)": "&2.[&1].id",
        "@(2,name)": "&2.[&1].name",
        "*": "&2.[&1].&"
      }
    }
}

With your sample data, the output produced was:

{
    "id": "1234",
    "name": "something",
    "list": [{
        "id": "1234",
        "name": "something",
        "A": "Something"
    }, {
        "id": "1234",
        "name": "something",
        "B": "Something1"
    }]
}

answered Apr 19, 2017 at 15:46

James

12k2 gold badges38 silver badges42 bronze badges

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

1 Comment

Gokul Shanth Over a year ago

Yes I had already figured it out, this is what I did. Thanks a lot!

mattyb · Accepted Answer · 2017-04-19 20:10:48Z

1

This spec should give you what you want:

[
  {
    "operation": "shift",
    "spec": {
      "list": {
        "*": {
          "@(2,id)": "&2.[&1].id",
          "@(2,name)": "&2.[&1].name",
          "*": "&2.[&1].&"
        }
      }
    }
  }
]

With your input it gives the following as output:

{
  "list" : [ {
    "A" : "Something",
    "id" : "1234",
    "name" : "something"
  }, {
    "B" : "Something1",
    "id" : "1234",
    "name" : "something"
  } ]
}

answered Apr 19, 2017 at 20:10

mattyb

12.2k20 silver badges24 bronze badges

1 Comment

mattyb Over a year ago

Oops didn't see James had answered already, sorry about that! Looks like you can choose between the two depending on whether you want the original top-level fields in the outgoing JSON, although you can just remove his id|name entry and get what I had. Upvote his, I should've refreshed the page before submitting :)

Collectives™ on Stack Overflow

Get outer json key value into very json in the nested json array using JOLT

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related