CSV

Overview of the CSV integration.

The following documentation is for CSV v1.15.0.

Overview

This integration enables converting and reading CSV files, allowing you to parse, create, and manipulate comma-separated value data within your automation workflows.

Setup

The following integrations need to be connected to your Kognitos workspace:

• CSV

Steps

Follow these steps to connect the integration in Kognitos:

1

Navigate

Using the left navigation menu, go to Integrations → Explore Integrations.

2

Find

Search for the integration and click on it.

3

Connect

Click on Connect to add a connection to the integration.

4

Configure

Add a name for the connection. You'll be prompted for authentication details if needed. Then, click on Connect.

Actions

The following actions are available in the CSV integration:

1. Convert csv to table

Convert a CSV or delimited file to a table.

2. Get csv column

Get the values from a specific column in a CSV file.

3. Get csv column types

Get the data types for all columns in a CSV file.

4. Get csv headers

Get the column headers from a CSV file.

5. Get csv row count

Get the number of rows in a CSV file, excluding the header row.

6. Merge delimited files

Merge multiple delimited files into one.

7. Write a delimited file

Write content to a delimited file.