Contributions
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 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 }588Views0likes1CommentWrite result(Pass or Fail) in Excel of REST API POST method by groovy Script(SOAP Ui 5.6.0)
Hello Everyone, I am using following steps and see the screeshots please, i want to store the result that is if response is pass the i want to store pass status in excel sheet. 1. SOAP UI 5.6.0 Open Source 2. Use excel sheet(.xls) to get the input for REST API POST method 3. Now need to write the Pass and Fail status in the excel sheet. See screenshot please.664Views0likes2Comments