Re: [Ftpapi] How to get the value?

[Fabio Colombo <f.colombo@xxxxxxxxxxxxxxxxxxx>]

Frank,

there's also the
possibility to use XMLTABLE and XMLTRANSFORM and process the xml with normal
sql access.

Here are some
useful examples and reference
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/rzasp/rzaspxmltexample.htm
https://www.ibm.com/developerworks/data/library/techarticle/dm-0708nicola/
I can try also
this way.

Fabio






From:
       Frank
Broome <Frank.Broome@xxxxxxxxxxxxxx>
To:
       "FTPAPI/HTTPAPI
mailing list (ftpapi@xxxxxxxxxxxxxxxxxxxxxx)" <ftpapi@xxxxxxxxxxxxxxxxxxxxxx>
Date:
       29/01/2020
01:08
Subject:
       [Ftpapi]
How to get the value?
Sent
by:        ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx

---

Everyone,

 

Here’s a challenge for you all.

 

I have to parse an XML string that partly looks this.

You would say that ‘ExtensionField’ has attribute ‘name’ and that “Sales Branch” is the value.

However if you look closely you can see that the actual value is ‘IT’ (for “Sales Branch”).

I have never seen this combination of elements, attributes and its values before.

 

<Extension extensionTemplate="PARTNER_HEADER">

        <ExtensionField name="Sales Branch">IT</ExtensionField>

        <ExtensionField name="GLA Attached">N</ExtensionField>

        <ExtensionField name="Inside Sales Rep">UNG</ExtensionField>

    </Extension>

 

When I parse the XML I can get to the attribute “name” and value “Sales Branch”, but I can’t get to ‘IT’.

Maybe I am just not interpreting the XML correctly and should use a different procedure, but I can’t think of what that could be.

 

Personally I don’t think I can get to the values using the parser, but I would love for someone to prove me wrong.

 

Any ideas are welcome!

 

Best regards,

Frank

 

Disclaimer
The
information contained in this communication from the sender is confidential.
It is intended solely for use by the recipient and others authorized to
receive it. If you are not the recipient, you are hereby notified that
any disclosure, copying, distribution or taking action in relation of the
contents of this information is strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been
automatically archived by Mimecast Ltd, an innovator in Software
as a Service (SaaS) for business. Providing a safer and more
useful place for your human generated data. Specializing in; Security,
archiving and compliance. To find out more Click
Here.

-- 
Questo messaggio e' stato analizzato con Libraesva ESG ed e' risultato
non infetto. 
Clicca
qui per segnalarlo come spam.
Clicca
qui per metterlo in blacklist
-- 
_______________________________________________
Ftpapi mailing list
Ftpapi@xxxxxxxxxxxxxxxxxxxxxx
 https://urlsand.esvalabs.com/?u=http%3A%2F%2Fscottklement.com%2Fmailman%2Flistinfo%2Fftpapi&e=713d840f&h=ce701e29&f=n&p=y




CONFIDENTIALITY NOTICE
This message and its attachments are addressed solely to the persons
above and may contain confidential information. If you have received
the message in error, be informed that any use of the content hereof
is prohibited. Please return it immediately to the sender and delete
the message.
Thank you
--
Questo messaggio è stato analizzato con Libra 
ESVA ed è risultato non infetto.
This message has been checked by Libraesva ESG 
and is believed to be clean.

-- 
_______________________________________________
Ftpapi mailing list
Ftpapi@xxxxxxxxxxxxxxxxxxxxxx
http://scottklement.com/mailman/listinfo/ftpapi