CSV Universal Connector
  • 2 Minutes to read
  • Dark
    Light

CSV Universal Connector

  • Dark
    Light

Article Summary

Now you can pull data in CSV format with Dataddo.

About Universal Connectors

Dataddo can connect to almost any online service providing it has JSON/CSV/XML based API. Read more about our Universal Connectors, how to configure them here.

CSV Universal Connector

A comma-separated values (CSV) file is a delimited text file that uses a comma to separate values. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format.

For this connector, there are a few additional specifics on top of general information.
Universal Connectors - CSV overview

Delimiter

Although most CSV files use commas as the delimiter (as the name suggests and it is a default configuration in Dataddo), in some cases, you might need to manually change to a different one.

New Line

Each system defines, what the new line characters are in their file format. There are two options to determine when the new line starts:

  • /n - UNIX systems use \n as their end of line character. This line break is not visible on the browser. \n is used for all other systems, applications, and the Internet.
  • /r/n - Windows systems use \r\n as their end of line character.

Offset

Use this field to set up the file offset. This is very useful when you need to divide the file into multiple queries and the following query starts, where the previous left off. Or, also when you need only a part of the file.

Limit

This is very useful when you need to divide the file into multiple queries and the following query starts, where the previous left off. Or, also when you need only a part of the file. Unless you know the source is too big, you can set up the limit to 100 000 or higher.

Example of the use of Offset and Limit

If you need to divide the source into multiple smaller sources, due to its size you can do it like this:

  1. Source - Offset = 0, Limit = 10 000
  2. Source - Offset = 10 000, Limit = 10 000
  3. Source - Offset = 20 000, Limit = 10 000
  4. Source - Offset = 30 000, Limit = 10 000

And so on.


Need assistance?

Feel free to contact us and we will help you with the setup. To speed the process of your ticket is resolved, make sure you provide us with sufficient information.


Was this article helpful?