question Re: Nifi AttributesToJSON makes everything strings in Support Questions

question Re: Nifi AttributesToJSON makes everything strings in Support Questions https://community.cloudera.com/t5/Support-Questions/Nifi-AttributesToJSON-makes-everything-strings/m-p/316812#M226902 Not all credit goes to me but I was pointed to a better simpler way to achieve this. There are 2 ways. Solution 1 - and the simplest and elegant Use Nifi JoltTransformJSON Processor. The processor can make use of Nifi expression language and attributes in both left or right hand side of the specification syntax. This allows you to quickly use the JOLT default spec to add new fields (from flow-file attributes) to a new or existing JSON. Ex: <LI-CODE lang="markup">{"customer_id": 1234567, "vckey_list": ["test value"]}</LI-CODE> both of those fields values are stored in flow-file attributes as a result of a EvaluateJSONPath operation. Assume "customer_id_attr" and ""vckey_list_attr". We can simply generate a new JSON from those flow-file attributes with the "default" jolt spec and the right hand syntax. You can even add addition expression language functions to the processing <LI-CODE lang="markup">[ { "operation": "default", "spec": { "customer_id": ${customer_id_attr}, "vckey_list": ${vckey_list_attr:toLower()} } } ]</LI-CODE>This worked for me even when storing the entire JSON, path of "$", in a flow-file attribute. Solution 2 - complicated and uglier Use a sequence Nifi ReplaceText Processor. First use a ReplaceText processor to append the desired flow-file attribute to the file-content. <img src="https://community.cloudera.com/t5/image/serverpage/image-id/31238iBC1F47F2A4B7A7CA/image-size/medium?v=v2&px=400" role="button" title="tazzio_0-1621516138039.png" alt="tazzio_0-1621516138039.png" />If you are generating a totally new JSON, this would do it. If you are trying to modify an existing one, you would need to first append the desired keys, than use ReplaceText again to properly format as a new key in the existing JSON, from <LI-CODE lang="markup">{"original_json_key": original_json_obj}{"customer_id": 1234567, "vckey_list": ["test value"]}</LI-CODE>to<LI-CODE lang="markup">{"original_json_key": original_json_obj, "customer_id": 1234567, "vckey_list": ["test value"]}</LI-CODE>using<img src="https://community.cloudera.com/t5/image/serverpage/image-id/31239iFD91CAB0F50469A5/image-size/medium?v=v2&px=400" role="button" title="tazzio_1-1621516605995.png" alt="tazzio_1-1621516605995.png" />Then use JOLT to do further processing (that's why Sol 1 always makes sense) Hope this helps, spent about half a day figuring out the 2nd Solution and was pointed to Solution 1 by someone with more experience in Nifi Thu, 20 May 2021 13:17:50 GMT tazzio 2021-05-20T13:17:50Z