Start a new topic
Discussions xDM xDM - Model and Application Design
Answered

Is it possible to start a workflow from SQL?

Is it possible to start a workflow from SQL?


Our need is as follows:

 A record from a repository is created from a web service directly in Semarchy (no workflow for this step).


Based on the data in the table, some users need to perform an update and be notified.

Ideally, our solution would start a workflow and notify the relevant users, if everything is triggered with a scheduled SQL it would be great.



NB If this isn't possible, we will have to use an external tool to verify the data and send an email to the users.

Best Answer

Hello Jean-Christophe,


It is not possible to launch a workflow through SQL.

But it is doable via REST API.
Thanks to the native endpoint "Start workflow instance(s)", that you can find document in your REST API module:

3 CommentsSorted by Oldest First
Answer

Hello Jean-Christophe,


It is not possible to launch a workflow through SQL.

But it is doable via REST API.
Thanks to the native endpoint "Start workflow instance(s)", that you can find document in your REST API module:

Hello Alexia, OK I will have a look Thanks


Hello Jean-Christophe,

Sure, you're welcome.

Login to post a comment
More topics in xDM - Model and Application Design
See all 346 topics
Help Desk Software by Freshdesk