โ06-28-2022 10:43 AM
Hi,
How I can use an expression to read the below in a mapper to get individual values true or false? I am using as - $DocumentId.startsWith(โEBSPERSON_โ)
[
{
"Content_ID":
"EBSPERSON_547229"
}
{
"Content_ID":
"EBSPERSONAD_547229"
}
{
"Content_ID":
"EBSPHONE_547229"
}
]
โ06-28-2022 11:57 AM
Thanks,
HCM Insert Person Records_2022_06_28.slp (65.9 KB)
@Dheeraj - I have attached the pipeline.
โ06-28-2022 12:13 PM
@amit.saroha
I wonโt be able to validate your pipeline as it needs accounts to connect to the systems. In scenarios like this, it would be great if you can export the data to a JSON generator snap and work on the expressions it would be a lot simpler and easier to debug.
I am attaching a sample pipeline where I tried to replicate your data and worked on the expression.
Test Expr - Community_2022_06_28.slp (3.6 KB)
โ06-28-2022 02:03 PM
@Dheeraj , thanks for your help but the sample data is not like the way I have. I have the below data coming out of mapper -
In the another mapper when I use it the below error comes -
โ06-28-2022 02:18 PM
I just want the value from this like shown below -
โ06-28-2022 03:57 PM
I have uploaded the JSON file as well id someone wants to give it a try.
Mapper1_output0.json (144 Bytes)