Forum Discussion

newsoapuiuser1's avatar
newsoapuiuser1
New Contributor
13 years ago

Saving a varying list of response to an excel file

Hi all,

I am new to SoapUI and was stuck at this problem and I need your help.

In the request I can specify the # of items i want in the response, and the response spits back the # application numbers based on the # i specify in the request. This # can vary for every loop. I want to be able to save these numbers (array) into an excel file using a Data Sink. I tried some of the examples from different groups here, but I have only been able to get the first number in the array. The dream would be to save all the application numbers into an excel and then further validate this by comparing values in a database.

Any ideas?

7 Replies

  • Thanks for the link. Although the tutorial was extremely useful to get off the ground with SOAPUI Pro, I am still stuck at the problem. I want to capture all the FL numbers generated in the response as opposed to the first one .

    Each request might bring back 1-50 numbers. So, I would like to capture those numbers and put them in an excel file/text file using Data Sink. I was able to capture the entire response and save it to a DataSink, however I would only like to capture the whole array of application numbers in a file.

    I have attached a screenshot of a sample of what I am trying to achieve.

    Thanks
    Anand.
  • I resolve the same issue using a DataSource with Groovy script.
    The result is used by the DataSink.
    Chris
  • Rao, Can you attached complete project? I am also looking for example how to transfer (repetetive) response field to excel.
  • nmrao's avatar
    nmrao
    Community Hero
    Unfortunately, do not have any project using such examples. Hope some one could help you.
    By the way, what are you trying to do and issue you are facing will help to assist you.