topic Qlik SMTP Connector File Attachment in Connectivity & Data Prep

Qlik SMTP Connector File Attachment

dollar_sign_expansion — Sat, 09 Dec 2023 16:49:56 GMT

I have successfully setup an SMTP connection to outlook.com using the built-in connectors (and not the stand-alone Qlik Web Connectors

How do I use the attach file feature, and what is the syntax format?

LIB CONNECT TO 'SMTP_(test@outlok.com';

LOAD
status AS [SendEmail.status],
result AS [SendEmail.result];

SELECT
status,
result
FROM SendEmail
WITH PROPERTIES (
to='test@test.com',
subject='Test',
message='test',
html='true',
fromName='',
fromEmail='',
cc='',
bcc='',
);

https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Data-Source-Connectors/Notification-Connector.htm

Re: Qlik SMTP Connector File Attachment

TcnCunha_M — Tue, 19 Dec 2023 11:14:42 GMT

add this information:
fileAttachment[1-5]=[your local file path]

For example:

SELECT
status,
result
FROM SendEmail
WITH PROPERTIES (
to='test@test.com',
subject='Test',
message='test',
html='true',
fromName='',
fromEmail='',
cc='',
bcc='',

fileAttachment[1] = 'PATH'
);

Re: Qlik SMTP Connector File Attachment

steeefan — Wed, 20 Dec 2023 11:08:02 GMT

That can probably only read from an already created data connection, i.e. the path should point to a library: fileAttachment[1] = '[lib://00 Files/abc.xlsx]'

Re: Qlik SMTP Connector File Attachment

dollar_sign_expansion — Wed, 20 Dec 2023 11:22:22 GMT

I have tried this but I get an error @TcnCunha_M @steeefan

The following error occurred:
Connector reply error: Could not parse SELECT statement.

Syntax error, expected: =

The error occurred here:

fileAttachment[1] = '[lib://Files/test.txt]'

Re: Qlik SMTP Connector File Attachment

steeefan — Wed, 20 Dec 2023 13:15:16 GMT

Is your screenshot about "Attaching files" from this page? If so, that is probably not the integrated SMTP connector shown in your other screenshot. On that page it says: "This connector must be installed separately."

If I take a look at the config page of the SMTP connector from the Qlik Web Connectors package, I can see a "File Attachment" option. This leads me to believe that it might not be possible with the integrated connector just yet.

Re: Qlik SMTP Connector File Attachment

steeefan — Wed, 20 Dec 2023 14:15:41 GMT

Putting fileAttachment1='lib://00 Files/test.txt' sends an email but also does not attach the specified file. I also tried without "1", with the lib path enclosed in "[]" etc. - no attachment.