โ05-24-2022 01:19 PM
Hi All,
I have an expression file with the below details and I want to read these job names from the expression file and understand how I can trigger three different pipelines based on these three values?
{
Job_1: โEBS_JOB1โ,
Job_2: โEBS_JOB2โ,
Job_3: โEBS_JOB3โ
}
โ05-24-2022 02:59 PM
Hi @amit.saroha,
First you need to setup that Expression File inside the pipeline.
After that anywhere in the pipeline where you can write expressions, you will have an access to that file.
You can access that file by typing lib.
followed by the name of the file what you will specify inside the Edit Pipeline.
Ex: lib.configFile
Regards,
Viktor
โ05-24-2022 03:52 PM
@viktor_n Thanks for your response. I have created and uploaded file and used it as you have shown but I am unable to understand how in the expressions I can read those three values and trigger one pipeline for each value. Could you please give some inputs on this?
โ05-25-2022 01:54 AM
To be able to write expressions, this box needs to be checked.
This would return the data inside the file.
When you come to this point you can use .values()
function, that will return list of the values.
With JSON Splitter snap you could split that list and set this values inside the Pipeline Execute.
โ05-25-2022 09:18 AM
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โ