Array for one element in Array of json, Nifi

Question

I have the following input json:

{
  "ListArray": [
    {
      "address": "address1",
      "contact": "123456789",
      "bpId": 123
    },
    {
      "address": "address2",
      "contact": "135792468",
      "bpId": 456
    },
    {
      "address": "address3",
      "contact": "246812356",
      "bpId": 678
    }
  ]
}

And I am using the below spec expression :

[
  {
    "operation": "shift",
    "spec": {
      "ListArray": {
        "*": {
          "*": "&"
        }
      }
    }
  }
]

Giving me this kind of output:

{
 "Address_list": ["address1","address2","address3"],
 "Contact_list": ["123456789","135792468","246812356"],
 "Id_list": [123,456,678]
}

But, If the input (array of jsons) has only one json, for example:

{
  "ListArray": [
    {
      "address": "address1",
      "contact": "123456789",
      "bpId": 123
    }
  ]
}

Then I am getting the following output

{
  "Address_list": "address1",
  "Contact_list": "123456789",
  "Id_list": 123
}

For one element, an array isn't forming. I want the output to be in an array even if there is only one element. Thanks, in advance.

Barbaros Özhan · Accepted Answer · 2021-05-20 11:35:46Z

1

Just a slight change, which is appending .[] to the currently existing ampersand(&), will resolve this such as

[
  {
    "operation": "shift",
    "spec": {
      "ListArray": {
        "*": {
          "*": "&.[]"
        }
      }
    }
  }
]

answered May 20, 2021 at 11:35

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

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

Collectives™ on Stack Overflow

Array for one element in Array of json, Nifi

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related