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.
For mailboxes that use the POP3 email protocol, see Mailbox POP3.
Supported offerings
- QlikView
This connector must be installed separately.
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 and the port number for the mailbox you want to connect to, along with your username and password.
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:
- Enter imap.gmail.com in the server field.
- Set the port number to 993.
- Select Use SSL.
- Enter your username and password.
Microsoft Exchange
From privately administered Exchange servers:
-
Enable IMAP4 from your exchange server.
From Office 365 or Microsoft Exchange accounts:
-
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
| Table | Description |
|---|---|
| ImapFolder | Use this table to fetch the names and the message count of the folders in your mailbox. |
| ImapMessagesInFolder | Use this table to fetch the messages and details from a mailbox folder. The table returns message IDs which are required for other tables. |
| ImapMessageHeaders |
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. |
| ImapMessageDownloadAttachment |
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. |
Troubleshooting
You 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 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.
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.