Convert Integer to String in json, Nifi

Question

I have the following input json:

{
  "a": "value1",
  "b": [
    {
      "X": 1234
    },
    {
      "X": 4567
    }

    ]
}

I want the integer values to be converted to a string. Basically add double quotes to the integer. Desired output is:

{
  "a": "value1",
  "b": [
    {
      "X": "1234"   // want to add double quotes
    },
    {
      "X": "4567"   // want to add double quotes
    }

    ]
}

How do I achieve this? Thanks in advance.

user_5841306 · Answer

You can use modify-overwrite-beta transformation spec with toString function embedded such as

[
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "b": {
        "*": {
          "X": "=toString"
        }
      }
    }
  }
]

Convert Integer to String in json, Nifi

1 Answers