Using Sum JSONpath operation in cmessagerouter trigger

LLockwood1601995176 — Fri, 15 Nov 2024 23:42:15 GMT

I am attempting to have a JSON payload be directed based on the sum of values in a JSON array. I want the cmessagerouter to take the sum of multiple elements and if it equals 0 then the payload should flow that way. If the OBLIGATEDAMT fields all sum up to 0, then they should flow the directed way in the image below.

The first image shows a flow of the route as expected along with an attempted Jsonpath expression.

The 2nd image shows the JSON file and the fields the JSONpath expression should be operating against.

The expressions I have tried are:

"$.sum[?(@.AWARD.AWARDLINE.OBLIGATEDAMT == '0')]"

"$.sum($.AWARD.AWARDLINE[?(@.OBLIGATEDAMT == 0)].OBLIGATEDAMT)"

topic Using Sum JSONpath operation in cmessagerouter trigger in Talend Studio

Using Sum JSONpath operation in cmessagerouter trigger