Forum Discussion

Sahil's avatar
Sahil
Contributor
4 years ago
Solved

Check if element exists in xml or not

Hi,
a requirement where to check if <VW>ER</VW> exists in xml or not.
sample xml 1:-

<?xml version="1.0" encoding="UTF-8"?>
<ORDER>
	<IDOC BEGIN="1">
		<KA1 SEGMENT="1">
			<VW>ZB</VW>
			<TN>6778</TN>
			<NR>708000</NR>
		</KA1>
		<KA1 SEGMENT="1">
			<VW>ER</VW>
			<TN>600729</TN>
			<NR>4018611</NR>
		</KA1>
	</IDOC>
</ORDER>

then I need flag = Y

sample xml 2:-

<?xml version="1.0" encoding="UTF-8"?>
<ORDER>
	<IDOC BEGIN="1">
		<KA1 SEGMENT="1">
			<VW>ZB</VW>
			<TN>6778</TN>
			<NR>708000</NR>
		</KA1>
		<KA1 SEGMENT="1">
			<VW>RE</VW>
			<TN>600729</TN>
			<NR>4018611</NR>
		</KA1>
	</IDOC>
</ORDER>

then I need flag = N

expression_language
pattern
  • viktor_n's avatar
    viktor_n
    4 years ago

    Hi @Sahil,

    Try this expression. In Mapper also need to check Pass Though.

    sl.ensureArray($ORDER.IDOC.KA1).find(f => f.get("VW") == "ER") != null ? "Y" :  "N"

    Regards,
    Viktor

3 Replies

  • viktor_n's avatar
    viktor_n
    Contributor II
    4 years ago

    Hi @Sahil,

    Try this expression. In Mapper also need to check Pass Though.

    sl.ensureArray($ORDER.IDOC.KA1).find(f => f.get("VW") == "ER") != null ? "Y" :  "N"

    Regards,
    Viktor

    • Sahil's avatar
      Sahil
      Contributor
      4 years ago

      @viktor_n , I want to read more into sl.ensureArray, could you please share some links.

  • viktor_n's avatar
    viktor_n
    Contributor II
    4 years ago

    Here is a link of the documentation.
    https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439396/SL+Functions+and+Properties#SLFunctionsandProperties-sl.ensureArray

    Here in the expression I am using sl.ensureArray() to transform KA1 into an array, since it is an object.

    When you work with xml data, if there are more same elements as it is KA1 in this situation, XML Parser will see it as Array, but if there’s only one element with the name KA1, the parser will accept it as object.

    .find() function works only with Arrays so in order for the expression not to fail we need to make sure that the element we are trying to map is not an array.

    Hope this will help you understand ensureArray a little bit more. If it need anything else, I will be happy to help 🙂