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...
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
kbourdel's avatar
kbourdel
Occasional Contributor
10 years ago

I've manage to put the API response into an XML Datasource, and the database portion into a JDBC Datasource.

At this point, how do you compare two Datasources against each other? 

 

 

By the way, I'm using Ready API 1.5 PRO

  • nmrao's avatar
    nmrao
    Community Hero
    10 years ago
    There are could lot of tools available in the internet.
    Like XmlUnit etc. or you could also write your own as per the needs.
    You may check this one and see if it is helpful
    https://gist.github.com/karlin/789830