Forum Discussion

jkrier's avatar
jkrier
Regular Contributor
7 years ago
Solved

DataSource-XML not returning data

I have an XML response that loos like this   <soap:Envelope> <soap:Body> <getDocumentNamesResponse> <documentName>AAABRIDGE</documentName> <documentName>WSCLIENT</documen...
  • groovyguy's avatar
    groovyguy
    7 years ago

    Well I managed to get it to work with that note.

     

    Row XPATH should be (including whatever namespaces you have, so ns1?)

     

    //ns1:getDocumentNamesResponse[1]/ns1:documentName

     

     

    Column XPATH:

    text()

     


    Can you try that?

    (Edit for missing / on row xpath)

     

  • jkrier's avatar
    jkrier
    7 years ago

    You really got my hopes up.

     

    Made the Row Xpath

    declare namespace ns1='mynamespace';

    /ns1:getDocumentNamesResponse[1]/ns1:documentName

     

    Column XPath

    text()

     

    But I get 0 results

     

    So then I tried

    declare namespace ns1='mynamespace';

    //ns1:getDocumentNamesResponse[1]/ns1:documentName

     

    So the difference is the slashes, "//" versus "/" and guess what? IT WORKS!!!!!!

     

    AAABRIDGE
    ADDMONTHLY
    ADDRESS_VALIDATION
    ATLAS_SALESFORCE_AUTHSERVICE
    AUTHENTICATION_SERVICE
    AUTHORIZATION
    BATCH_PROCESSING_SERVICE
    BILLING
    BULK_RMA
    BULK_RMA_GUI

     

    I really can't thank you enough for all the time you spent helping me. This will greatly enhance my tests and something I've been wanting to do for a long time but it just never worked for me so I would work around it.

jkrier's avatar
jkrier
Regular Contributor
7 years ago
  • sanj's avatar
    sanj
    Super Contributor
    7 years ago

    What are you trying to do?

    this sounds like something that can be easily resolved with groovy scripting instead of datasource

    • jkrier's avatar
      jkrier
      Regular Contributor
      7 years ago

      I am trying to use built in functionality with SoapUI Pro. Yes, I know I could do this with some scripting but I have paid for a pro license so I expect that these features should work.

       

      I am trying to use an XML response as my DataSource to use in conjunction with a DataSource Loop. This is basic functionality with the pro version (I've just never had a need before).

       

      So yeah, could I fix it with scripting, yes, I could.

       

      Do I want to do that, no, I do not.

      • groovyguy's avatar
        groovyguy
        Champion Level 1
        7 years ago

        I ran into the same problem and it took me a bit to figure out. Whatever name space you have in the row xpath defined has to be used in the column xpath as well.

         

        IE, if your row xpath is: 

        Row Xpath = //ns1:getDocumentNamesResponse[1]/ns1:documentName[1]

         

        You actually want to change it to:

        //ns1:getDocumentNamesResponse[1]

         

        And try setting your column xpath to:

        ns1:documentName/text()

Recent Discussions