Import JSON Files

A JSON file consists of name and value pairs that are imported as column headings and data. In the following example, the first name in each string is appended to “Grocery Store Purchases” and turned into column headings, as in “Grocery Store Purchases.Item”. “avocado” is the value in the first cell of the table. The next column is named “Grocery Store Purchases.Category”, and “Produce” is the value in the first cell of the second column.

{"Grocery Store Purchases":[

    {"Item":"avocado", "Category":"Produce"},

    {"Item":"bread", "Category":"Bakery"},

    {"Item":"chocolate", "Category":"candy"}

]}

To open a JSON file in JMP, select File > Open, select the file, and then click Open. On Windows, make sure that JSON Data File is selected in the Filename list on the Open Data File window.

Notes:

•

The JSON file does not contain date, time, currency, geographic, percent, and scientific information to determine the column format. After you import the file into JMP, right-click the numeric column, select Column Properties, and change the Format.

•

The available memory on your computer determines the maximum number of columns rows that can be imported. The limit also depends on the other programs that are running at the time of import.

•

Member names in name-value pairs are case insensitive.

•

For nested items, JMP repeats the outer item for each row.

•

The file cannot have an empty array element. The name must be quoted before the colon in the name-value pair.

•

The locale is ignored when you export data to JSON format. The JSON standard accepts decimal numbers with decimal points.