How to get and compare API data with the existing data? Thanks

I can only get first row of API data. Please advise on the following…

There is 100 of rows and 10 columns data.How can get all the data one by one in loop and compare with the other data in the database? Thanks

Vikas,

I have a small example for looping data set. Hope that it help.

TestData accounts = findTestData('valid_accounts')
println accounts.getSourceUrl()
int rows = accounts.getRowNumbers()
for (def i : (1..rows)) {
    def user = accounts.getObjectValue('Username', i)
if (user == username) {
// do login
// do more test steps
}
}