/
tableToJson
tableToJson
[ 1 Operator Usage in Easy Mode ] [ 2 Usage Details ] [ 3 Example ]
Create a JSON column from all columns of the table.
Operator Usage in Easy Mode
Click + on the parent node.
Search for Table to JSON operator in the search field and select the operator from the Results to open the operator form.
In the Table drop-down, enter or select a table from which to source the data.
Click Run to view the result.
Click Save to add the operator to the playbook.
Click Cancel to discard the operator form.
Usage Details
LQL Command
addExecutionMetadata(table)
Example
Input
table
: Table name - "data"
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 |
---|---|---|---|
Devo | 7.5 | ["VirusTotal", "Zscaler"] | {"Org" : "Devo", "score" : 7.5, "sources" : "sources" : "[\"VirusTotal\", \"Zscaler\"]"} |
, multiple selections available,
Related content
columnsToJsonV2
columnsToJsonV2
More like this
columnsToJson
columnsToJson
More like this
jsonToColumns
jsonToColumns
More like this