executing a sql update statement from workflow
is it possible to execute a sql update statement in a workflow, or use rest put or post functions in a workflow. I see the sql query to get data from a rest site, what about putting or setting results back to a database or rest site with a workflow?
I am looking to be able to edit data with workflow manager.
J
-
I would also like to know how to do this.
Per the REST Elements Administrator Guide, you can use custom activities which can do this. However, it would be nice to see some samples on this subject and how to import and use custom activities within the Geocortex Workflow designer.
0 -
Microsoft has created some out-of-the-box activities to communicate with databases through ADO.
http://wf.codeplex.com/releases/view/43585
Our workflow infrastructure works seamlessly with any Microsoft Workflow Foundation 4 activities. All you need to do is drop a dll containing activities in the root folder of the workflow designer (for example C:\Program Files (x86)\Latitude Geographics\Geocortex Essentials\Default\Workflow Designer) and drop the same dll in the root of the Essentials REST installation (for example C:\Program Files (x86)\Latitude Geographics\Geocortex Essentials\Default\REST Elements\REST\bin).
The reason you need it in both places is that one is for the design time of workflows and the other one is for the runtime of workflows.
Hope this helps,
Christian.
0 -
Just as an FYI for anyone who comes across this thread, Jonathan and I tried configuring this. Unfortunately, there is a bug in the activities such that information is lost about assigning the query results when the workflow is saved. It's still in Beta 1, which is over 2 years old. Unfortunately, it appears it's still frozen- not even half-baked /customer/servlet/servlet.FileDownload?file=00P6000000e88CAEAY
Back to the drawing board...
Dave
0
Du måste logga in om du vill lämna en kommentar.
Kommentarer
3 kommentarer