Executing Workflow From External Script?

💬 General Discussion
1

I have a workflow that has a condition based on case fields. I would guess that if I set it to run on the scheduler it would tax the MySQL database quite a bit as it would first have to check all the cases to see which ones have successfully met the conditions (it has repeated runs disabled) to exclude those from checking the conditions, then check the conditions on all the remaining cases. That’s a lot of cases (a few thousand).

Ideally, I’d like to trigger the workflow the same as if it was set to run ‘On Save’ but trigger it from a script outside the CRM by passing a workflow id and a case id.

Basically I have an external program that is directly modifying one of the case fields in that database that is associated with one of the workflow conditions.

Would the only way to achieve it is to use the REST API to modify the case record and THAT would trigger the workflow the same as a user modifying the case record from within the CRM?

2

Yes, you can do it via REST API. and another way is you create an entry point and in that entry point trigger the Save function with appropriate ID and bean so it will trigger workflow too.

3

if want to implement that method follow this link How to Insert & Update & select record Using SugarBean - Dev Answers & Best Practices - DevClub - SugarClub . create the entry point first and then use bean function.