add node in json array using Apache nifi

1 reply
1528 views
Translate All

field to add

"quality"

input json :

{
"json_data": {
"id": "1234",
"items": [
{
"id": "000000",
"metadata": {
"newId": "82896888047600"
}
}
]
}
}

output json :

{
"json_data": {
"id": "1234",
"items": [
{
"id": "000000",
"metadata": {
"newId": "82896888047600",

"quality" :"good"
}
}
]
}
}

Apache NiFi

araujoAnswer

Platinum ⭐️⭐️⭐️

@sahil0915 ,

Please try the JoltTransformJSON processor with the following Chain specification:

[
  {
    "operation": "default",
    "spec": {
      "json_data": {
        "items[]": {
          "*": {
            "quality": "good"
          }
        }
      }
    }
  }
]

Cheers,

André

-- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.

araujoAnswer

Platinum ⭐️⭐️⭐️

@sahil0915 ,

Please try the JoltTransformJSON processor with the following Chain specification:

[
  {
    "operation": "default",
    "spec": {
      "json_data": {
        "items[]": {
          "*": {
            "quality": "good"
          }
        }
      }
    }
  }
]

Cheers,

André

Translate

-- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.