use jolt spec and convert json to json array

Question

I have a question about transforming a json to jsonArray by jolt spec in apache nifi, my input is :

{
  "name": "tom",
  "experience ": [
    {
      "year": "2020",
      "corp": "aaaa"
    },
    {
      "year": "2019",
      "corp": "bbbb"
    }
  ]
}

and the output I need is :

[
  {
    "name": "tom",
    "year": "2020",
    "corp": "aaaa"
  },
  {
    "name": "tom",
    "year": "2019",
    "corp": "bbbb"
  }
]

can anyone help me ?

I have tried below spec:[ { "operation": "shift", "spec": { "experence": { "*": { "year": "experence[&1].year", "corp": "experence[&1].corp" } } } } ] ,but it can not retrive higher level attribute called "name" — AE86
– AE86, Commented Mar 10, 2020 at 14:09

mattyb · Accepted Answer · 2020-03-10 16:55:40Z

1

This should work:

[
  {
    "operation": "shift",
    "spec": {
      "experience": {
        "*": {
          "@(2,name)": "[#2].name",
          "*": "[#2].&"
        }
      }
    }
  }
]

Note that you have a space in the field experience, I removed it from the spec (and the sample input) when testing on the online Jolt tester.

answered Mar 10, 2020 at 16:55

mattyb

12.2k20 silver badges24 bronze badges

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

1 Comment

AE86 Over a year ago

Yes, it works and makes my topology running as expected

Collectives™ on Stack Overflow

use jolt spec and convert json to json array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related