Skip to main content
The CSV Tools connector provides operations for working with CSV data: parsing, converting to and from JSON, filtering rows, and transforming columns.
No connection required; this utility connector works out of the box.

​
Tools

​
csv
string
required
CSV string to convert.
​
header
boolean
default:"true"
First row is headers.
​
delimiter
string
default:","
Field delimiter.
​
skipEmptyLines
boolean
default:"true"
Skip empty lines.
Example request:
{
  "csv": "name,age,city\nAlice,30,Portland\nBob,25,Seattle"
}
Example response:
{
  "items": [
    { "name": "Alice", "age": 30, "city": "Portland" },
    { "name": "Bob", "age": 25, "city": "Seattle" }
  ],
  "count": 2
}
​
data
object[]
required
Array of objects to convert.
​
columns
string[]
Specific columns to include.
​
delimiter
string
default:","
Field delimiter.
​
header
boolean
default:"true"
Include header row.
​
quotes
boolean
default:"false"
Quote all fields.
​
encoding
enum
default:"utf8"
Output encoding for the csv field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.
Example request:
{
  "data": [
    { "name": "Alice", "age": 30, "city": "Portland" },
    { "name": "Bob", "age": 25, "city": "Seattle" }
  ],
  "columns": ["name", "city"]
}
Example response:
{
  "csv": "name,city\nAlice,Portland\nBob,Seattle",
  "rows": 2
}
Parse CSV with detailed configuration.
​
csv
string
required
CSV string to parse.
​
delimiter
string
Field delimiter.
​
newline
string
Newline character.
​
quoteChar
string
default:"\""
Quote character.
​
escapeChar
string
default:"\""
Escape character.
​
header
boolean
default:"true"
First row is headers.
​
dynamicTyping
boolean
default:"true"
Auto-convert values to numbers.
​
skipEmptyLines
boolean
default:"true"
Skip empty lines.
​
preview
number
Only parse the first N rows.
Example request:
{
  "csv": "product;price;stock\nWidget;9.99;150\nGadget;24.50;75\nDoohickey;4.99;300",
  "delimiter": ";",
  "preview": 2
}
Example response:
{
  "items": [
    { "product": "Widget", "price": 9.99, "stock": 150 },
    { "product": "Gadget", "price": 24.5, "stock": 75 }
  ],
  "count": 2,
  "meta": {
    "delimiter": ";",
    "linebreak": "\n",
    "fields": ["product", "price", "stock"]
  }
}
​
csv
string
required
CSV string.
​
column
string
required
Column name to filter on.
​
operator
string
required
Operator: equals, not_equals, contains, not_contains, gt, gte, lt, lte, or regex.
​
value
string | number
required
Value to compare.
​
delimiter
string
default:","
Field delimiter.
​
encoding
enum
default:"utf8"
Output encoding for the csv field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.
Example request:
{
  "csv": "name,age,city\nAlice,30,Portland\nBob,25,Seattle\nCarol,35,Portland",
  "column": "city",
  "operator": "equals",
  "value": "Portland"
}
Example response:
{
  "csv": "name,age,city\nAlice,30,Portland\nCarol,35,Portland",
  "rows": 2
}
​
csv
string
required
CSV string.
​
columns
string[]
required
Columns to sort by.
​
orders
string[]
Sort order for each column: asc or desc.
​
delimiter
string
default:","
Field delimiter.
​
encoding
enum
default:"utf8"
Output encoding for the csv field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.
Example request:
{
  "csv": "name,age,city\nAlice,30,Portland\nBob,25,Seattle\nCarol,35,Portland",
  "columns": ["city", "age"],
  "orders": ["asc", "desc"]
}
Example response:
{
  "csv": "name,age,city\nCarol,35,Portland\nAlice,30,Portland\nBob,25,Seattle",
  "rows": 3
}
​
csv
string
required
CSV string.
​
columns
string[]
Columns to check for uniqueness (all columns if omitted).
​
keepFirst
boolean
default:"true"
Keep the first occurrence (or last if false).
​
delimiter
string
default:","
Field delimiter.
​
encoding
enum
default:"utf8"
Output encoding for the csv field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.
Example request:
{
  "csv": "name,department\nAlice,Engineering\nBob,Sales\nCarol,Engineering\nDave,Sales",
  "columns": ["department"]
}
Example response:
{
  "csv": "name,department\nAlice,Engineering\nBob,Sales",
  "rows": 2
}
​
csv
string
required
CSV string.
​
select
string[]
Columns to include.
​
rename
object
Rename mapping (e.g., {"old_name": "new_name"}).
​
delimiter
string
default:","
Field delimiter.
​
encoding
enum
default:"utf8"
Output encoding for the csv field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.
Example request:
{
  "csv": "first_name,last_name,email\nAlice,Smith,alice@example.com\nBob,Jones,bob@example.com",
  "rename": { "first_name": "firstName", "last_name": "lastName" },
  "select": ["firstName", "email"]
}
Example response:
{
  "csv": "firstName,email\nAlice,alice@example.com\nBob,bob@example.com",
  "rows": 2
}
​
csvs
string[]
required
Array of CSV strings to merge.
​
delimiter
string
default:","
Field delimiter.
​
encoding
enum
default:"utf8"
Output encoding for the csv field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.
Example request:
{
  "csvs": [
    "name,role\nAlice,Admin",
    "name,role\nBob,User\nCarol,Editor"
  ]
}
Example response:
{
  "csv": "name,role\nAlice,Admin\nBob,User\nCarol,Editor",
  "rows": 3
}
​
csv
string
required
CSV string.
​
delimiter
string
default:","
Field delimiter.
​
sampleSize
number
default:"3"
Number of sample rows to include.
Example request:
{
  "csv": "name,age,city\nAlice,30,Portland\nBob,25,Seattle\nCarol,35,Portland\nDave,28,Denver",
  "sampleSize": 2
}
Example response:
{
  "rowCount": 4,
  "columnCount": 3,
  "columns": ["name", "age", "city"],
  "delimiter": ",",
  "sample": [
    { "name": "Alice", "age": 30, "city": "Portland" },
    { "name": "Bob", "age": 25, "city": "Seattle" }
  ]
}
​
csv
string
required
CSV string.
​
columnName
string
required
New column name.
​
value
string | number | boolean
required
Fixed value or column reference (e.g., $existingColumn).
​
delimiter
string
default:","
Field delimiter.
​
encoding
enum
default:"utf8"
Output encoding for the csv field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.
Example request:
{
  "csv": "name,age\nAlice,30\nBob,25",
  "columnName": "status",
  "value": "active"
}
Example response:
{
  "csv": "name,age,status\nAlice,30,active\nBob,25,active",
  "rows": 2
}
​
csv
string
required
CSV string.
​
start
number
default:"0"
Start index.
​
end
number
End index (exclusive).
​
delimiter
string
default:","
Field delimiter.
​
encoding
enum
default:"utf8"
Output encoding for the csv field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.
Example request:
{
  "csv": "name,age\nAlice,30\nBob,25\nCarol,35\nDave,28",
  "start": 1,
  "end": 3
}
Example response:
{
  "csv": "name,age\nBob,25\nCarol,35",
  "rows": 2
}