JSONtoCSV

Convert a JSON War Room output via EntryID to a CSV file.

python · Common Scripts

Details

IDJSONtoCSV
Languagepython
From Version5.0.0
Docker Imagedemisto/python3:3.12.13.10404775

README

Convert a JSON War Room output via EntryID to a CSV file.

Script Data

Name Description
Script Type python3
Cortex XSOAR Version 5.0.0

Inputs

Argument Name Description
entryid Entry id of json
delimiter CSV Delimiter.
filename If provided will output CSV to file. Default output is to War Room.

Outputs

Path Description Type
File.Name Filename (only in case of report type=json) Unknown
File.Type File type e.g. “PE” (only in case of report type=json) Unknown
File.Size File size (only in case of report type=json) Unknown
File.MD5 MD5 hash of the file (only in case of report type=json) Unknown
File.SHA1 SHA1 hash of the file (only in case of report type=json) Unknown
File.SHA256 SHA256 hash of the file (only in case of report type=json) Unknown

Source

JSONtoCSV.py JSONtoCSV_test.py JSONtoCSV.yml
Download History Raw 
from CommonServerPython import *


def test_main(mocker):
    from JSONtoCSV import main

    mocker.patch.object(demisto, "args", return_value={"entryid": "something@something"})
    mocker.patch.object(demisto, "executeCommand", return_value=[{"Contents": [{"Test": "value"}, {"Test": "value2"}]}])
    mocker.patch.object(demisto, "results")
    main()
    results = demisto.results.call_args
    assert results[0][0] == "Test\r\nvalue\r\nvalue2"