Primary Use Cases | Use this connector to access CSV files from an SFTP server. |
Primary Metrics | N/A |
Primary Company Roles | Analysts |
Average Implementation Time | 1 hour |
Ease of Use (on a 1-to-10 scale with 1 being easiest) | 4 |
Menu | Description |
|---|---|
Select the Protocol to access the CSV File | Select a protocol for accessing the CSV file. Use SFTP to access a CSV file located on an SFTP server. Use HTTP Request to access a CSV file using an HTTP GET request. The request is triggered by the use of a unique URL parameter defined by the service providing the CSV file. |
Enter the URL to your CSV file | Enter the URL for the CSV file. If using the File Transfer protocol, enter the URL to the folder containing the CSV file. For example: s ftp\://hostname/home/test . You'll also have to include the port in the URL if the SFTP server is not configured to run on the standard port 22. The 1234 port specific URL would look like s ftp\://hostname:1234/home/test Note: Due to security concerns, Domo no longer permits uploading data using FTP. If necessary, please update your server settings to support SFTP instead of FTP. If using the HTTP Request protocol, enter the full URL for the CSV file. You must provide the URL as well as the fully qualified path, including the filename. For example: [http://www.ferc.gov/docs-filing/eqr/...v/contract.txt](http://www.ferc.gov/docs-filing/eqr/...v/contract.txt) If you are using the SFTP protocol, you can request a file for a specific date. You need to name your file using the format `file_[yyyyMMdd]_suffix.csv` . You can also select the most recent file using the format filenameprefix\_\[latest] . |
Would you like to enter a file name to search for or select a file to retrieve every time | Select whether you want to select a specific file from the specified directory or search for a file name. |
Enter File Name | Enter the name of the file to import into Domo. To import the most recently modified file, add \[latest] to the file name prefix. |
File Name Match Type | Select the file name match type. |
Select a file from the above directory | Select a file from the specified directory. You can select a CSV, TXT or GZ file to parse or a ZIP file to unzip. |
Select a file type | Select the file type for the file you want to access. |
Enter the CSV file from the zip archive | Enter the CSV file to parse from the zip file. |
Select a file from the Zip archive | Select a CSV file to parse from the unzip folder. |
Enter a filename from inside the Zip archive | Enter the name of the file to parse from the ZIP archive. If you leave this field blank, the first file found is processed. |
HTTP Headers | Enter additional headers for your HTTP/HTTPS CSV URL, if necessary. Use the format header Name1 = 'headerValue1' and headerName2 = 'headerValue2' . |
HTTP Body | Enter additional request body for your HTTPS CSV URL, if necessary. |
Date Format | Select the required date format. Use this option to correct incorrectly formatted dates. |
Add file name column | Adds the retrieved file name to the dataset in the *BATCH\_FILE\_NAME* column. If you select this option, only columns in the header row are used. Data without a column name in the header row is excluded. A blank column name is considered a column name. |
| Convert Double type to Decimal | Select this checkbox to convert Double to Decimal. |
| Update only if the source file is modified | Choose whether to retrieve and update data only if the source file has changed since the last execution. |
| Cast Columns to String Datatype | Enter a comma separated list of fields that need to be treated as STRING in Domo. |
Menu | Description |
|---|---|
Delimiter Character | Select the delimiter character used to separate columns in your CSV file. |