topic Re: Incremental Load for Fetching the mails from outlook using mailbox connector in QlikView

Incremental Load for Fetching the mails from outlook using mailbox connector

rishikeshtiwari — Tue, 10 Jan 2017 07:11:35 GMT

Hi Guys,

I am using Qlik-Mailbox connector to extract the emails from outlook. When I am trying to extract it using IMAP (IMAP MESSAGE IN FOLDER) it is asking me the begin date and end date. I am able the export the details also. But in Qlik-Sense Script I am getting these

dates (Start and end) also. If I have a lot of emails I need to extract it in the application using the Incremental load like tables.

So is there any way to load the emails based on incremental data.(Dates are manual in script should be automated).

I am getting the following script::

MailboxConnector_ImapMessagesInFolder:

LOAD

id as ImapMessagesInFolder_id,

UID as ImapMessagesInFolder_UID,

inReplyTo as ImapMessagesInFolder_inReplyTo,

folder as ImapMessagesInFolder_folder,

to as ImapMessagesInFolder_to,

cc as ImapMessagesInFolder_cc,

bcc as ImapMessagesInFolder_bcc,

from as ImapMessagesInFolder_from,

subject as ImapMessagesInFolder_subject,

sent as ImapMessagesInFolder_sent,

text as ImapMessagesInFolder_text,

html as ImapMessagesInFolder_html,

size as ImapMessagesInFolder_size,

flags as ImapMessagesInFolder_flags,

seen as ImapMessagesInFolder_seen,

attachments as ImapMessagesInFolder_attachments,

gmailMessageId as ImapMessagesInFolder_gmailMessageId,

gmailThreadId as ImapMessagesInFolder_gmailThreadId,

gmailLabels as ImapMessagesInFolder_gmailLabels

FROM

[http://localhost:5555/data?connectorID=MailboxConnector&table=ImapMessagesInFolder&Server=imap.outlook.com&Port=993&SSL=True&Username=rishi.singh%40bcone.com&Password=FzNUVPyde6ri5nHl2e%2fdFg%3d%3d&ignoreClientCertificateErrors=True&Folder=INBOX&MaxNoEmails=20&Since=01-01-2017&Before=10-01-2017&appID=]

(qvx);

But I am getting these since and to date as well. So is there any process in which we can pass variables so that we can implement incrementally load for Mail Automation for Future.

Kindly Suggest me if anyone had done it.

Thanks in Advance

Rishi

Re: Incremental Load for Fetching the mails from outlook using mailbox connector

lironbaram — Tue, 10 Jan 2017 08:14:54 GMT

you can define variables in the script and replace the dates in the string with thvariables

something like

let vSince= date(today()-2,'DD-MM-YYYY');

let vTo = date(today(),'DD-MM-YYYY');

MailboxConnector_ImapMessagesInFolder:

LOAD

id as ImapMessagesInFolder_id,

UID as ImapMessagesInFolder_UID,

inReplyTo as ImapMessagesInFolder_inReplyTo,

folder as ImapMessagesInFolder_folder,

to as ImapMessagesInFolder_to,

cc as ImapMessagesInFolder_cc,

bcc as ImapMessagesInFolder_bcc,

from as ImapMessagesInFolder_from,

subject as ImapMessagesInFolder_subject,

sent as ImapMessagesInFolder_sent,

text as ImapMessagesInFolder_text,

html as ImapMessagesInFolder_html,

size as ImapMessagesInFolder_size,

flags as ImapMessagesInFolder_flags,

seen as ImapMessagesInFolder_seen,

attachments as ImapMessagesInFolder_attachments,

gmailMessageId as ImapMessagesInFolder_gmailMessageId,

gmailThreadId as ImapMessagesInFolder_gmailThreadId,

gmailLabels as ImapMessagesInFolder_gmailLabels

FROM

(qvx);

Re: Incremental Load for Fetching the mails from outlook using mailbox connector

rishikeshtiwari — Wed, 11 Jan 2017 07:56:32 GMT

Hi Liron,

Thanks for your quick respond. But variables are not working for To and Since. I am getting an error.

"Unknown Error"

Re: Incremental Load for Fetching the mails from outlook using mailbox connector

lironbaram — Wed, 11 Jan 2017 07:58:59 GMT

maybe you need to write the variable

like this '$(vSince)'

there shouldn't be a problem i done this several times