Skip to main content

JSON Converter User Manual 1.0.0

Raise a support ticket

HOW TO USE JSON CONVERTER​

  1. Extract the JSON Converter zip file using the archiving tool of your choice.

  2. To run JSON Converter, double click on the exebutable. Ensure that you run the executable from within the folder it was extracted to.

    2020-08-11_14-45-13.png

    2020-08-11_15-00-48.png

NameDescription
Close ButtonClicking this button will close JSON Converter
JSON to convertClick the Select button to specify the original JSON file that will be converted. Values in this file will be retained in the updated JSON file.
Updated JSONClick the Select button to specify the updated JSON file to use for the conversion. Values in this file will be overwritten by the values from the original JSON file selected above. New properties along with their values will be added to the final output JSON file.
Output PathClick the Select button to specify the directory path that the new final json file will be written to.
Generate ButtonClick the Generate button to generate the new JSON file to the directory specified in the Output Path field.

UPDATING JSON ARRAYS​

In some cases (for example the 365|2CM connection.json file) the JSON file will start off blank and will only have JSON written to it via user interaction, such as creating a connection. For these cases, a "template" JSON file will be required for the Updated JSON field. The tool will grab the new fields in the template JSON file and apply it to each existing JSON object within the original JSON array.

For example, if the Original JSON file to be updated was: [    {      "field 1" : "hello",      "field 2" : "world"     },    {      "field 1" : "Hi",      "field 2" : "There"    } ] Then the template JSON file will be (inlcuding any new fields): {      "field 1" : "",      "field 2" : "",      "new field 1" :"",      "new field 2" :"" } The final output JSON file generated by JSON Converter will be: [    {     "field 1" : "hello",     "field 2" : "world",      "new field 1" :"",      "new field 2" :""     },     {      "field 1" : "Hi",      "field 2" : "There",      "new field 1" :"",      "new field 2" :""     } ]