JSON Importer Add-in for JMP 12

[#1]

This JMP 12 add-in converts a JSON file into a JMP data table, building on the JSON parsing JSL functions by Xan Gregg and Craige Hales. This add-in was written by JMP summer intern Matthew Wolfe and provides a dialog for picking a file to import.

For JMP 13 and later, JSON parsing is included with JMP. You can pick a .json file from the File Open dialog or use the JSON JSL functions.

Example JSON from Wikipedia entry:

{
  "firstName": "John",
  "lastName": "Smith",
  "isAlive": true,
  "age": 25,
  "address": {
   "streetAddress": "21 2nd Street",
   "city": "New York",
   "state": "NY",
   "postalCode": "10021-3100"
  },
  "phoneNumbers": [
   {
   "type": "home",
   "number": "212 555-1234"
   },
   {
   "type": "office",
   "number": "646 555-4567"
   }
  ],
  "children": [],
  "spouse": null
}

Here is the data table after import. Notice that nesting is reflecting in the column names.