Parse – Documentation and Support | Knowi

If your data is a JSON string, the PARSE function can be used to convert it into an object which can then be further manipulated and processed.

select PARSE(<JSON String Column>)

Example

Here the Profile and Versions fields hold JSON strings. PARSE converts them into objects, so their properties can be accessed with dot notation, as shown by Profile.name.

Input data:

[  {    "Profile": "{\"name\":\"knowi\",\"age\":20}",    "Versions": "[{\"ver\":12},{\"ver\":13}]",    "Description": "Employee account"  }]

Cloud9QL:

select parse(Profile) as Profile,   parse(Versions) as Versions,   parse(description) as Description;select Profile.name, Description

Result:

Profile.name = "knowi"Description = "Employee account"

Related articles