Hi,
I have a requirement with input data as: {"field1":"xyz","field2":"xyz2","field3":"xyz3", "field4":"xyz4"}
I need the output data as below: {"Data":{"field1":"xyz","field2":"xyz2","field3":"xyz3"},"field4":"xyz4"} to load into MongoDB.
Please suggest whether to use Data Generator or JSON Generator or custom Groovy code will be useful to create a nested JSON object
You can manipulate the record with the Expression Evaluator and Field Renamer, then either do the JSON encoding in the destination or use Data Generator.
First, use Expression Evaluator to create the /Data field as an empty map:
Then use Field Renamer to put /field1, /field2 and /field3 under /Data:
This combination will restructure the records as you require:
Now, if you need the JSON as a string, you can use Data Generator to create the JSON, but if you are writing to a file, Kafka etc, you can just set the data format in the destination to JSON.
Cheers...It worked. I tried with all the processors like Field Merger, JSON Generator and Data Generator, but was unable to do it. Nice to know about how to use emptyMap expression.
Asked: 2019-01-23 10:14:08 -0600
Seen: 37 times
Last updated: Jan 23
Hi! What's the criteria for leaving out "field4" in your example?
Hi, I have a classification for nested object which only need field1, field2 and field3. If we can do only with all the fields, I can separate field4 later using a processor like field merger.
Are the field names actually "field1", "field2"...?
We have a business names for these columns...just for generalization named it as field1, field2