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