IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  XQL query XML problem

    Posted Thu April 02, 2020 04:18 AM

    Hi,
    I would like to ask if there is any way to force IS to retrieve node value name as well as the value itself?

    We are performin such XQL query: //E1EDKA2[PARVW = ‘AG’]/ILNNR to get value of field ILNNR.

    The result can be seen on the picture. We get document with one element “*object” and value exact to the one from below XML.

    How can we get document with element name “ILNNR” instead of “*object”???

    Is there any way to get the same results as we can get here: https://www.freeformatter.com/xpath-tester.html#ad-output ??

    Our XML looks like this:

    023 8.786 KGM AG 5907808850019 ![qxl.jpg|1592x914](upload://3wf3pkVztML96h6fHkDGtDG52xe.jpeg)
    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services


  • 2.  RE: XQL query XML problem

    Posted Tue April 28, 2020 11:43 PM

    I am not sure you can do it with XQL but you can use Java and XPath to get both attribute and the attribute value.

    Cheers,
    Akshith


    #Flow-and-Java-services
    #webMethods
    #Integration-Server-and-ESB


  • 3.  RE: XQL query XML problem

    Posted Wed April 29, 2020 08:20 AM

    Hi,

    please check the IS Built-In-Services Reference for the pub.xml-Folder.

    There is a service for XQL-Query using XPath-Expressions for retrieving values from Documents.
    There should be a field indicating the output format of the retrieved value.
    Just map the output to a variable with the correct name.

    Regards,
    Hiolger


    #Flow-and-Java-services
    #Integration-Server-and-ESB
    #webMethods