LookupCSV
Parses a CSV and looks for a specific value in a specific column, returning a dict of the entire matching row. If no column value is specified, the entire CSV is read into the context.
python · Common Scripts
Details
| ID | LookupCSV |
|---|---|
| Language | python |
| From Version | 5.0.0 |
| Docker Image | demisto/python3:3.12.13.10404775 |
| Tags | file csv Utility |
README
Parses a CSV and looks for a specific value in a specific column, returning a dict of the entire matching row. If no column value is specified, the entire CSV is read into the context.
Script Data
| Name | Description |
|---|---|
| Script Type | python3 |
| Tags | file, csv, Utility |
| Cortex XSOAR Version | 5.0.0 |
Inputs
| Argument Name | Description |
|---|---|
| entryID | EntryID of CSV file. |
| header_row | CSV file has a header row. |
| column | Column to search for value in, if not specified, entire CSV is parsed into the context. |
| value | value to search for |
| add_header_row | Extra row, in CSV format, to function as header if original does not contain headers |
Outputs
| Path | Description | Type |
|---|---|---|
| LookupCSV.Result | List of result objects; either a list of dicts (with header_row) or a list of lists (no header row) | Unknown |
| LookupCSV.FoundResult | Boolean, for whether the result was found in the CSV or not. | Unknown |
| LookupCSV.SearchValue | The value that was searched. | Unknown |
name: LookupCSV script: '-' type: python tags: - file - csv - Utility comment: Parses a CSV and looks for a specific value in a specific column, returning a dict of the entire matching row. If no column value is specified, the entire CSV is read into the context. enabled: true args: - name: entryID required: true description: EntryID of CSV file. - name: header_row description: CSV file has a header row. auto: PREDEFINED predefined: - "true" - "false" - name: column description: Column to search for value in, if not specified, entire CSV is parsed into the context. - name: value description: value to search for. - name: add_header_row description: Extra row, in CSV format, to function as header if original does not contain headers. outputs: - contextPath: LookupCSV.Result description: List of result objects; either a list of dicts (with header_row) or a list of lists (no header row). - contextPath: LookupCSV.FoundResult description: Boolean, for whether the result was found in the CSV or not. - contextPath: LookupCSV.SearchValue description: The value that was searched. scripttarget: 0 subtype: python3 dockerimage: demisto/python3:3.12.13.10404775 runas: DBotWeakRole commonfields: id: LookupCSV version: -1 fromversion: 5.0.0 tests: - No tests (auto formatted)