How to Include Failed App Name(s) in Automation Email

[Kelliesy]

Hoping someone can help because I have spent way to long trying to figure this out.  I asked the question before on here and got a great answer but , even implementing their suggestions, I cannot figure out what I am doing wrong.  I have an automation (see attached).  

My first loop is getting a list of all apps where the title has "Hourly" and then refreshing them.  This is the only way I found to do all refreshes in the same loop.  

Then I get Implode the Reload Ids and loop through that list to get the list of ones where the status was NOT succeed.  Then I say if the filter is list is not empty send an email.  

I have added in "Get App Info" but every time I get an error.  I have added it to before the "Wait for Reloads.." but out side the loop, After the "Filter List" loop and after the "Condition" but before the email.  All of these have failed. I have validated the App ID being passed is correct also.  I have also validated that I can run the Get App Info for an app successfully on it's own.  

I've set up the Reload an app and notify your team on Slack but changed it to email and for that one reload activity it works just fine.  Any suggestions?, Assistance?

[marksouzacosta · Accepted solution]

Hi @Kelliesy,

I believe you are trying to do something like this:

Full diagram:

The top part, no changes. Pretty much what you have done. You could replace the List Apps + Condition blocks with the Raw API Request block, just to short your blocks a little.

The bottom part is where I made the changes.
First, you should loop the Reload IDs you have captured:

Get the Reload Record - to check the Status and the App associated to the Reload:

Checking the Reload Status equals FAILED:

Get App Information:

Then you can use all this information to send emails, Teams messages, etc:

Regards,

Mark Costa

[PrashantSangle]

Just a curious,

Why don't you just use "Reload Analyzer App" > "Failed Reload Sheet" > set alert > according to your need.

🤔

Regards,

Prashant Sangle

[Kelliesy]

I could but I was trying to keep the reloads and the notifications all in the same place.  Seems more organized.  

[Kelliesy]

This worked!  Thank you so much for that.  

Do you think doing what Prashant suggested makes more sense than building this failure notification into my automation?

[marksouzacosta]

Hi @Kelliesy,

I think it depends on how fast you should respond to the problems and the most popular communication channel in your team (highest visibility).

Qlik Cloud have native Qlik mobile app notifications, website notifications and emails - you can do that per Space (Space Details > Notifications) or per User (go to your Profile on the top right of Qlik Cloud):

And you also have @PrashantSangle suggestion.

Automations are fine but I'll use it if I'm looking for a communication method not covered by any of those above.

Regards,

Mark Costa