Forum Discussion

kbourdel's avatar
kbourdel
Occasional Contributor
10 years ago

What is best practice when trying to compare a large json response to what is in the db

Looking for some advice to see if there is a more efficent way to do this - comparing json object in the response to the db.   I have a restful api which returns a large response (6000 objects). I...
kbourdel's avatar
kbourdel
Occasional Contributor
10 years ago

Correct, I want to compare the JDBC result (6000 rows) with the Rest method.

For clarification, JDBC steps is getting a list of values from a type table, and the Rest method should be returning the same set of values. 

What would be the most efficent way of doing this?

nmrao's avatar
nmrao
Community Hero
10 years ago
Basically you need to bring the data in manner so that it can be easy to compare both.
1. either by transforming data to common xml for jdbc and rest response
2. use of class / model and create object list