Solved
Key value pair from object array
Hi,
I would like to create the below outbound message from an incoming object array.
{
"root": {
"elementName": {
"@attributeName": "attributeValue",
"$": "el...
Forum Discussion
Thanks, @viktor_n - Thanks,
Below is coming out of the output, could please suggest how I can have only below three values in my output.
“Person_Details_HCM_to_EBS_Interface”
“Assignment_People_Group_Details_HCM_to_EBS_Interface”
“Assignment_Details_HCM_to_EBS_Interface”
The output of mapper - Need above three only in output or in JSON splitter
[
{
"INT_Batch_ID":
9121
"INT_MASTER_Log_ID":
33814
"HCM_Job":[
"Person_Details_HCM_to_EBS_Interface"
"Assignment_People_Group_Details_HCM_to_EBS_Interface"
"Assignment_Details_HCM_to_EBS_Interface"
60
60
"EBS_JOB1"
"EBS_JOB2"
"EBS_JOB3"
"EBS_JOB4"
"EBS_JOB5"
"EBS_JOB6"
60
60
]
}
]
Error while using $HCM_Job.startsWith(“HCM_”) in JSON splitter path expression
“error”:
“Unable to read data from path: $.HCM_Job.startsWith(“HCM_”)”
“reason”:
“Expecting object for JSON-Path field reference ‘startsWith(“HCM_”)’, found: List”
As I see you are serching for elements in “HCM_Job” list that contains “HCM”.
Inside Mapper before Splitter put this expression.
lib.ExpressionFile[0].HCM_Job.filter(el => el.contains("HCM")
This expression will get only those elements that contains “HCM” inside.
After that inside Splitter you will map this filtered list.
