Forum Discussion

rralison's avatar
rralison
Occasional Contributor
15 years ago

Insert additional node

Hello,

I am newbie to soapui pro, however I have already made run some simple test from a Datasoursce.

Now my actual problem is more complex : I have two Table (one to many relationship) who feed soap xml request :

Table_A
id | data
-----------
1  | Adata1
2  | Adata2


Table_B
id | A_id | data
-------------------
1  | 1    | Adata1
2  | 1    | Adata1
3  | 1    | Adata1

My remote service need two parameters :
- A
- B[] array

For the first parameter, it seems simple to implement with Datasource.
But but the second one I don't have any solution : how to construct dynamicaly new XML node and insert it in the request? Please answer me if you have any solution.

Thanks

19 Replies

Sort By
  • rralison's avatar
    rralison
    Occasional Contributor
    15 years ago
    humm very interesting. I think it's the start of the answer, but in my point of view the solution is more complex (in my point of view).

    In fact I think I need two DataSource, one to iterate over Table_A, this one should PASS his id to the second Datasource who search for all corresponding id in Table_B.
    After that I have to setup a Groovy scipt looking like as you shown with the second Datasource.
    Finally I have to INSERT the Groovy result  AND a Table_A.data record in the Test Request.

    Thanks for all help.
  • rralison's avatar
    rralison
    Occasional Contributor
    15 years ago
    The problem is not yet completly solved.
    Still waiting for additional helps.
  • M_McDonald's avatar
    M_McDonald
    Super Contributor
    15 years ago
    Assuming these are JDBC data sources, just sounds like you need an inner and outer datasource with the request following the inner loop, something like this?

    [tt:9uwkpwbn]Datasource A
    :
    :
    DataSource B (parameterized with ID from DataSource A)
    Groovy Script
    DataSource Loop B
    Properties (to receive result of Groovy script)
    :
    :
    Request (with ${DataSource A#id} and ${Properties#XmlFragment} in the body)
    :
    DataSource Loop A[/tt:9uwkpwbn]
  • rralison's avatar
    rralison
    Occasional Contributor
    15 years ago
    M McDonald ,

    You describe exactly the solution.
    Yes, I think it will work.

    I'll try to create a parametrized Datasource but helps always welcome.

    Thanks.
  • rralison's avatar
    rralison
    Occasional Contributor
    15 years ago
    In DataSource JDBC, what to put in column "Value" (near "PreparedProperties") in order to catch a value found by another Datasource?

    Something like ${DataSourceA#Table_A.id} give a message like "Missing property values in DataSource Row".
  • M_McDonald's avatar
    M_McDonald
    Super Contributor
    15 years ago
    Have you actually retrieved rows in the first datasource? That looks like correct syntax.

    If you put a Groovy step after the first datasource and log the value 

    log.info context.expand('${DataSourceA#Table_A.id}')


    do you get the value you are expecting?
  • rralison's avatar
    rralison
    Occasional Contributor
    15 years ago
    Nothing in the Groovy log.
    See image attached.
  • M_McDonald's avatar
    M_McDonald
    Super Contributor
    15 years ago
    Try letting the script run, looping over the data and see what you get in the Script tab. You don't have a value for your selected property in the first row of the outer DataSource.
  • rralison's avatar
    rralison
    Occasional Contributor
    15 years ago
    I understand what you mean.
    Here is the screenshot : obviously the First datasource works correctly because the groovy script can print thr values in Script Log.

    However I don't understand what's wrong in second data source : why it can catch the value?