cancel
Showing results for 
Search instead for 
Did you mean: 

How to print a value from a REST response(Json) into excel sheet that already used in parameteriza

Highlighted
New Contributor

How to print a value from a REST response(Json) into excel sheet that already used in parameteriza

 

Here parameterization is done through excel sheet, now need to write pass or fail for each Test Step in excel sheet 

 

Post_API.pngLecture44_Excel.pngLecture44.png

 

JSON REQUEST

{
"UserId": ${#TestCase#User_Id},
"AgencyId": ${#TestCase#Agency_Id}

}

 

***************************************************RESPONSE********************************

{
"data": {"agencyList": [ {
"agency": {
"userId": 0,
"agencyId": 1022,
"managerId": 0,
"manager": null,
"supervisorId": 0,
"supervisor": null,
"isActive": true,
"agentName": null,
"agencyName": "White Hill",
"contactPerson": "James",
"phoneCell": "",
"phoneHome": "",
"phoneOffice": "5555551257",
"fax": "3235551234",
"email": "General@finance.com",
"npn": "1234ABCDEF/XYZ",
"npnExpirationDate": "2020-10-20T00:00:00.33",
"addressLine1": "125 BAYLIS RD",
"addressLine2": "",
"city": "MELVILLE",
"state": "NY",
"zip": "11747",
"createdBy": 11,
"createdOn": "2020-10-12T00:56:48.033",
"modifiedBy": 11,
"modifiedOn": "2020-10-12T00:59:09.047"
},
"branches": [],
"agencyPrograms": [
{
"agencyId": 1022,
"programId": 230,
"programName": null,
"checked": false,
"isActive": null
},
{
"agencyId": 1022,
"programId": 437,
"programName": null,
"checked": false,
"isActive": null
},
{
"agencyId": 1022,
"programId": 438,
"programName": null,
"checked": false,
"isActive": null
},
{
"agencyId": 1022,
"programId": 439,
"programName": null,
"checked": false,
"isActive": null
},
{
"agencyId": 1022,
"programId": 456,
"programName": null,
"checked": false,
"isActive": null
},
{
"agencyId": 1022,
"programId": 518,
"programName": null,
"checked": false,
"isActive": null
},
{
"agencyId": 1022,
"programId": 537,
"programName": null,
"checked": false,
"isActive": null
},

..

"agencyId": 1022,
"programId": 723,
"programName": "Workers Comp - Limited to NY & Software Cos5",
"checked": false,
"isActive": null
}
]
}]},
"success": true,
"message": null
}

 

 

1 REPLY 1
Highlighted
Community Leader

Re: How to print a value from a REST response(Json) into excel sheet that already used in parameter

@Neha_bhardwaj : After the Test Request step you need to add 1 groovy step and in that step you need to get the status of Test Request step and write into Excel sheet by using jxl library.

 

 


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