Workflows · From Tasks · from_imap

Purpose

Imports data from attachments of emails. Supports only IMAP accounts.

Method of use

Before you can scrape attachments from emails you have to give Workflows access.

Configuration

Example usage

extract:
    conn_id: imap
    folder: INBOX
    filter:
        subject: TEST FILE 3000 LINES COMPRESSION = NONE

Properties

propertytyperequireddescription
conn_idstringnoDefault is imap. Connection string as handed to you by the Onesecondbefore team.
folderstringnoDefault is INBOX. But can be any folder in your email account.
filterobjectnoPlease refer to properties of filter object below.

Properties of filter object

If you use filtering (see above) in the extract. You have to add an object every time with the fields below.

propertytyperequireddescription
fromstringnoInclude email if substring matches the from field.
tostringnoInclude email if substring matches the to field.
subjectstringnoInclude email if substring matches the subject field.

Details

itemdescription
Pre-formatted schemaNo. This from task does not come with a pre-formatted schema. Define file and it is required to define the schema if you use Snowflake. BigQuery can auto-detect the source file.