NehaLadani
Occasional Contributor
Joined 3 years ago
User Profile
User Widgets
Contributions
Regarding assertion with array in JSON format
Hello Everyone, I would like to know how to handle the array in JSON response for data driven testing. Here is my example Input JSON - { 'is_payment_date': False, 'repayment_schedule': 19801748, 'step_list': [ { 'end_date': datetime(2022, 1, 7, 13, 9, 2), 'start_date': datetime(2022, 3, 1), 'mask': '00011110001', 'payments': 1, 'amount': 0, 'step_type': 1011755, 'sequence': 1 }, { 'end_date': datetime(2022, 1, 7, 13, 9, 2), 'start_date': datetime(2022, 3, 1), 'mask': '00011110001', 'payments': 1, 'amount': 0, 'step_type': 1011755, 'sequence': 2 } ], 'total_payments': 79 } Output JSON - { 'step_list': [ { 'end_date': datetime(2035, 9, 1), 'payments': 12, 'sequence': 1 }, { 'end_date': datetime(2035, 9, 1), 'payments': 67, 'sequence': 2 } ] } We have 1000s of data in excel file - total of 3 worksheets - 2 sheets for input data and 1 sheet for output data I know that we have to write GroovyScript (as a test step) but how to handle the response in assertion. Please, any help will be appreciated. Thank you..Regarding rounding function
I would like to add rounding function in my assertions Example [Match content of [xyz]] Comparison failed. Path: [$['xyz']]; Expected value: [5.461*]; Actual value: [5.46076854]. Expected value: [5.461*] is in ExcelQATestfile (Excel file cannot be modified) Actual value: [5.46076854] is API output So, I am looking for a solution that will make my readyapi assertion force Actal value to rounding and I get Expected = Actual Please help me..1.1KViews0likes1CommentRe: Nested datasourceloop
Thank you SarahS, But, I know how to link datasource with readyAPI and to the rest request but the question is how to loop it for my requirement of having 2 worksheets in one excel file. 1 datasource - Same Excelfile - sheet A properties 2 datasource - Same Excelfile - sheet B properties 1 rest request Sometimes { Sheet A - id1 [ Sheet B (variable number of loops, id1- 1, 2, 3 row from sheet B) ] } Sometimes { sheet A - id2 [ Sheet B (variable number of loops, id2- 4, 5 row from sheet B) ] } Sometimes { sheet A - id3 [ Sheet B (variable number of loops, id3- 6, 7 row from sheet B) ] } Sometimes { sheet A - id4 [ Sheet B (variable number of loops, id4- 8, 9, 10 row from sheet B) ] }893Views0likes0CommentsNested datasourceloop
Hello Everyone I have a POST Request to send and it has nested loop { xyz:value abc:value [ { pqr:value qaz:value } ] } Excelfile has 2 worksheets - Sheet A and Sheet B 1. Sheet A has values of xyz, abc 2. Sheet B has values of pqr, qaz - this section loops but sometimes 1, sometimes 2 and sometimes 3 depends on sheet A 3. Both files are linked with ID for our reference Example Concept: IF Sheet A - ID1 - has 1 row Sheet B - ID1 - has 3 rows then the req sent will be Request: { xyz:value abc:value [ { pqr:value1 qaz:value1 }, { pqr:value2 qaz:value2 }, { pqr:value3 qaz:value3 } ] } Response: Has 1 output that is in the sheet A for comparision. I got to know that we have to write groovy script, but have no idea how to write. Can someone please write here in detail? Or any other way to approach. Thank you in advance.1KViews0likes4CommentsRegarding Data Driven Testing
Hello, I reaching out to you for Data Driven Tests. I have one Excel file as a Data Source with 2 worksheets in that. I need to enter both worksheet data while sending a payload. Is there any way that we can get 2 worksheets on board simultaneously?783Views0likes4Comments