I need to build an application that combines an on-line database with workflow, so that workflow can control the timing and sequencing of information that is entered into the database.  I also need to be able to generate emails in my workflow app which extracts information from Zoho and sends the results (in other words, I cannot generate the email from Zoho based on the "events" that are available to me).  I have been working with RunMyProcess, and although that appears to do what I need from a workflow standpoint, the integration (I believe) is somewhat lacking. 

 

It appears to me that the API to "read" Zoho information is at the "form" level only, which means that if I want to join several tables together in my outbound email from RunMyProcess that I have to do all of the data manipulation in RunMyProcess (i.e. read the parent, find the children, build a process to loop through the children, build the  relationships from the child to the lookup tables, etc.).  This is a lot of work -- and would be much better suited to doing that in the database application.  If RunMyProcess could read a "view" in addition to a "form," I believe that that would make my work in RunMyProcess MUCH SIMPLER!

 

Please advise if this perceived limitation is in fact true (that RunMyProcess cannot read a view).  If so, do you have any other suggestions on how I may accomplish what I am looking to do?

 

Thank You!