statement -program to generate difference between two JSON files
Sample JSON files -
[login to view URL]
{"id": "10001", "SortAs": "SGML", "GlossTerm": "Standard Generalized Markup Language", "Acronym": "SGML","Abbrev": "ISO 8879:1986"}
{"id": "10002", "SortAs": "SGML", "GlossTerm": "Standard Generalized Markup Language", "Acronym": "SGML","Abbrev": "ISO 8879:1986"}
{"id": "10003", "SortAs": "SGML", "GlossTerm": "Standard Generalized Markup Language", "Acronym": "SGML","Abbrev": "ISO 8879:1986"}
[login to view URL]
{"id": "10001", "SortAs": "SGML", "glossterm": "Standard Generalized Markup Language", "Abbrev": "ISO 8879:1986"}
{"id": "10003", "SortAs": "SGML", "GlossTerm": "Standard Generalized Markup Language", "Acronym": "SGML","Abbrev": ""}
{"id": "10004", "SortAs": "SGML", "GlossTerm": "Standard Generalized Markup Language", "Acronym": "SGML","Abbrev": "ISO 8879:1986"}
Use Cases-
Assuming ID as primary key, match records in both files
Expected outcome format
ID (Key USed):
Name of field:
Value of first Json:
Value of second Json:
Type of difference:
scenarios (1)
ID (Key USed): "1001"
Name of field: "SGML"
Value of first Json: "Glossterm"
Value of second Json: "glossterm"
Type of difference: "case sensitive"
scenarios (2)
ID (Key USed): "1001"
Name of field: "Acronym"
Value of first Json: "1"
Value of second Json: ""
Type of difference: "Missing Field"
scenarios (3)
ID (Key USed): "1002"
Name of field: "Abbrev"
Value of first Json: "ISO 8879:1986"
Value of second Json: ""
Type of difference: "Empty value"
scenarios (4)
ID (Key USed): "1002"
Name of field: "all"
Value of first Json: "filled"
Value of second Json: "empty"
Type of difference: "missing id"
ID (Key USed): "1004"
Name of field: "all"
Value of first Json: "empty"
Value of second Json: "filled"
Type of difference: "missing id"
Hello,
After reading problem description I found that you need a program that will take two json file and find deference between them based on ID.
I can write program for it in Both JS and PHP.
Thanks
Hi,
I have expertise in java and PHP.
We can write this program in both the languages and can deliver it to you in few hours.
Let me know if you are interested.
Hey I went on ahead and tried some test case on your problem, it can be completed within 3-4 hours if urgently required. It would be better if you could provide some defined values you would like to see in compared results.
I clearly understand what you require, i.e. compare two json encoded objects. I can provide you with the results in a couple of hours. I'm ready to start this project right now. I think my bid is fair, but always ready to work with your budget.
Hi, I'm a programmer with 5+ years of experience, java and python are my daily working language. I've dealt many similar scenarios like file processing, text comparison, etc.
For your task, I think it's pretty straight forward, just parse the json file and add them to different list and then do the comparing. Besides, I'd like to know:
1. Is the type of difference limited?
2. How big is your file?
We can discuss in more details if you're interested. I'll provide high quality work the best as I can.
You can contact with me at any moment to discuss your task.
You can contact with me at any moment to discuss your task.
You can contact with me at any moment to discuss your task.