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.
