# stackstorm-csv

**Repository Path**: siem-soar-package/stackstorm-csv

## Basic Information

- **Project Name**: stackstorm-csv
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2021-11-12
- **Last Updated**: 2021-11-12

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# CSV Integration pack

Pack containing various actions for working with CSV documents / data.

## Actions

### parse

Parse the provided csv string and return a JSON array.

#### Example

Input:

```csv
FirstName,LastName,Title,ReportsTo.Email,Birthdate,Description
Tom,Jones,Senior Director,buyer@salesforcesample.com,1940-06-07Z,"Self-described as ""the top"" branding guru on the West Coast"
Ian,Dury,Chief Imagineer,cto@salesforcesample.com,,"World-renowned expert in fuzzy logic design. 
Influential in technology purchases."
```

Output (result):

```json
[
    [
        "FirstName",
        "LastName",
        "Title",
        "ReportsTo.Email",
        "Birthdate",
        "Description"
    ],
    [
        "Tom",
        "Jones",
        "Senior Director",
        "buyer@salesforcesample.com",
        "1940-06-07Z",
        "Self-described as \"thetop\" branding guru on the West Coast"
    ],
    [
        "Ian",
        "Dury",
        "Chief Imagineer",
        "cto@salesforcesample.com",
        "",
        "World-renowned expert in fuzzy logic design.  Influential in technology purchases."
    ]
]
```

### format

Format a list of dictionary objects into a CSV string. Array (list) object is passed as the `data` parameter. Also accepts `delimiter` which defaults to `,` and `quote_char` which defaults to `"`.

#### Example


Input: data (array):

```json
[
    {
        "FirstName": "Tom",
        "LastName": "Jones",
        "Title": "Senior Director",
        "ReportsTo.Email": "buyer@salesforcesample.com",
        "Birthdate": "1940-06-07Z",
        "Description": "Self-described as \"thetop\" branding guru on the West Coast"
    },
    ...
]
```

Output

```csv
FirstName,LastName,Title,ReportsTo.Email,Birthdate,Description
Tom,Jones,Senior Director,buyer@salesforcesample.com,1940-06-07Z,"Self-described as ""the top"" branding guru on the West Coast"
Ian,Dury,Chief Imagineer,cto@salesforcesample.com,,"World-renowned expert in fuzzy logic design. 
Influential in technology purchases."
```

**Note** : When modifying the configuration in `/opt/stackstorm/configs/` please
           remember to tell StackStorm to load these new values by running
           `st2ctl reload --register-configs`