Actions11
Overview
This node converts CSV data into structured document objects. It is useful for scenarios where CSV data needs to be transformed into JSON-like documents for further processing or storage, such as importing user data, product lists, or any tabular data into a document-based system.
Use Case Examples
- Importing a CSV file of user information and converting each row into a user document with typed fields.
- Mapping CSV columns to different field names and generating unique IDs for each document automatically.
Properties
| Name | Meaning |
|---|---|
| CSV Input | The raw CSV data string to be converted into documents. |
| Auto-Detect Types | Whether to automatically detect and convert CSV field values to appropriate data types like numbers, booleans, and dates. |
| Generate IDs | Whether to generate unique IDs for each document automatically. |
| ID Field | The name of the CSV column to use as the document ID if not generating IDs automatically. |
| Delimiter | The character used to separate fields in the CSV data. |
| Field Mapping (JSON) | A JSON object mapping original CSV column names to new field names in the output documents. |
Output
JSON
documents- An array of document objects created from the CSV rows, with fields mapped and types converted as specified.
Troubleshooting
- Ensure the CSV input is properly formatted and matches the specified delimiter.
- If auto-detection of types is enabled, verify that the CSV data values are consistent and parseable as the expected types.
- When not generating IDs, ensure the specified ID field exists in the CSV data to avoid missing document IDs.