tableToJson
Converts LQL table to single JSON column.
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
addExecutionMetadata(table)
Example
Input
table
: Table name - "data"
Org | score | sources |
---|---|---|
Devo | 7.5 | ["VirusTotal", "Zscaler"] |
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"]"} |
Updated 10 months ago