Saving json request in a excel format

[durgapandey]

I have to save some 500 request but the limitation is it cannot be done in one request(not more than 50 in one go). So I have created 10 testcases to create 500 responses. Now I want to save that response in a excel (test case wise) and lastly fetch row wise to pass it in my another request.

Please help . I am very new to soap ui.

My request body is :

[

{
"a1" : "test1",
"a2: "test2",
"a3" : "test3",
"a4" : "test4"
},

{
"a5" : "test5",
"a6: "test6",
"a7" : "test7",
"a8" : "test8"
}

]

My response is :

[
{
"resourceId": "test1",
"created": true,
"message": "Success"
},
{
"resourceId": "test5",
"created": true,
"message": "Success"
}

]

[MartinSpamer]

I'd strongly urge you to use a Database not Excel for this.

In the Community edition, if you must use Excel then you will need to use Groovy, which is covered in this question/answer:  https://community.smartbear.com/t5/SoapUI-Open-Source/How-to-save-response-data-in-Excel-CSV-format-...

Groovy provides the most flexibity approach for Excel or DB but requires that you use or learn some Groovy Programming.  Groovy is what makes SOAPUI such a powerful test tool and it is worth the effort.

If you use a DB then you do not need to learn programming and could use a JDBC step: see: https://www.soapui.org/resources/tutorials/tutorial-data-driven-testing.html

IF you have Pro, you can do this with Excel or DB and take a look at this tutorial 

https://www.soapui.org/docs/data-driven-tests/functional-tests.html

[durgapandey]

Thanks @MartinSpamer for the guidance

My request is in json and I will have to use excel only. I am using a community version. Will follow and update once done.

just an update I got a pro version. Now trying for excel

[HimanshuTayal]

Hi @durgapandey ,

For storing the request and response, you can use Text file instead of Excel which get created after each run.

and use those request and response whenever you need it later on in any request.

If you need more help do let me know.

[durgapandey]

@HimanshuTayal 

Can you please provide more insight on this. Now I am using soapui pro and want to use it as excel or text. but cannot use db/jdbc

Thanks in advance.

[HimanshuTayal]

Hi @durgapandey ,

First let me know these 500 request are all different or you are hitting same request with different 500 data.