cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
JSON Importer Add-in for JMP 12
XanGregg
Staff

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.

9898_jsonimport2.png