How to handle null or empty element

Question

Hi,
I need to use null and empty condition in router. curretnly i am using:-
$ZSDATA.IDOC.EDL2.EDL4.BEL != “”
but i feel i am not handling it correctly.
Any inputs?

j_angelevski · Answer

Hi @Sahil ,
Which value are you expecting to be null ? With your current condition it will only check if …BEL is not empty and if any value before it is null it will fail.
You can either try this with the .get() method. You can also try with Data Validator snap to check if a value is not present or if it is empty.

clinton_hemmant · Answer

Data Validator does not seem to be able to check null values

clinton_hemmant · Answer

Must use minLength and Constraint value = 1Required does not work for null.&nbsp; Pattern = null does not work

endor_force · Answer

Null values should be possible to identify in expressions in most places.The following condition would check that BEL is not blank or null, split them up if you need to handle them separately in the router.&nbsp;$ZSDATA.IDOC.EDL2.EDL4.BEL != "" &amp;&amp; $ZSDATA.IDOC.EDL2.EDL4.BEL != nullIf you need to do the opposite to catch if an element is null or blank you simply change the conditions:$ZSDATA.IDOC.EDL2.EDL4.BEL == "" || $ZSDATA.IDOC.EDL2.EDL4.BEL == nullIf you have scenarios where you can be missing the element completely you may have to also throw in a check first that the object exists at all.If you are having null safe access in a mapper where you map BEL, it would make this redundant.$ZSDATA.IDOC.EDL2.EDL4.hasPath("BEL")&nbsp;

Forum Discussion

How to handle null or empty element

Recent Discussions

How to get filename from file reader

Generate expression file from database query

Can we generate XML file in pretty print format using native snapLogic snaps?

401 error with HTTP Client and NTLM

Pagination and nextCursor in header