Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
(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
hi
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);
hi
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);
Hi Liron,
Thanks for your quick respond. But variables are not working for To and Since. I am getting an error.
"Unknown Error"
maybe you need to write the variable
like this '$(vSince)'
there shouldn't be a problem i done this several times