Discussion board where members can get started with Qlik Sense.
So I got through the first part of setting up the connector and sending a test email.
Now I want to add to my load script the code needed to shoot off an email to me if the task is not successful.
I have the sample code that is not specific to any event. This came from the YouTube video.
LIB CONNECT TO 'Send Email Alerts';
LET vMsg = 'Sent at ' & Now();
FROM CSV (header on, delimiter ",", quote """") "CSV_source"
QUERY "to" "email@example.com"
,QUERY "cc" "firstname.lastname@example.org"
,QUERY "subject" "$(vMsg)"
,QUERY "message" "Yippie"
,QUERY "fromName" "noreply"
,QUERY "fromEmail" "Qlik@dunbarmored.com"
,QUERY "forate" "csv"
LOAD [status] AS [status],
[result] AS [result],
[filesattached] AS [filesattached]
DROP TABLE RestConnectorMasterTable;
I suspect that I can use the above code but need to put a loop or something in and also check for an error level. But I am not sure what to do next.
Check out using the Log4Net appenders
Thanks. Do you need to do anything other than create the xml file under the service you want to monitor? Obviously you need to modify the domain and email addresses. But anything else?
You'd have to make sure you have an SMTP server and appropriate credentials and the smtp port is not blocked, but no other set up in Qlik is needed
I already went through all of the SMTP stuff and that seems to be working.
If I want to be notified anytime a task has an error where do I need to put this xml file?