Patent Document ID: 9921945
Application ID: 14679281

Base Claim:
1. A computer-implemented method for automatic verification of JavaScript Object Notation (JSON) data, the method comprising executing on a processor the steps of: making a JSON call via an Extensible Markup Language (XML) Hypertext Transfer Protocol (HTTP) HTTP object against a data warehouse data item stored in a back end server; converting JSON response data returned from the back end server in response to the JSON call into actual XML result data comprising a first plurality of XML statements; executing a Structured Query Language (SQL) query against the data warehouse data item; in response to the executed SQL query, generating expected XML result data comprising a second plurality of XML statements; comparing data values and total numbers of the actual XML result data first plurality of XML statements to data values and total numbers of the expected XML result data second plurality of XML statements; and verifying the JSON response data returned from the back end server in response to matching a total number of the first plurality of XML statements of the actual XML result data to a total number of the second plurality of XML statements of the expected XML result data, and to matching data values of individual ones of the first plurality of XML data statements to data values of corresponding individual ones of the second plurality of XML statements; and wherein the verifying comprises: presenting results of the comparing by denoting iteration information, data location information, and a verification marker that is selected from the group consisting of: an agreement indicator that indicates that the total number of the first plurality of XML statements matches the total number of the second plurality of XML statements and that the data value of an individual one of the first plurality of XML data statements matches a data value of a corresponding one of the second plurality of XML statements; and a mismatch indicator that indicates a discrepancy between the data value of the individual one of the first plurality of XML data statements and the data value of the corresponding one of the second plurality of XML statements and that is indicative of either a data error in the back end or a process error in a front end interface between a user and the back end.

---

Claim 8:
8. The method of claim 1 , further comprising: integrating computer-readable program code into a computer system comprising a processor, a computer readable memory in circuit communication with the processor, and a computer readable storage medium in circuit communication with the processor; and wherein the processor executes program code instructions stored on the computer-readable storage medium via the computer readable memory and thereby performs the steps of making the JSON call against the data warehouse data item stored in the back end server, converting the JSON response data returned from the back end server into the actual XML result data, executing the SQL query against the data warehouse data item, generating the expected XML result data in response to the executed SQL query, comparing the data values and the total numbers of the actual XML result data first plurality of XML statements to data values and total numbers of the expected XML result data second plurality of XML statements, and verifying the JSON response data returned from the back end server in response to matching the total number of the first plurality of XML statements of the actual XML result data to the total number of the second plurality of XML statements of the expected XML result data, and to matching the data values of the individual ones of the first plurality of XML data statements to the data values of the corresponding individual ones of the second plurality of XML statements, by presenting results of the comparing by denoting iteration information, data location information, and the verification marker that is selected from the group consisting of the agreement indicator and the mismatch indicator.