Forum Discussion

GKuiper's avatar
GKuiper
Occasional Contributor
12 years ago

Recording multiple results

Hi,

New to soap UI here.

I have a question. I have a datasource and datasink. I write the results to an excel sheel.

Now it works perfectly fine if there is 1 XML line returning. I just to 'transfer to... Property'. However if i have multiple results (sometimes 0 sometimes 10) i only get the firstresult.

Example:

ItemNumber: returns a number. I want to capture that in excel so i add the ItemNumer to the datasink. Works fine.

However this doesn'w work:

ItemProperties:
e: Property 1
e: Property 2
e: Property 3

I tried to just use 'ItemProperties' but no result is posted to my excel sheet. If instead i use e: I only get Property one.

Does anyone know how i get get all the properties returned? Thanks

12 Replies

  • GKuiper's avatar
    GKuiper
    Occasional Contributor
    12 years ago
    Hi

    I followed the tutorial http://blog.smartbear.com/api-testing/h ... in-soapui/ step by step as that's exactly what i need. However i don't get it to work. I dont know what i am doing wrong.

    I need to get the diagnostics. There may be 0 there may be 10 but 3 in this example. However i only seem to be able to get 1.

    I've tried ns1:e[2]that gives me the second so i am looking at the correct node. I tried ns1:e gives me nothing. Ive tried ns1:e() gives me nothing. I've tried e/text() gives me nothing.

    I'm worried th XML file may not be formatted cleanly enough. Later on i want to get more nodes. The XML is given like this:

    <Main node>
      <subnote1>
        <e>
           <subnote 1a>
               <e>
                   <Name>
                   <age>
      <subnote2>
        <e>
           <subnote 2a>
               <e>
                   <id>
                        <e>
                        <e>
                        <e>
      <subnote3>
  • GKuiper's avatar
    GKuiper
    Occasional Contributor
    12 years ago
    Problem partially fixed.

    In the datasource i now get multiple results. This is correct. I use:

    row:

    declare namespace ns1='http://94.209.214.187/api/conversation/1352f967-2033-467c-b887-7c1227384f39/evaluate';
    //ns1:Response[1]/ns1:itemEvaluations[1]/ns1:e[1]/ns1:diagnostics/ns1:e

    column:

    tekst()

    So now want to save this data to Excel. However only 1 record is saved. I need all 3

    I have source: My request
    Property: ResponseAsXML
    Target: DataSink
    Property: The property as defined below.

    I fill in the same for source as in row. However if i fill in tekst() for target i get a CDATA error.

    Anyone help please?
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    12 years ago
    You will have to add properties for each row you want to add, in this case just add 2 more properties in the Datasource. Let me know if this helps.

    Regards,
    Temil
  • GKuiper's avatar
    GKuiper
    Occasional Contributor
    12 years ago
    Eh, no thats not it at all... Please read the whole post. I can get 0 result, 3 or 10. In the datasource i get all the results. now i just need to write this to excel.

    Like this:

    <Main node>
    <sub node 1>data</sub node 1>
    <sub node 2>data</sub node 2>
    <sub node 3>data</sub node 3>
    etc
    </main node>

    These sub-notes need to be written to xml. Depending on the data i get 0 or more subnodes
  • GKuiper's avatar
    GKuiper
    Occasional Contributor
    12 years ago
    I already *have* a ticket. But no response other then 'set sourceproperty to 'responseasxml' but as seen in the attached screenshot i already had that.
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    12 years ago
    I apologize for the inconvenience, I cannot find a case for this XML DataSource issue under your name. Can you please give me the case number or open a case and provide the number, I will personally take care of it.

    Regards,
    Temil