Redirect task stdout to script - VisualCron - Forum

Community forum

pkumar
2014-09-23T17:35:18Z
I currently have a SQL task working correctly and outputting a tab-delimited table (with headers) to standard output.
I also have an email task that puts the stdout of the SQL task in the body of the email.

Both of these are great, but I want to format the tab-delimited output into an HTML table.
I know how to do this in Python. I can read a tab-delimited table and output a nice formatted HTML table.

However, I don't see a way to redirect the SQL task's input to my script.
How can I accomplish this?
Support
2014-09-24T07:19:34Z
If your first Task is the SQL Task and you want to redirect (either by writing to a file using the File write Task or user the Execute Task) you should use this Variable to get the output of previous Task:

{TASK(PrevTask|StdOut)}
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
pkumar
2014-09-24T13:23:32Z
Specifically, how do I use {TASK(PrevTask|StdOut)} to redirect the SQL task to the standard input of the Execute task?
Scroll to Top