Yes, I presume so.
So you might change #3 to
jsonPath($,"$.IDOC.E1EDP01[?(@.hasPath('E1EDPT1') && @.E1EDPT1.hasPath('E1EDPT2'))]").length > 0
Hi Parin,
I’m not sure if my assumptions are correct attributes are group of column names right? See sample pipeline
canvas03_2020_09_19.slp (10.4 KB)
I’ll let the Doc Team know.
I also didn’t quite understand the “required” function in the validate snap. You could use $[FIELD] != null in a filter snap instead to get the same effect.
Thanks. We wanted to take advantage of the data validator snap’s error output ability. We ended up adding a mapper in front of the data validator snap to convert them to boolean strings (“true”/“false”) and using the pattern matching on data validator.
It would be good to have some clarity on how “Required” works. According to the documentation “Required” should work for all data types. We also tried to validate the date using “Type” validation for “date”, that didn’t work too.
The validator appears to be working good only for string types.
