JsonToTable

This Script is part of the Filters And Transformers Pack.

Supported versions

Supported Cortex XSOAR versions: 5.5.0 and later.

Accepts a json object and returns a markdown.

Script Data

---

Name	Description
Script Type	python3
Tags	transformer, entirelist, general
Cortex XSOAR Version	5.5.0

Inputs

---

Argument Name	Description
value	The json to transform to a markdown table.
title	The markdown title.
headers	A comma-separated list of table header values. Default will include all available table headers.
is_auto_json_transform	Try to auto json transform.
json_transform_properties	A json to transform the value to strings. The syntax is: `{"header_key": {"keys": [<item1>, ...], "is_nested": true/false}}`
url_keys	Comma-separated list of keys in the given JSON table that should be turned into a clickable URL.

Outputs

---

There are no outputs for this script.

Script Examples

Example command

!JsonToTable value=`[{"name": "name1", "value": "val1"}, {"name": "name2", "value" : "val2"}]`

Context Example

{}

Human Readable Output

name	value
name1	val1
name2	val2

Example command

!JsonToTable value=`[{"name": "name1", "value": "val1"}, {"name": "name2", "value" : "val2"}]` headers=name

Context Example

{}

Human Readable Output

name
name1
name2

Example command

!JsonToTable value=`[{"name": {"first": "a", "second": "b", "not_important": "no"}, "value": "val1"}, {"name": {"first": "c", "second": "d", "not_important": "no"}, "value": "val2"}]` is_auto_json_transform=true

Context Example

{}

Human Readable Output

name	value
first: a second: b not_important: no	val1
first: c second: d not_important: no	val2

Example command

!JsonToTable value=`[{"name": {"first": "a", "second": "b", "not_important": "no"}, "value": "val1"}, {"name": {"first": "c", "second": "d", "not_important": "no"}, "value": "val2"}]` json_transform_properties=`{"name": {"keys": ["first", "second"]}}`

Context Example

{}

Human Readable Output

name	value
first: a second: b	val1
first: c second: d	val2

Example command

!JsonToTable value=`[{"name": {"first": {"a": "val"}, "second": "b", "not_important": "no"}, "value": "val1"}, {"name": {"first": {"a": "val2"}, "second": "d", "not_important": "no"}, "value": "val2"}]` json_transform_properties=`{"name": {"keys": ["a", "second"], "is_nested": "true"}}`

Context Example

{}

Human Readable Output

name	value
first: a: val second: b	val1
first: a: val2 second: d	val2