Contents

Method

TableFromJson

ModuleUtilities
LibraryCore
Action

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

ParametersJson (string): The JSON string that will be converted into a table.
Return valuesA 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
  • Windows
  • Linux
  • MacOS
  • Solaris Intel
  • Solaris Sparc
  • Android
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. ?? cause an error ??

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