1E 8.1 (on-premises)

Core

Deserializes a correctly escaped JSON string that represents a two dimensional set of data with consistent columns and rows into a table variable.

Json (string): The JSON string that will be converted into a table.

A table built from the input JSON string, with one column for each JSON property.

Convert some Json that contains two rows and six columns

// returns table with 6 columns and 2 rows
@json = "[
{\"id\":1,
 \"first_name\":\"Eugenio\",
 \"last_name\":\"Verbrugghen\",
 \"email\":\"everbrugghen0@mashable.com\",
 \"gender\":\"Male\",
 \"ip_address\":\"188.126.39.115\"},
{\"id\":2,
 \"first_name\":\"Craggy\",
 \"last_name\":\"MoneyPenny\",
 \"email\":\"cmoneypenny@qq.com\",
 \"gender\":\"Male\",
 \"ip_address\":\"142.195.163.141\"}
]";
Utilities.TableFromJson(Json:@json);

The JSON string must adhere to RFC 8259.

This method will only deserialise a two dimensional table. Any property containing an array or another object instead of a boolean, string, number or null will be discarded.

Any property missing from a JSON object but exists in another object, will return a null.