Help Center
Training
Knowledge Base
Community
Developers
Support

DataSet via Email Connector

Domo University
  • Updated
Follow

Intro

The Dataset via Email connector enables you to get your data into Domo quickly and easily by capturing and processing .xls, .xlsx, and .csv files that have been included as attachments to an email message. Additionally, the DataSet via Email Connector can parse through a Gzip or Zip file to return a .csv or .xlsx file. When you configure this connector, it generates a unique email address that corresponds to your Dataset via Email DataSet in Domo. Once the email address is created, you can send the spreadsheet as an attachment to that email address. The connector will then process the email and update your data accordingly. 

Please note that this connector currently pulls in data from only one attachment. If your email message includes more than one attachment, data is pulled from the first listed attachment. 

Note that each time you configure this connector, you do so for an attachment with a fixed set of characteristics. For instance, if you create a configuration for CSV files with specific parameters, you cannot then send XLS spreadsheets to the email address that is generated unless you go back into the connector interface and switch the file type to XLS. If you want to change the attachment file type, it is highly recommended that you create a new connection with its own email address.

You configure settings for your DataSet via Email connection in the Data Center. This topic discusses the fields and menus that are specific to the DataSet via Email connector user interface. General information for adding DataSets and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.

Note:  The maximum size of emails you can pull into Domo is 25 MB.
Note:  This connector does not pull data from forwarded emails. Data from an attachment or link can only be brought into Domo if it belongs to the email sent to the DataSet.

Video - DataSet Via Email Connector

 

Prerequisites

None. No credentials are required.

Configuring Your DataSet via Email Connection

This section enumerates the options in the Details pane in the DataSet via Email connector page. The components  of the other pane in this page, Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Details Pane

This pane contains various options for configuring your DataSet via Email connection.

Menu

Description

Email

Automatically generates the email address you will send your attachments to. Click Copy Email to copy this email address to your clipboard.
File Location

Select a file location option:

  • Email Attachment. Indicates that the DataSet file is attached to the email or in the body of the email you are connecting to.

  • Download directly from link in email. Indicates that the email contains a direct download link to the DataSet file.

    Note: If there are multiple links in the message, the connector will use the first link that appears in the message.

  • Download from link to page. Indicates that the email contains a URL leading to a page with a download link to the DataSet file. 

    Note: To find the download page, look for the first link in which the URL or link label contains the file type. If a link with the file type cannot be not found, the connector will look for a link that contains "report" or "download".

    After retrieving the download page, the connector will look for the actual data link the same way (matching against the file type). Note that the URLs on the download page cannot be generated by JavaScript.

File Type

Select the file type for your attachments:

  • Email body as one row. Use if the data you want to import is found in the body of the email (rather than as an attachment) and should be imported into Domo as a single row of data in a DataSet.   

  • Email body as HTML. Use if the data you want to import is found in the body of the email (rather than as an attachment) and should be imported into Domo as HTML. You must set File Attachment to Email Attachment when using this option. 

  • CSV. Use if your DataSet is contained within an attached CSV file.

  • XLS. Use if your DataSet is contained within an attached XLS file.

  • XLSX. Use if your DataSet is contained with an attached XLSX file.

Notes:  

  • The file size limit of your chosen email provider dictates the file size limit for this connector.

  • The connector is not able to determine your extension file type if the email does not use TLS 1.2 or above.

From Email Address

Enter the email address you will be sending attachments from. Emails sent from other email addresses will be rejected. Enter NONE to accept emails from any email address.

Note: Make sure that the email in the configurations matches the email you are sending the file to!

Email Subject Expression

Enter a regular expression that will be used to validate the subject of the email you send. Emails with a subject that do not fully match the expression will be rejected. Enter NONE to accept any email subject.

Here is an example of a full match:

Subject = 1900 Audit Report for Domo 
Regex = .*Audit_Report.*

Email Body Expression

Enter a regular expression that will be used to validate the body of the email you send. Emails with body content that do not fully match the expression will be rejected. Enter NONE to accept anything included in the body.

Here is an example of a full match:

Body = Here is the Audit Report file to upload to Domo. 
Regex = .*Audit\sReport.*

Attachment Name Expression

Enter a regular expression that will be used to validate the filename of the attachment. Attachments that do not fully match the expression will be rejected. Enter NONE to accept any filename.

Here is an example of a full match:

Attachment = 1.audit_report_1.1.1900.1.00AM.xlsx
Regex = .*audit_report.*

Show Advanced Options

Check the box to show advanced configuration options.

Header Row (Optional)

Enter the header row number. If you do not enter a number, the first row is considered the header row.

Skip Footer Rows (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.

Starting Data Row (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.
Delimiter Select the delimiter used to parse your CSV file. If you select Detect the delimiter, the appropriate delimiter is determined automatically. 
Escape Character Select whether or not to use an escape character. 
Quote Character Select whether to use double quotes or single quotes as a quote character, or no quote character at all.
Detect Encoding Check this box if you want Domo to detect your encoding type automatically; leave it unchecked if you want to enforce UTF-8 encoding. 

Excel Sheet Name

Enter the sheet name of the Excel file you want to create a DataSet from.

Excel Sheet Tab Number

Enter the tab number of the Excel sheet you want to create a DataSet from.

Raw Headers

If you select Yes, the connector will use the headers in the sent file. If you select No, the connector will modify any special characters found in the header text.

Date Format

Select the date format used in the attachment. If you want dates to be represented as text, select Show Dates as Strings.
Data Contains Header Row Set this to true if the data contains a row containing column headers. Set this to false if the data does not contain a header row.
Number As Strings Columns Selecting yes will add a column for all columns that are numbers and format them as strings to preserve their original format including any leading zeros.
Ignore Decoding Errors Select 'yes' to ignore decoding errors.
Only data that is processed before the decoding error will be retrieved.
This is recommended if there are extraneous characters at the end of the email file that are corrupt.
Allow Leading Digit in Column Name Select if you want to allow column names to begin with a digit. Otherwise, every column name that starts with a digit will have the letter 'C' prefixed, i.e. 'C123'.
Skip Empty Rows Select this checkbox to avoid adding empty rows to the dataset.

 

Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling,

retry, and update options, see Adding a DataSet Using a Data Connector.

Troubleshooting

Data is parsed incorrectly, such as having more rows or columns than expected.

Ensure any literal quote character in a field's data is escaped to avoid it being parsed as one of the quote characters that enclose the field. A quote character can be escaped by the following ways:

  1. Using backslash ( \ ): "dimensions", "two-by-four: 2\" x 4\""
  2. Using the quote character twice: "dimensions", "two-by-four: 2"" x 4"""

Related articles

Comments

0 comments

Please sign in to leave a comment.