How to transfer an array to a database.

Create a DataSource step with the result as the XML datasource, a corresponding DataSource Loop step and a DataSink step in between.

Thank you but how to set-up the datasource based on XML response, in order that the datasource loop can then loop on the different element?
I currently set-up the RowXpatk like :

declare namespace ns1='http://www.xxxxx.com/webservices/';
//ns1:GetValuationResponse[1]/ns1:Valuation[1]/ns1:EquipmentList[1]

and the column xpath with ns1:Equipment[1]/ns1:Code[1]

But then the loop is limited to 1 row. How to specify to soapui to parse all the array of equipment ?

Hello,

Try removing '[1]' and check http://www.soapui.org/Data-Driven-Testi ... urces.html

Let me know does this helps,
robert

Thanks a lot, that's work pretty fine

The row Xpath is :

declare namespace ns1='http://www.eurotax.com/webservices/';
//ns1:GetValuationResponse/ns1:Valuation/ns1:EquipmentList/ns1:Equipment

The columns Xpath are :

ns1:NewPrice
ns1:Valuation/ns1:TradeAmount
ns1:Valuation/ns1:RetailAmount
ns1:Valuation/ns1:B2Bamount

If now [once stored in the database] I would like to reuse part of those information for a subesquent query, what should I set-up?

Hello,

Use set a DB as datasource, or use jdbc test step to read data and than fill request with those data using property transfer.
Check this: http://www.soapui.org/Data-Driven-Testi ... tests.html

robert

Thats more less what I did (I think). But then a only get the last data base record inserted into the service query.

How could I specify to soapui that a new equipment item has to be inserted into the request for each new databae record?

Hello,

Basically you have

Datasource/jdbc - reads a record from a DB and store data in some property(ies).
test request - here use property expansion to get values stored in properties in previous step.
datasource loop. - goto DS/jdbc

hm..this should be clearly explained in link I gave you.

does this helps,
robert

I think you mean you want to add all the appropriate records from the DB into one request? Then I think you need to use a script within the DataSource/DataSource Loop to append each value to a property, then reference the resulting property in the request.

I think I have a feature request in for a DataSource aggregator

Robert,
In fact my seconf query contains as well repetition (bumber of array is variable) of the equipments. like below :

            <web:EquipmentList>
               <web:Equipment>
                  <web:Code>164059</web:Code>
                  <web:NewPrice>0</web:NewPrice>
               </web:Equipment>
               <web:Equipment>
                  <web:Code>1688</web:Code>
                  <web:NewPrice>600</web:NewPrice>
               </web:Equipment>
               <web:Equipment>
                  <web:Code>164074</web:Code>
                  <web:NewPrice>0</web:NewPrice>
               </web:Equipment>
            </web:EquipmentList>

There for I need to loop to collect all equimpent code and associated proce from the database and for each database row I need to add new equipment node to my query.
Currently I did the following
1) datasource to accres database.
2) property transfert wit 2 properties defined.
code : source = databasesource [step 1]; property eqpt_code.
Target = the query [set4]; property = Request and

declare namespace web='http://www.xxxxx/webservices/';
                 //web:GetValuation/web:Valuation/web:EquipmentList/web:Equipment/web:Code 

price : source = databasesource [step 1]; property eqpt_price.
Target = the query [set4]; property = Request and

declare namespace web='http://www.xxxxxx.com/webservices/';
                 //web:GetValuation/web:Valuation/web:EquipmentList/web:Equipment/web:NewPrice 

3) loop to 1
4) send the request

When a run the test case, the system loops over the 14 elements found into the database, but only the last equipment code et price are present within the request sent at step4 (see below) whereas I expected 14 node into the equipment list.

Hoping that clarifies.

            <web:Mileage>30000</web:Mileage>
            <web:CalculationMode>STANDARD</web:CalculationMode>
            <web:EquipmentList>
               <web:Equipment>
                  <web:Code>165804</web:Code>
                  <web:NewPrice>880</web:NewPrice>
               </web:Equipment>
            </web:EquipmentList>

M McDonald wrote:
I think you mean you want to add all the appropriate records from the DB into one request? Then I think you need to use a script within the DataSource/DataSource Loop to append each value to a property, then reference the resulting property in the request. I think I have a feature request in for a DataSource aggregator

That's exactly what I'm looking for. But absolutly no clue what to perform the script. And how to use the result script in the subsequent request.