Sorting data in JSON response for comparison

Hello Shehnaz 

Below are two code examples of groovy scripts that can compare JSON... 

One:  It just sorts whatever the comparison strings are (regardless of JSON or not). Since your example is basically the same except for being out of order, you could use this example with your JSON.  It will sort each content (actual and expected) and compare them and show the difference or equality in the log output.

Two: Use the JSONAssert library (Obtain "jsonassert-1.5.0.jar" from http://jsonassert.skyscreamer.org/). You will need to put the .jar file in you installation .lib folder and then restart SoapUI/ReadyAPI.  Provide the library method with your actual and expected and it will respond with differences or equality.  The LENIENT parameter is used in this case since the order is different, but textual differences will be identified.  If you use STRICT, it will not allow a different order.

In either of these examples change a value and see what kind of response is returned when the comparison strings contain a different element value.

Maybe one of these examples will meet your need.

Regards,

Todd

Example One:  Groovy Script Sort And Compare Strings

log.info 'Test Step "' + testRunner.runContext.currentStep.name + '" start...';
log.info "";

def refStr = """
{
  "Drivers": [
    {
      "ContactId": 797952,
      "LicenseNumber": "123WT45TY1234",
      "LicenseState": "DE",
      "DriverNumber": 2,
      "DriverStatus": "Active",
      "DriverTerminationDate": null,
      "DriverUsed": true,
      "PolicyDateTimeDriverAdd": "2021-01-06T14:27:34",
      "PolicyDateTimeMax": "2021-01-06T14:27:34"
    },
    {
      "ContactId": 797949,
      "LicenseNumber": "N677DG8906VB7",
      "LicenseState": "DE",
      "DriverNumber": 1,
      "DriverStatus": "Active",
      "DriverTerminationDate": null,
      "DriverUsed": true,
      "PolicyDateTimeDriverAdd": "2021-01-06T14:27:34",
      "PolicyDateTimeMax": "2021-01-06T14:27:34"
    }
  ]
}
""";
refStr = refStr.replaceAll('}', '');   // without this, there is a close brace whose result is only differentiated by its existance
def refStrList = refStr.split();
def refStrListSorted = refStrList.sort();

log.info "refStrList.size()=" + refStrList.size();
refStrList.each { element ->
   log.info "element=" + element;
};
log.info "";
log.info "";
refStrListSorted.each { element ->
   log.info "element=" + element;
};


log.info "";
log.info "==================================================";
log.info "";

def compStr = """
{
  "Drivers": [
    {
      "ContactId": 797949,
      "LicenseNumber": "N677DG8906VB7",
      "LicenseState": "DE",
      "DriverNumber": 1,
      "DriverStatus": "Active",
      "DriverTerminationDate": null,
      "DriverUsed": true,
      "PolicyDateTimeDriverAdd": "2021-01-06T14:27:34",
      "PolicyDateTimeMax": "2021-01-06T14:27:34"
    },
    {
      "ContactId": 797952,
      "LicenseNumber": "123WT45TY1234",
      "LicenseState": "DE",
      "DriverNumber": 2,
      "DriverStatus": "Active",
      "DriverTerminationDate": null,
      "DriverUsed": true,
      "PolicyDateTimeDriverAdd": "2021-01-06T14:27:34",
      "PolicyDateTimeMax": "2021-01-06T14:27:34"
    }
  ]
}
""";
compStr = compStr.replaceAll('}', '');  // without this, there is a close brace whose result is only differentiated by its existance
def compStrList = compStr.split();
def compStrListSorted = compStrList.sort();

log.info "compStrList.size()=" + compStrList.size();
compStrList.each { element ->
   log.info "element=" + element;
};
log.info "";
log.info "";
compStrListSorted.each { element ->
   log.info "element=" + element;
};


log.info "";
log.info "==================================================";
log.info "";

// sanity check...
log.info "refStrList.size()=" + refStrList.size();
log.info "compStrList.size()=" + compStrList.size();
assert refStrList.size().equals(compStrList.size()), "Mismatch - There are ${refStrList.size()} reference values and ${compStrList.size()} compare values";

// sorted line by sorted line check...
refStrListSorted.eachWithIndex { refValue, idx ->
   def compValue = compStrListSorted[idx];
   if ( refValue != compValue ) {
      log.info "refValue=" + refValue + "  " + idx;
      log.info "compValue=" + compValue + "  " + idx;
      assert refValue.equals(compValue), "Mismatch - At index $idx the referece value '$refValue' does not match the comparison value '$compValue'";
   };
};

// If we get here, then the contents are equal
log.info "";
log.info "   ***  Reference and Compare strings are equal  ***";

log.info "";
log.info 'Test Step "' + testRunner.runContext.currentStep.name + '" done...';

Example Two: Groovy Script JSON Assert Lenient

import org.skyscreamer.jsonassert.*;      // Obtain jsonassert-1.5.0.jar from http://jsonassert.skyscreamer.org/

log.info 'Test Step "' + testRunner.runContext.currentStep.name + '" start...';
log.info "";

def String refStr = """
{
  "Drivers": [
    {
      "ContactId": 797952,
      "LicenseNumber": "123WT45TY1234",
      "LicenseState": "DE",
      "DriverNumber": 2,
      "DriverStatus": "Active",
      "DriverTerminationDate": null,
      "DriverUsed": true,
      "PolicyDateTimeDriverAdd": "2021-01-06T14:27:34",
      "PolicyDateTimeMax": "2021-01-06T14:27:34"
    },
    {
      "ContactId": 797949,
      "LicenseNumber": "N677DG8906VB7",
      "LicenseState": "DE",
      "DriverNumber": 1,
      "DriverStatus": "Active",
      "DriverTerminationDate": null,
      "DriverUsed": true,
      "PolicyDateTimeDriverAdd": "2021-01-06T14:27:34",
      "PolicyDateTimeMax": "2021-01-06T14:27:34"
    }
  ]
}
""";

//  ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

def String compStr = """
{
  "Drivers": [
    {
      "ContactId": 797949,
      "LicenseNumber": "N677DG8906VB7",
      "LicenseState": "DE",
      "DriverNumber": 1,
      "DriverStatus": "Active",
      "DriverTerminationDate": null,
      "DriverUsed": true,
      "PolicyDateTimeDriverAdd": "2021-01-06T14:27:34",
      "PolicyDateTimeMax": "2021-01-06T14:27:34"
    },
    {
      "ContactId": 797952,
      "LicenseNumber": "123WT45TY1234",
      "LicenseState": "DE",
      "DriverNumber": 2,
      "DriverStatus": "Active",
      "DriverTerminationDate": null,
      "DriverUsed": true,
      "PolicyDateTimeDriverAdd": "2021-01-06T14:27:34",
      "PolicyDateTimeMax": "2021-01-06T14:27:34"
    }
  ]
}
""";

log.info "";
log.info "==================================================";
log.info "";

def actual = refStr;
def expected = compStr;

//JSONAssert.assertEquals(actual, expected, JSONCompareMode.STRICT);
JSONAssert.assertEquals(actual, expected, JSONCompareMode.LENIENT);

log.info "";
log.info 'Test Step "' + testRunner.runContext.currentStep.name + '" done...';