E9.2 how to collect value from xml body with groovy

[cazzafed]

Hi, i have this XML, i need collect values in <destinatariosEmail> section...
any idea or help?

<parametros>
<modalidadEnvioSet>2</modalidadEnvioSet>
<retornarKuDE>N</retornarKuDE>
<retornarXmlFirmado>N</retornarXmlFirmado>
<envioEmailKude>
<enviarEmail>S</enviarEmail>
<destinatariosEmail>
<destinatarioEmail>[email protected]</destinatarioEmail>
<destinatarioEmail>[email protected]</destinatarioEmail>
</destinatariosEmail>
<esquemaEnvio>ESQKUDE</esquemaEnvio>
</envioEmailKude>
</parametros>

 

[JohnDanter2]

Maybe thiese links will help

How to get data from xml file using groovy?

Following groovy script is not working as expected. def xml="<Collection><CustomerQuote><ID>99988877766</ID><TypeCode>2059</TypeCode><ApprovalStatusCode&...

stackoverflow.com

The Apache Groovy programming language - Processing XML

groovy-lang.org

 

[cazzafed]

yes, im using this code:

String xml = (String)inputMap.get("String")

def completeXml= new XmlSlurper().parseText(xml);
def IDs = completeXml.envioEmailKude.destinatariosEmail*.text();

but, found this output: [[email protected][email protected]]
my expectate ouput: [[email protected],[email protected]]

 

[DaveWagoner]

John's Stackoverflow article link contains the key.

To get that to work make sure you have "import groovy.xml.*;" at top, and the rest is in finding the address of your email values.

Have fun figuring it out!

 

[AutoDeploy]

yes, im using this code:


but, found this output: [[email protected][email protected]]
my expectate ouput: [[email protected],[email protected]]

Something like the below should work:

def xml = ''' <parametros> <modalidadEnvioSet>2</modalidadEnvioSet> <retornarKuDE>N</retornarKuDE> <retornarXmlFirmado>N</retornarXmlFirmado> <envioEmailKude> <enviarEmail>S</enviarEmail> <destinatariosEmail> <destinatarioEmail>[email protected] </destinatarioEmail> <destinatarioEmail>[email protected] </destinatarioEmail> </destinatariosEmail> <esquemaEnvio>ESQKUDE</esquemaEnvio> </envioEmailKude> </parametros> '''

def xmlSlurper = new XmlSlurper().parseText(xml)
def destinatariosEmail = xmlSlurper.envioEmailKude.destinatariosEmail.destinatarioEmail.collect { it.text() }

println destinatariosEmail

FYI n the XML provided, the destinatarioEmail elements are not closed properly.