NiFi - Expression Language - trouble with nested and-/or-conditions

justenji — Mon, 29 Jul 2019 17:51:50 GMT

I'am struggling with Expression Language concerning nested and-/or-conditions.

In my UpdateAttribute the variable KONTO_IST_AN should be getting the result in boolean which is provided by this expression.

Sample content of RESPONSE (always exactly one element at one time):

[{"antauschbis":"20191231","antauschvon":"20190101","id":"(422)"}]  => expected result: true

[{"antauschbis":null,"antauschvon":"20190101","id":"(422)"}]  => expected result: true

[{"antauschbis":"20190531","antauschvon":"20190101","id":"(422)"}]  => expected result: false

[{"antauschbis":null,"antauschvon":"20200101","id":"(422)"}]  => expected result: false

Expression:

${RESPONSE:jsonPath('$.[0].id'):equals(${KONTO_BV}):
   and(${RESPONSE:jsonPath('$.[0].antauschvon'):le(${now():format("yyyyMMdd")}):
        and(${RESPONSE:jsonPath('$.[0].antauschbis'):ge(${now():format("yyyyMMdd")}):
              or(
            ${RESPONSE:jsonPath('$.[0].antauschbis'):isEmpty()})}
           )
     )
}

But there seems to by a syntax error because the attribute KONTO_IST_AN contains after execution of UpdateAttribute the above expression not the expected result.

Checked all square and round brackets and can't finde my error.

Could someone please tell me how to resolve this?

Re: NiFi - Expression Language - trouble with nested and-/or-conditions

justenji — Mon, 29 Jul 2019 19:32:55 GMT

Got it! There was one } missing. Thought if the editor shows the expression coloured it would by syntactical correct.

So it has to be:

${RESPONSE:jsonPath('$.[0].id'):equals(${KONTO_BV}):
  and(${RESPONSE:jsonPath('$.[0].antauschvon'):le(${now():format("yyyyMMdd")}):
        and(${RESPONSE:jsonPath('$.[0].antauschbis'):ge(${now():format("yyyyMMdd")}):
              or(
            ${RESPONSE:jsonPath('$.[0].antauschbis'):isEmpty()})}
           )}
     )
}

question NiFi - Expression Language - trouble with nested and-/or-conditions in Support Questions

NiFi - Expression Language - trouble with nested and-/or-conditions

Re: NiFi - Expression Language - trouble with nested and-/or-conditions