cancel
Showing results for 
Search instead for 
Did you mean: 

Saving json request in a excel format

Highlighted
New Contributor

Saving json request in a excel format

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"
}

]

 

5 REPLIES 5
Highlighted
Frequent Contributor

Re: Saving json request in a excel format

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

 

 

Highlighted
New Contributor

Re: Saving json request in a excel format

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
Highlighted
Community Leader

Re: Saving json request in a excel format

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.


Click "Accept as Solution" if my answer has helped,
Remember to give "Kudos" 🙂 ↓↓↓↓↓



Thanks and Regards,
Himanshu Tayal
Highlighted
New Contributor

Re: Saving json request in a excel format

@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.

Highlighted
Community Leader

Re: Saving json request in a excel format

Hi @durgapandey ,

 

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

 


Click "Accept as Solution" if my answer has helped,
Remember to give "Kudos" 🙂 ↓↓↓↓↓



Thanks and Regards,
Himanshu Tayal
New Here?
Join us and watch the welcome video:
Top Kudoed Authors