Append fields to a existing JSON

[walkerline117]

Hi,

How do I append some hardcode json string into an exsting json document.

For example, my Oracle select Snapl returns below as output

[{“DEGREE_ID”:269,“DEGREE_NAME”:“1. Staatsexamen”},
{“DEGREE_ID”:270,“DEGREE_NAME”:“1. jur. Staatsexamen”},
{“DEGREE_ID”:273,“DEGREE_NAME”:“1. med. Staatsexamen”}]

as you can see each row returns as on doc.

How can I transforme it to

{
“apiVersion”: “1.0”,
“educationDegrees”: [{“DEGREE_ID”:269,“DEGREE_NAME”:“1. Staatsexamen”},
{“DEGREE_ID”:270,“DEGREE_NAME”:“1. jur. Staatsexamen”},
{“DEGREE_ID”:273,“DEGREE_NAME”:“1. med. Staatsexamen”}]
}

As you can see I just added some hardcode fields on top of my response.

Thanks

[nganapathiraju]

Please look at this post

Mapping Question... Map to dynamic names? Designing Pipelines

The extend() method on objects can help you construct objects dynamically. You can pass it an array of key/value pairs and it will create a new object containing the values from the original object plus whatever was specified by the pairs. In your case, I think you can create the pairs by doing a map over the customDataSets array, like so: $customDataSets.map(x => [x.customData.name, x.customData.value]) You can then extend the original input doc, to create a new doc containing the original s…