How to trigger automation job only when there is data in table

Question

I have made an automation which sends email of a visualization . Now i want to trigger email only when there is data in that visualization . Is it possible to do so if yes and then please let me know.

Answer 1

There is a way in which this is possible but it's fairly convoluted.

1. Create an Automation job file which has the 'Open analysis from Library' step (link)
2. Schedule it however you/your organization usually schedule Spotfire automations. Here's how to schedule it using Windows Task Scheduler: link
3. Once you have this set up, create an IronPython script within Spotfire which checks the underlying datatable: data check
4. If data exists, send email: HTML email
5. Since you're working with a visualization, you might have to google a bit to modify the code to export the image and then create a MIMEImage object which will then be sent with the email.