PDF4me ExcelInstall

Summary

Convert a CSV file into JSON format by parsing its contents, supporting input via binary data, base64 string, or URL, with customizable delimiters and headers.

Inputs

• CSV File Input Method (required) — Select how the CSV file is provided: as binary data from a previous node, a base64 encoded string, or downloaded from a URL.
• Binary Data Property Name (required) — Specify the binary property name containing the CSV file when using binary data input.
• Base64 Encoded CSV Content (required) — Provide the CSV file content as a base64 encoded string when using the base64 input method.
• CSV File URL (required) — Enter the publicly accessible URL to download the CSV file when using the URL input method.
• CSV Delimiter — Choose the character used to separate values in the CSV file, including comma, semicolon, tab, pipe, or a custom delimiter.
• Custom Delimiter — Define a custom character as the CSV delimiter if 'Custom' is selected as the delimiter option.
• Skip First Line — Option to skip parsing the first CSV line, useful if it contains non-header metadata.
• Custom Column Headers — Comma-separated list of custom headers to override those in the CSV file.
• Culture Name — Set the culture name affecting parsing of numbers and dates (default is 'en-US').
• Output File Name — Name for the output JSON file generated after parsing.
• Source Document Name — Name of the original CSV file for reference.
• Output Binary Data Name — Name for the binary data property in the node output representing the parsed JSON.

Output shape

a list of JSON items representing parsed CSV rows, each as a JSON object with keys from CSV headers or custom headers.

The output includes binary data named as specified, containing the parsed JSON file. The operation handles parsing with configurable delimiter and header options, optionally skipping the first CSV line. Errors may be included per item if 'Continue On Fail' is enabled.