Skip to main content Skip to complementary content

Mailbox IMAP

The Qlik Mailbox IMAP connector lets you fetch emails and email content, such as information about attachments, from any mailbox that uses the IMAP email protocol.

Supported offerings

  • Qlik Sense Business
  • Qlik Sense Enterprise SaaS
  • Qlik Sense Enterprise on Windows
  • Qlik Sense Desktop

Ways to access your data

To access your IMAP mailbox data, you need to authenticate the connector with your mailbox server details. After you create a new connection and select Mailbox IMAP as your data source, you need to enter the server address for the mailbox you want to connect to, along with your username and password.

Creating a data source connection

Configuring email clients

You need to enable IMAP access for your account, through your mailbox client. The configurations for some of the most common email clients are described below.

Gmail

To download email data from Gmail, you must first ensure that IMAP access is enabled in your Gmail settings.

Do the following:

  1. Enter imap.gmail.com in the server field.
  2. Enter your username and password.

Microsoft Exchange

From privately administered Exchange servers

To download data from an exchange server, you must enable IMAP from your exchange server.

Following the Microsoft guidelines for enabling IMAP.

From Office 365 or Microsoft Exchange accounts

To download data from an Office 365 or Exchange account, you must enable IMAP from your exchange account.

From shared Microsoft Exchange mailboxes

To access shared mailboxes that are not associated with a specific user account, use one of the following formats for your username:

  • my@emailaddress.com/sharedmailboxname
  • domain/myusername/sharedmailboxname

Loading data from tables

After you authenticate the connector with your account credentials, use the tables to fetch your data. The table below outlines some of the use cases for some of the tables that are available.

Tables that can be loaded
Table Available in Description
Folder Data manager and Data load editor Use this table to fetch the names and the message count of the folders in your mailbox.
MessagesInFolder Data manager and Data load editor Use this table to fetch the messages and details from a mailbox folder. The table returns message IDs that are required for other tables.
MessageHeaders Data load editor

Use this table to fetch the message headers and header values for a message ID.

The IMAP message ID is the UID value from the MessagesInFolder table.

MessageAttachments Data load editor

Use this table to fetch information about message attachments. You need to specify the message ID and the attachment name.

The IMAP message ID is the UID value from the MessagesInFolder table.

To select and load data from a table, enter the required table parameters and click Preview data. Required parameters are marked with an asterisk (*) in the dialog. The table fields are displayed under the Data preview tab. You can select fields individually by selecting the box beside each field name. Select Insert script after you have made your selection.

Creating a connection and selecting data

Troubleshooting

Your Gmail username and password are not accepted when creating a connection

Possible cause

Your Gmail has 2-factor authentication enabled, which is preventing the Mailbox IMAP connector from establishing a connection using your normal credentials. You will see an error message pointing out that your username and password are invalid.

Proposed action

Create an app-specific password, then use this password to configure your Mailbox IMAP connector.

Google blocks sign-in attempt from the Qlik Web Connectors

Possible cause

Google sometimes blocks third-party apps trying to connect to Gmail through IMAP, even on accounts that do not have 2-factor authentication enabled. You may see an error message pointing out that your username and password are invalid, or that you need to log in from a browser.

Proposed action

Allow less secure apps to connect to your Gmail account through IMAP.

Confirm that the sign-in attempt was requested by you, through your Gmail account. It may take some time for the confirmation to take effect.

You cannot connect to the IMAP server

Possible cause

IMAP access is not enabled.

Proposed action

Verify that the email account you want to connect to has IMAP enabled.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!