โ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-29-2022 09:35 AM
@Dheeraj - Yes, this is exactly what I am looking for.
โ06-29-2022 09:51 AM
@amit.saroha
I have copied the JSON Splitter to a JSON Generator snap and the following expressions works fine in a mapper
jsonPath($, "$[?(value['ns0:IntegrationName']=='EBSPERSON')]['ns0:ContentId']")
Also, attaching the pipeline just in case you need it for reference
Test Expr - Community_2022_06_29.slp (4.9 KB)
โ06-29-2022 10:19 AM
@Dheeraj , Thanks again for your help but it does not seems working when I placed the same expression in the mapper for me.
โerrorโ:
โInvalidยทJSON-path:ยท$[?(value[โns0:IntegrationNameโ]==โEBSPERSONโ)][โns0:ContentIdโ]โ
โstacktraceโ:
โcom.snaplogic.common.jsonpath.InvalidPathException:ยทInvalidยทaccessorยท(http://xmlns.oracle.com/apps/hcm/processFlows/core/flowActionsService/types/)ยทinยทpath:ยทcom.snaplogic.snap.api.ExpressionLocation@708cedde\r\nโatยทcom.snaplogic.expression.JsonPathExpressionService.evaluate(JsonPathExpressionService.java:119)\r\nโatยทcom.snaplogic.jsonpath.PathWalker.evaluate(PathWalker.java:167)\r\nโatยทcom.snaplogic.jsonpath.tokens.FilterToken.testMember(FilterToken.java:57)\r\nโatยทcom.snaplogic.jsonpath.tokens.FilterToken.traverse(FilterToken.java:71)\r\nโatยทcom.snaplogic.jsonpath.tokens.SubscriptToken.traverse(SubscriptToken.java:51)\r\nโatยทcom.snaplogic.jsonpath.PathWalker.traverse(PathWalker.java:402)\r\nโatยทcom.snaplogic.jsonpath.PathWalker.traverse(PathWalker.java:462)\r\nโatยทcom.snaplogic.jsonpath.JsonPathImpl.read(JsonPathImpl.java:138)\r\nโatยทsl.EvaluatorUtils.jsonPathRead(EvaluatorUtils.java:697)\r\nโatยทcom.snaplogic.expression.GlobalScope$JsonPathFunction.eval(GlobalScope.java:302)\r\nโatยทsl.EvaluatorUtils.callFunction(EvaluatorUtils.java:760)\r\nโatยทSC.evaluate(UnknownยทSource)\r\nโatยทcom.snaplogic.util.ExpressionUtils$MyExpressionProperty.eval(ExpressionUtils.java:281)\r\nโatยทcom.snaplogic.snap.api.impl.PropertyValuesImpl$ValidatingExpressionProperty.eval(PropertyValuesImpl.java:1005)\r\nโatยทcom.snaplogic.snaps.transform.DataTransform.processBinary(DataTransform.java:263)\r\nโatยทcom.snaplogic.snaps.transform.DataTransform.process(DataTransform.java:216)\r\nโatยทcom.snaplogic.snap.api.ExecutionUtil.process(ExecutionUtil.java:106)\r\nโatยทcom.snaplogic.snap.api.ExecutionUtil.executeForDocument(ExecutionUtil.java:118)\r\nโatยทcom.snaplogic.snap.api.ExecutionUtil.execute(ExecutionUtil.java:81)\r\nโatยทcom.snaplogic.snap.api.SimpleSnap.execute(SimpleSnap.java:70)\r\nโatยทcom.snaplogic.cc.snap.common.SnapRunnableImpl.executeSnap(SnapRunnableImpl.java:800)\r\nโatยทcom.snaplogic.cc.snap.common.SnapRunnableImpl.executeForSuggest(SnapRunnableImpl.java:647)\r\nโatยทcom.snaplogic.cc.snap.common.SnapRunnableImpl.doRun(SnapRunnableImpl.java:856)\r\nโatยทcom.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:435)\r\nโatยทcom.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:117)\r\nโatยทjava.base/java.util.concurrent.FutureTask.run(UnknownยทSource)\r\nโatยทjava.base/java.util.concurrent.Executors$RunnableAdapter.call(UnknownยทSource)\r\nโatยทjava.base/java.util.concurrent.FutureTask.run(UnknownยทSource)\r\nโatยทjava.base/java.util.concurrent.ThreadPoolExecutor.runWorker(UnknownยทSource)\r\nโatยทjava.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(UnknownยทSource)\r\nโatยทjava.base/java.lang.Thread.run(UnknownยทSource)\r\nCausedยทby:ยทcom.snaplogic.snap.api.SnapDataException:ยทInvalidยทaccessorยท(http://xmlns.oracle.com/apps/hcm/processFlows/core/flowActionsService/types/)ยทinยทpath:ยทcom.snaplogic.snap.api.ExpressionLocation@708cedde\r\nโatยทsl.EvaluatorUtils.indexSuffix(EvaluatorUtils.java:1411)\r\nโatยทSC.evaluate(UnknownยทSource)\r\nโatยทcom.snaplogic.expression.JsonPathExpressionService.evaluate(JsonPathExpressionService.java:117)\r\nโโฆยท30ยทmore\r\nโ
โreasonโ:
โInvalidยทaccessorยท(http://xmlns.oracle.com/apps/hcm/processFlows/core/flowActionsService/types/)ยทinยทpath:ยทcom.snaplogic.snap.api.ExpressionLocation@708ceddeโ
โresolutionโ:
โPleaseยทcheckยทexpressionยทsyntaxยทandยทdataยทtypes.โ
โstatus_codeโ:
โerrorโ
โ06-30-2022 12:38 AM
Per my understanding, you need to get the fields out of objects in array, that their value starts with โEBSPERSON_โ. If thatโs so, try the following expression:
$Document_ID.map(x=>x.filter((v,k)=> v.startsWith('EBSPERSONAD_')))