CSV data source

Learn how to set up a CSV data source and then move this data to one of the supported by Coupler.io data destinations.

The 2 steps to complete the setup

  1. Set up your data source
  2. Set up your data destination

1. Set up your data source

1.1. Select an application: CSV

1.2. Fill out the "CSV URL" field

Paste the CSV URL to export data from.

If you're importing data from a CSV file on Google Drive, enter the shareable link of your CSV file here. (The folder containing the CSV file on GDrive must also be shared with "Anyone with the link")
This field supports macro. Learn more.

1.3. Select an HTTP Method

Select a method to indicate the desired action to be performed for a given data source. Learn more

1.4. Fill out the "Request headers" field

Specify the Request header, which can be used in an HTTP request to provide information about the request context so that the server can tailor the response. Learn more

Example:

Host: "developer.mozilla.org"

User-Agent: "Mozilla/5.0"<br>

1.5. Fill out the "URL query string" field

Specify the Query string that is part of a URL that assigns values to specified parameters by entering each of them in a new line. Learn more

This field supports macro. Learn more.

Example:

limit: 100

offset: 0<br>

1.6. Fill out the "Request body" field

Specify the Request body, which is part of an HTTP request and contains data sent to API. It is only supported by these HTTP methods: POST, PUT, PATCH, and DELETE.

This field supports macro. Learn more.Example:

customer_id: 1

customer_email: email@example.com<br>

This field supports macro. Learn more.

1.7. Fill out the "Fields" field

Specify a comma-separated list of fields and their order to be imported to Google Sheets. By default, Coupler.io will select all fields (e.g.  TitleStatus).

1.8. Fill out the "Skip rows" field

If your CSV file has multiple headers, specify the number of rows to skip from the top of the document. By default, Coupler.io will select all rows.

2. Set up your data destination

Continue setting up the integration depending on the system where you want to import data to. See full list of supported data destinations and follow set up guide for chosen one.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.