Subscribe Bookmark RSS Feed
XanGregg

Staff

Joined:

Jun 23, 2011

JSON Importer Add-in for JMP 12

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

Article Labels
Article Tags
Contributors