Split array inside JSON with JOLT

Question

I have a JSON look like:

[
  {
    "mainId": 12854,
    "subIds": [
      25,
      26,
      27
    ]
  }
]

I want to split values inside subIds to create diffrent rows. Can I get expected result with JOLT?

[
  {
    "mainId": 12854,
    "subId": 25
  },
  {
    "mainId": 12854,
    "subId": 26
  },
  {
    "mainId": 12854,
    "subId": 27
  }
]

Barbaros Özhan · Accepted Answer · 2023-03-01 18:54:33Z

2

You can walk through the indexes of subIds array while grabbing the value of mainId by @(2,mainId) in order to going up the three two levels, and using [&1] as common factor to reach those indexes such as

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*s": {
          "*": {
            "@": "[&1].&(2,1)", // &(2,1) : going two levels up the tree to extract the value "subId" from "subIds" by using 1 as the second argument to represent te first asterisk(which might be multiple)
            "@(2,mainId)": "[&1].mainId"
          }
        }
      }
    }
  }
]

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

edited Mar 1, 2023 at 18:54

answered Feb 7, 2022 at 12:48

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

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

1 Comment

Barbaros Özhan Over a year ago

@SarahMesser Lately I've realised what you have meant, and thanks for reminding me that I indeed normally add the link but here seems that I forgot. Btw, you can also check out stackoverflow.com/… for my answers of Jolt. Have a nice study!

Collectives™ on Stack Overflow

Split array inside JSON with JOLT

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related