Thanks Srikanth.
I have done the same for reading the JSON Content. Then applied JSON Filter to store the values in a property to compare with my DB Columns.
One more query, if possible please give suggestions on it.
I am having the Excel File with each row is JSON Content. In DB Step I am executing my Query and it prints some 10 rows. Now, I want to compare the 1st JSON with my 1st DB Row. I applied filter for storing the property from JSON Content and also for DB Content. With help of Assertion "Ensure properties are equal" I am validating it.
I done parameterization for JSON (it iterates correctly). But in DB Section, it prints all the 10 row and does comparison with all the 10 row, for each iteration of JSON content.
Ex :
for 1st iteration
JSON : SSN Number (1st row JSON Content)
DB : SSN Number(1st row) - Stores in property - Assertion evaluated
DB : SSN Number(2nd row) - Stores in property - Assertion fails
...... till my 10th row
for 2nd iteration
JSON : SSN Number(2nd row JSON Content)
DB : SSN Number(1st row) - Stores in property - Assertion fails
DB : SSN Number(2nd row) - Stores in property - Assertion evaluated
DB : SSN Number(3rd row) - Stores in property - Assertion fails
...... till my 10th row
for 10th iteration
JSON : SSN Number(10th row JSON Content)
DB : SSN Number(1st row) - Stores in property - Assertion fails
DB : SSN Number(2nd row) - Stores in property - Assertion fails
...... till my 10th row
DB : SSN Number(10th row) - Stores in property - Assertion evaluated
Do we have any one-on-one comparison. 1st iteration goes as 1st JSON SSN with 1st DB SSN. 2nd iteration goes 2nd JSON SSN with 2nd DB SSN..
Thanks much...
Preethi R