Hi,
Could you please advise whether a workflow can be automatically actioned using a basic task form when data is inserted into the SQL database, with minimal manual interaction?
The intent is to manage and action tasks directly through the Workspace, without developing a custom form.
We would appreciate confirmation on whether this approach is supported within the existing workflow capabilities.
Thank you for your support.
Best answer by TinTex
Hello,
It is certainly possible to use a basic task form:
And action it via the K2 Workspace site without developing a custom form; ootb it will look like so:
If you want a task to be automatically actioned when data is inserted into a SQL database, you may be able to use of a SQL trigger:
CREATE TRIGGER (Transact-SQL) - SQL Server | Microsoft Learn
that calls back into K2 and action the task via REST:
Workflow REST API: Open and Complete Task
or the SourceCode.Workflow.Client api:
Hello,
It is certainly possible to use a basic task form:
And action it via the K2 Workspace site without developing a custom form; ootb it will look like so:
If you want a task to be automatically actioned when data is inserted into a SQL database, you may be able to use of a SQL trigger:
CREATE TRIGGER (Transact-SQL) - SQL Server | Microsoft Learn
that calls back into K2 and action the task via REST:
Workflow REST API: Open and Complete Task
or the SourceCode.Workflow.Client api:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
