05-30-2023 10:28 AM
I have to transform documents that look like the following:
[{
“Id”: 999,
“field1”: “value1”,
“field2”: “value2”,
“field3”: “value3”
}
]
Into output like this.
[{
“Id”: 999,
“entity”: {
“path”: “field1”,
“op”: “replace”,
“value”: “value1”
}
},
{
“Id”: 999,
“entity”: {
“path”: “field2”,
“op”: “replace”,
“value”: “value2”
}
},
{
“Id”: 999,
“entity”: {
“path”: “field3”,
“op”: “replace”,
“value”: “value3”
}
}
]
There can be multiple documents being processed and the number of “fields” is more (30+) than the example shows. I have created a Mapper snap to do this work for a few fields but would like not to have to do it for 30+. I feel there is an expression/javascript solution to this but I am not well versed at this time.
Any ideas would be appreciated.
Regards,
Solved! Go to Solution.
05-30-2023 11:06 PM
Hi @Thom ,
I’ve attached a pipeline, hope this helps.
Test_Expression_2023_05_31.slp (3.5 KB)
Cheers 😉
05-30-2023 11:06 PM
Hi @Thom ,
I’ve attached a pipeline, hope this helps.
Test_Expression_2023_05_31.slp (3.5 KB)
Cheers 😉
06-01-2023 06:08 AM
Thanks so much. This worked as needed.
01-10-2024 04:19 AM
I'm unable to download the .slp file
01-10-2024 08:52 AM - edited 01-10-2024 09:28 AM
The new community platform didn't quite know how to deal with the .slp file extension. Pipelines need to be zipped before uploaded to this community platform.
Let me find it in the backup.