question Re: how do Add attributes to a json file in Support Questions

how do Add attributes to a json file

MarioFRS — Wed, 31 Aug 2022 19:55:55 GMT

Hey everyone,

I would like to add an attribute to a json file. The json file is a result of an api query with the Invoke HTTP procesor. As a next step I want to add an attribute to the json file to the existing fields

I expected this:

[ {
"_id" : "5d55246b9ac36012c14b5e7c",
"gtin" : "4009602235038",
"target.sku : "59218_5_champagner", <- added attribute value
"articleNumber" : "59218-376",
"styleGroupId" : "59218",
"colorGroupId" : "376",
"brand" : {
"_id" : "57f75950a56ab89d1973ee36"
},

Does anyone have any ideas?

Re: how do Add attributes to a json file

SAMSAL — Wed, 31 Aug 2022 21:17:35 GMT

Hi ,

You can use JoltJsonTransform Processor for that. So lets assume we have the following input:

[ { "_id": "5d55246b9ac36012c14b5e7c", "gtin": "4009602235038", "articleNumber": "59218-376", "styleGroupId": "59218", "colorGroupId": "376", "brand": { "_id": "57f75950a56ab89d1973ee36" } } ]

Add JoltTranformJson processor and set the Jolt Specification property to the following, notice this property allows you to use Expression Language therefore you can reference attributes in the flowfile:

[ { "operation": "modify-default-beta", //for modify-overwrite-beta "spec": { "*": { "target.sku": "${target.sku}" } } } ]

This will produce the following Json:

[ { "_id" : "5d55246b9ac36012c14b5e7c", "gtin" : "4009602235038", "articleNumber" : "59218-376", "styleGroupId" : "59218", "colorGroupId" : "376", "brand" : { "_id" : "57f75950a56ab89d1973ee36" }, "target.sku" : "someValue" } ]

If you find this helpful please accept solution.

Thanks

Re: how do Add attributes to a json file

rafy — Sun, 04 Sep 2022 20:08:14 GMT

Thanks Mr @SAMSAL for the insight. I learned from it because i was even thinking of telling him to use EvaluateJsonPath & ReplaceText processor.