Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: Read XML from WS Lookup

  1. #1

    Default Read XML from WS Lookup

    I used the example Annotated SOAP WS call and tried to make the same, but only with WS Lookup (don't want JS scripts ).

    I have this .wsdl http://ws.cdyne.com/emailverify/Emai...mail.asmx?wsdl and I'm trying the VerifyEmail Operation.

    I add an input(email and licenseKey) and an output (i click "Get Fields" and generates: )

    Name WS Name WS Type
    VerifyEmailResult VerifyEmailResult ReturnIndicator




    The output i get is a .xml just like this:
    HTML Code:
    <VerifyEmailResult xmlns="http://ws.cdyne.com/" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
                       xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
                       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
       <ResponseText>User Not Found</ResponseText>
       <ResponseCode>4</ResponseCode>
       <LastMailServer>hotmail-com.olc.protection.outlook.com</LastMailServer>
       <GoodEmail>false</GoodEmail>
    </VerifyEmailResult>
    How can i parse this .xml? I tried "get data from xml" step and i always get an error in the loop xpath.
    I want the values from ResponseText, ResponseCode and GoodEmail.

    Thank you.

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    When you press button "Get XPath nodes" on the Content tab of Get-Data-From-XML, Kettle suggest /*[name()='VerifyEmailResult'] as your Loop XPath.
    So long, and thanks for all the fish.

  3. #3

    Default

    To me that button tells me to provide a XML fragment. If i put /*[name()='VerifyEmailResult'], it gives a prolog error.

  4. #4
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    I just posted the whole document you gave in your opening post.
    Attached Files Attached Files

  5. #5

    Default

    It worked. What did the calculator do? Generated XML from the WS lookup response?

    Also, to me, it was necessary to write myself the loop xpath and its fields. Shouldn't it be only with the buttons?

    Anyway, thank you my good sir

  6. #6
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    My use of the Calculator step is only to retrieve the XML document from the note element.

    Of course, you can specify XPath expressions without the help of the buttons.
    They are just a convenience feature.

  7. #7

    Default

    Hi.

    I tried your example without the calculator and it works perfectly too.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.