Primary Use Cases | This connector is an excellent choice for retrieving flat files when APIs are not an option. |
Primary Metrics | N/A |
Primary Company Roles |
|
Average Implementation Time | Less than an hour if you have the correct file types in S3. |
Ease of Use (on a 1-to-10 scale with 1 being easiest) | 4 |
| ID Types | Description |
| EXTERNAL\_ID: | ID generated by DOMO. |
| ACCOUNT\_ID: | Select your Account\_ID from the above-mentioned list as per your country. |
Field | Description |
|---|---|
Role ARN | Enter the Amazon Resource Name (ARN) of the role you want to assume. |
Role Session Name | Enter the identifier for the assumed role session. |
External ID | Enter the unique identifier used by third parties when assuming roles in their customers' accounts. |
Bucket | Enter the Amazon S3 Bucket you want to pull files from. |
Region | Select the S3 Bucket Region where your file is located. |
Menu | Description | ||||||
|---|---|---|---|---|---|---|---|
File Type to Import | Select the type of file you want to import into Domo, either CSV, JSON, TSV, TXT, XML, XLS, or XLSX. | ||||||
Does Your Filename Have an Extension? | Select Yes if the filename ends with the supported file type extension; otherwise select No . | ||||||
How Would You Like to Choose Your Filename? | Select how you want Domo to identify your file. Options are as follows:
| ||||||
Enter Complete Filepath | Enter the complete path for the desired file. | ||||||
List of Files from Amazon S3 Bucket | Select the file you want to retrieve. | ||||||
Prefix (Optional) | Enter a prefix to filter results by. A prefix limits results to only those keys that begin with the given prefix. | ||||||
File Name | Enter the name of the file you want to import, with or without the file path. For example: folder\_name/file\_name | ||||||
File Name Match Type | Specify whether the file you want to retrieve starts with or contains the text you entered under File Name . | ||||||
File Compression Type | Select the compression type for the file you want to retrieve. If the file is not compressed, select None . | ||||||
Select a File from ZIP Archive | Select the ZIP file you want to import. | ||||||
Add FileName Column | Select Yes if you want a "*BATCH\_FILE\_NAME*" column to be added to your output data; otherwise select No . | ||||||
Select the Delimiting Character | Select the delimiter used in the CSV file you want to retrieve. If your delimiter is not listed, select Other . | ||||||
Specify Your Delimiter (Conditional) | Enter the character used to delimit your CSV text. | ||||||
Quote Character | Select a quote character to parse the CSV file you want to retrieve. A double quote (") is the CSV standard. If your desired quote character is not in the list, select Other . | ||||||
Custom Quote Character (Conditional) | Enter the desired quote character. | ||||||
Escape Character | Select an escape character to parse the CSV file you want to retrieve. A backslash () is the CSV standard. If your desired escape character is not in the list, select Other . | ||||||
Custom Escape Character (Conditional) | Enter the desired escape character. | ||||||
Are Headers Present in CSV File? | Select Yes if the CSV file you are importing contains headers; otherwise select No . | ||||||
Enter Your Header Tag (Conditional) | Enter the tag for the header in your JSON file. | ||||||
Does Your JSON Text Require a Line Reader? | Specify whether the text in your JSON file includes multiple lines that should be read. | ||||||
Should the Backslash be Escaped? | Specify whether the text in your JSON file contains backslash characters that should be escaped. | ||||||
Enter your Sublist to Flatten (Optional) | Enter the comma-separated sublists you want to flatten in your data. | ||||||
Enter XPath Expression (Optional) | Enter your XPath expression. | ||||||
Do You Require Attributes in Data? | Specify whether you require attributes values as part of your XML data. | ||||||
Enter Your Data Tag (Optional) | Enter the tag for the data in your JSON or XML file. | ||||||
Enter Fields to Exclude (Optional) | Provide a comma-separated list of fields to exclude in your JSON/XML import. | ||||||
Sheet Name (Optional) | Enter the sheet name you want to import from the specified Excel spreadsheet. Be sure to check the name for accidental spaces. If this field is left blank, the first sheet of the workbook will be used. | ||||||
File Password (Conditional) | If your Excel file is password-protected, enter the file password. | ||||||
Layout | Select the layout of your Excel file. The following options are available:
| ||||||
Mode | Select how the cell range of your Excel data will be determined. If you select Auto , the range is determined automatically. If you select Manual , you will be asked to enter the column header and data ranges manually. | ||||||
Enable Parsing for Large JSON Files? | Specify whether parsing is enabled for large JSON files. | ||||||
Column Header Range | Enter the range for the column headers in your Excel sheet. For example: A2:F8 | ||||||
Row Header Range | Enter the range for the row headers in your Excel sheet. For example: A2:A8 | ||||||
Data Range | Enter the range for the data (non-header) cells in your Excel sheet. For example: A3:F20 | ||||||
Header Start Row (Advanced only) (optional) | Enter the header row number. If you do not enter a number, the first row is considered the header row. | ||||||
Data Start Row (Advanced only) (optional) | Enter the starting data row number. If you do not enter a number, the first row after the header row is considered the starting row. | ||||||
Footer Rows to Skip (Advanced only) (optional) | If there are one or more rows at the bottom of the file you do not want to import, enter the number of rows to skip. | ||||||
Date Format (optional) | Select the date format that should be used when converting date columns. (For Excel files, the date format specified for the cell will have higher precedence). | ||||||
Blank Rows (Advanced only) (optional) | Select the desired outcome if blank rows are encountered in the Excel file. If you select Skip blank rows , the file is processed as normal without the blank rows. If you select Stop at the first blank row , everything is pulled up until the first blank row. | ||||||
Empty Column Headers (Advanced only) (optional) | Select the desired outcome if empty column headers are encountered in the Excel. If you select Add blank columns , new columns are generated with default names applied. If you select Stop at the first blank column , everything is pulled up until the first column with an empty header. |