What Does This Article Cover?
- Using the File Connection to obtain a .CSV File
- Using the Pipeline Parse CSV Stage to format data
- Considerations
- Other Related Material
Using the File Connection to Obtain a .CSV File
The Intelligence Hub File Connection can be used to obtain data from a file with .CSV format. In the scenario in the image below the Include Metadata option is enables so the value attribute is populated with data in .CSV format.
Using the Pipeline Parse CSV stage to format data
The standard Pipeline Parse CSV stage can be used to format the CSV data as JSON.
The data is converted to JSON format.
Considerations
The Pipeline Parse CSV Stage includes configurable options.
-
Delimiter Character - The default delimiter set by the function is a comma. CSV stands for comma-separated values and traditionally may have only used a comma as the delimiter. As shown in the example provided, other characters like a tab may be used instead.
-
Escape Character - The escape character used by the CSV parser. Defaults to \. Supports the following escaped characters \t (tab), \r (return), \n (newline). Leave this blank to disable escaping.
-
Quote Character - The quote character used by the CSV parser. Defaults to ". Leave this blank to disable quoting.
-
Override Headers - A configurable list of headers to override.