Utilities.TableFromJson
Module | Utilities |
|---|---|
Method | |
Library | Core |
Action | Deserializes a correctly escaped JSON string that represents a two dimensional set of data with consistent columns and rows into a table variable. |
Parameters | |
Return values | A table built from the input JSON string, with one column for each JSON property. |
Example | 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); |
Platforms |
|
Notes | 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. |