Comparing two JSON files is fairly straightforward, though there are a few areas where it is not quite as simple as it seems. The three literal names, true, false and null are not a problem, though note they must be lower case. Before comparing two numbers, they should be normalised so that 1 and 1.0 would not show a change. Similarly 100 and 1e2 would also be deemed to be equal. For example:
JSON A
{
"a": 1,
"b": 100.0
}JSON B
{
"a": 1.0,
"b": 1e2
}Strings may also need some normalisation to handle special character encodings so that for example.
JSON A
{
"a": "Here are some apostrophes
( ' and ' and \u0027 )"
}JSON B
{
"a": "Here are some apostrophes
( \u0027 and \u0027 and ')"
}Objects also compare well in that each member property is identified by a string which should be unique within the object (it does not have to be unique but behaviour is unpredictable if they are not unique!). Therefore corresponding members can be identified without ambiguity even if the order of the members is different.
JSON A
{
"firstname": "Andrew",
"lastname" : "Other"
}JSON B
{
"lastname" : "Other",
"firstname": "Andrew"
}Any object that has a unique key member should ideally be represented as an object where the key is pulled out as the member string – this leads to unambiguous comparison. See the example below.
Arrays present more of a problem for comparison. This is because arrays are used for different purposes. For example, if an array is used to represent an x,y coordinate, then the expectation is that [ 34, 56 ] is not the same as [ 56, 34 ]. However, if the array is being used as an unordered set of numbers, then the arrays should be considered equal. So comparing by position or as unordered items are alternative approaches to be applied depending on the interpretation of the array data.
Furthermore, comparing by position is not always what is needed when we use an array as a list, where the item order is significant. In this case, comparing [1,3,2,4,5] with [1,3,4,5] by position would give three differences: 2 != 4, 4 != 5 and 5 is a deleted item.
[ 1, 3, 2, 4, 5 ] | | | | x [ 1, 3, 4, 5 ]
A more intelligent ordered comparison might just say that 2 has been inserted.
[ 1, 3, 2, 4, 5 ] | | + | | [ 1, 3, 4, 5 ]
So it is arrays that cause most problems in comparing JSON data.
When JSON is generated, arrays are often used where the data could be represented as objects. Converting such an array into an object may therefore be a sensible pre-comparison step in order to get only ‘real’ changes identified.
For example:
{"contacts": [
{
"id": "324",
"first_name": "AN",
"last_name": "Other"
},
{
"id": "127",
"first_name": "John",
"last_name": "Doe"
}
]}
would be much better represented for comparison purposes as:
{"contacts": {
"324": {
"first_name": "AN",
"last_name": "Other"
},
"127": {
"first_name": "John",
"last_name": "Doe"
}
}}
It may not look quite so natural, but the corresponding contacts will be aligned properly.
https://www.deltaxml.com/wp-content/uploads/2024/08/Thumbnail-challenges-100.jpg
566
698
Sasha Hayden
https://www.deltaxml.com/wp-content/uploads/2021/05/deltaxml-header-logo.png
Sasha Hayden2024-08-20 10:25:492024-09-04 16:34:43Solving Common Challenges with Inaccurate Document Management
https://www.deltaxml.com/wp-content/uploads/2024/08/Thumbnail-non-compliance-8.png
566
698
Sasha Hayden
https://www.deltaxml.com/wp-content/uploads/2021/05/deltaxml-header-logo.png
Sasha Hayden2024-08-20 09:52:502024-09-04 16:36:11How to avoid non-compliance when updating technical documents in regulated industries
https://www.deltaxml.com/wp-content/uploads/2024/08/Thumbnail-DMS-Compare-8-1.png
566
698
Sasha Hayden
https://www.deltaxml.com/wp-content/uploads/2021/05/deltaxml-header-logo.png
Sasha Hayden2024-08-20 09:21:482024-09-04 16:36:51Built-in XML Comparison vs Document Management Systems (DMS)
https://www.deltaxml.com/wp-content/uploads/2024/07/Thumbnail-MoveDetection.png
566
698
Sasha Hayden
https://www.deltaxml.com/wp-content/uploads/2021/05/deltaxml-header-logo.png
Sasha Hayden2024-07-03 17:54:362024-09-04 16:38:22How Move Detection Improves Document Management
https://www.deltaxml.com/wp-content/uploads/2024/07/Thumbnail-PIMJSON.png
566
698
Natali Barbova
https://www.deltaxml.com/wp-content/uploads/2021/05/deltaxml-header-logo.png
Natali Barbova2024-07-03 16:26:472024-09-05 09:03:34Streamlining Data Syndication in PIM Systems through JSON Comparison
https://www.deltaxml.com/wp-content/uploads/2024/05/Thumbnail-Detect-moves.png
1131
1395
Sasha Hayden
https://www.deltaxml.com/wp-content/uploads/2021/05/deltaxml-header-logo.png
Sasha Hayden2024-05-28 15:09:302024-09-05 09:04:58Move detection when comparing XML files
https://www.deltaxml.com/wp-content/uploads/2024/05/Thumbnail-config@2x.png
1131
1395
Sasha Hayden
https://www.deltaxml.com/wp-content/uploads/2021/05/deltaxml-header-logo.png
Sasha Hayden2024-05-21 11:18:392024-09-05 09:05:41Configuring XML Compare for Efficient XML Comparison
https://www.deltaxml.com/wp-content/uploads/2024/05/Thumbnail-compare-xml-files.png
1131
1395
Sasha Hayden
https://www.deltaxml.com/wp-content/uploads/2021/05/deltaxml-header-logo.png
Sasha Hayden2024-05-20 10:19:042024-09-05 09:07:02A Beginner’s Guide to Comparing XML Files
https://www.deltaxml.com/wp-content/uploads/2024/04/Thumbnail-CBC.png
1131
1395
Sasha Hayden
https://www.deltaxml.com/wp-content/uploads/2021/05/deltaxml-header-logo.png
Sasha Hayden2024-04-11 17:51:592024-06-06 10:52:04Introducing Character By Character ComparisonSign up to the DeltaXML newsletter to get the latest on DeltaXML and other company news.
WHERE CHANGE MATTERS
From ISO Quality Services Ltd.
XML and JSON: horses for courses or a one-horse race?
Scroll to top
Sign up to our newsletter and never miss an update on upcoming features or new products
