SacNews - Relacionamento

Overview

This node operation "Extra - CSV/TSV - Formatar" is designed to fetch and process data from a CSV or TSV file available via a URL. It downloads the file, parses its content according to the selected delimiter format (CSV with commas or TSV with tabs), and formats the data based on predefined layouts that correspond to different data structures. This is useful for scenarios where you need to import, transform, or analyze tabular data from external sources in CSV or TSV format, such as contact lists, customer information, or other structured datasets.

Practical examples include:

• Importing phone numbers only from a CSV file for marketing campaigns.
• Processing detailed customer records including CPF (Brazilian individual taxpayer registry), names, company info, and references.
• Handling geographic data with addresses, coordinates, and contact details.
• Combining phone numbers with CPF or CNPJ identifiers for validation or enrichment purposes.

Properties

Output

The node outputs JSON data representing the parsed and formatted contents of the CSV/TSV file according to the selected layout. Each item corresponds to a row in the source file, with fields mapped based on the chosen data structure (e.g., phone numbers, personal identification, address details).

If binary data output is supported, it would typically represent the raw downloaded file or processed file content, but this node focuses on JSON-formatted structured data extracted from the CSV/TSV.

Dependencies

• Requires access to the internet or network location hosting the CSV/TSV file specified by the URL property.
• No explicit external API keys or credentials are needed specifically for this operation beyond the general node credential setup.
• The node depends on internal parsing utilities (from bundled dependencies) to handle CSV/TSV parsing and data formatting.

Troubleshooting

• Invalid URL or inaccessible file: If the URL is incorrect or the file cannot be reached, the node will fail to download the CSV/TSV. Verify the URL and network connectivity.
• Incorrect delimiter selection: Choosing CSV when the file is actually TSV (or vice versa) may cause parsing errors or malformed data. Ensure the delimiter matches the file format.
• Mismatched data layout: Selecting a layout that does not correspond to the actual columns in the CSV/TSV can lead to missing or incorrect fields in output. Confirm the layout matches the file's column structure.
• Large files: Processing very large CSV/TSV files might cause performance issues or timeouts. Consider splitting large files or using pagination if supported.
• Malformed CSV/TSV content: Files with inconsistent rows or invalid characters may cause parsing failures. Validate the source file integrity.

Links and References

• CSV Format Specification
• TSV Format Explanation
• General n8n documentation on working with CSV files (for context on CSV handling)