[RESOLVED] extract data from nodes depending on the condition

if you guys want whole response i can email you

Hello,

Hm...You should use groovy test step to extract all values you need ( id, spotId ) and put them all in property at test case level, check this: http://www.soapui.org/userguide/functional/groovystep.html. Than you should use property transfer step(http://www.soapui.org/userguide/functional/propertytransfers.html) or groovy step to go trough extracted values and set parameters for request.

Hope this helps, let me know
robert

got this working....

spotID = holder.getDomNodes("//aetgt:GetSpotListsResult/aetgt:spotlists/aetgt:Spotlist/aetgt:Spots/aetgt:Spot[aetgt:Variety='commentary']/aetgt:SpotID")
spotListID = holder.getDomNodes("//aetgt:GetSpotListsResult/aetgt:spotlists/aetgt:Spotlist/aetgt:Spots/aetgt:Spot[aetgt:Variety='commentary']/../../aetgt:ID")

once we get nodes based on the condition we need to getvalue using getNodeValue.

I got the spotID and ID using the above steps.
I have spotID = [1,1]
SpotListID = [4,5]

How do i pass these to datasource from the groovy script result? I want to loop on SpotListID.

Hi Usha,

if you want you create a DataSource/DataSourceLoop construct from values in a message response, try the XML DataSource which allows you to do just that using xpath expressions for row / property selection.

Does that help?

regards!

/Ole
eviware.com

Hi Ole,
I am getting values using XML Datasource.
But the result looks likes this.

ID                  SpotID
4
5
                          1
                          1

But my expected result should be

ID              SpotID
4                  1
5                  1

How to achieve the above result?

my rowpath expression is

declare namespace aetgt='http://musicchoice.com/services/games';
//aetgt:GetSpotListsResult/aetgt:spotlists/aetgt:Spotlist/aetgt:Spots/aetgt:Spot[aetgt:Variety='commentary']/../..,
//aetgt:GetSpotListsResponse/aetgt:GetSpotListsResult[1]/aetgt:spotlists/aetgt:Spotlist/aetgt:Spots/aetgt:Spot[aetgt:Variety='commentary']

column path expression is

aetgt: ID/text()
aetgt: SpotID/text()

Hi!

hmm.. can you attach the corresponding response message?

regards,

/Ole
eviware.com

attached the complete response

Try doing something like this:

rowpath:
declare namespace aetgt='http://musicchoice.com/services/games';
//aetgt:GetSpotListsResult/aetgt:spotlists/aetgt:Spotlist/aetgt:Spots/aetgt:Spot[aetgt:Variety='commentary']/../..

columnpath:
aetgt: ID/text()
aetgt:Spots/aetgt:Spot/aetgt: SpotID/text()

Hi,
i tried it dint work....i am getting ID value but not SpotID value.

what should I give property name for SpotID?