Document toolboxDocument toolbox

tableToJson

Create a JSON column from all columns of the table.

Operator Usage in Easy Mode

  1. Click + on the parent node.

  2. Search for Table to JSON operator in the search field and select the operator from the Results to open the operator form.

  3. In the Table drop-down, enter or select a table from which to source the data.

  4. Click Run to view the result.

  5. Click Save to add the operator to the playbook.

  6. Click Cancel to discard the operator form.

Usage Details

LQL Command

addExecutionMetadata(table)

Example

Input

table: Table name - "data"

Org

score

sources

Org

score

sources

Devo

7.5

["VirusTotal", "Zscaler"]

LQL command

tableToJson(data)

Output

This operator will create an additional lhub_json_column column.

Org

score

sources

lhub_json_column

Org

score

sources

lhub_json_column

Devo

7.5

["VirusTotal", "Zscaler"]

{"Org" : "Devo", "score" : 7.5, "sources" : "sources" : "[\"VirusTotal\", \"Zscaler\"]"}