Good day Jimmy11

May you please check the following out?

“Triggering a new workflow based on status change”: https://community.k2.com/t5/General/Triggering-a-new-workflow-based-on-status-change/m-p/108928,

“Making Document and Content Extraction Easy with K2, UiPath, and Azure AI”: https://www.k2.com/blog/document-extraction-with-k2-uipath-azure,

“K2 Cloud + UI Path”: https://community.k2.com/t5/K2-Cloud/K2-Cloud-UI-Path/m-p/113498#M383.

Best,

Sunrise

Hello  @Jimmy11 ,

Start workflow

https://docs.uipath.com/integrations/docs/start-workflow

Start workflow from SQL Server or using SSIS

https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/Start-workflow-from-SQL-Server-or-using-SSIS/td-p/96716

Initiate Workflow With Smartobject

https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/Initiate-Workflow-With-Smartobject/m-p/81358#M24110

Good day Jimmy11,

Perhaps if you could try the following:

1. Open up management.

2. Go to Integration > Service instances.

3. Click on the "Add" button and name your service instance.

4. Select your service type, Authentication mode, Database Name and click "OK".

5. Click on the Newley created service type and select the "Generate SmartObjects" button.

6. choose the table applicable and click the "OK" button.

These steps will generate a smart object and place it in a new category in your designer under "All Items".

From there you can use the smart object in designer to generate a form that will Kickstart your workflow.

Kind regards,

Dumisani

Hi Jim,

Another option here, using indirect methods, is to use a scheduled K2 workflow to periodically poll the Azure SQL Database and then initiate a workflow for items that match a certain pattern or condition.  This method also works for on-premise SQL environments, or really any data source.

For example: 
You can create a workflow schedule (K2 Management > Workflow > Schedules) that runs a specific workflow to scan the SQL table every 15 minutes and start the job for items that have been modified. 

This works as long as there is a field that we can use to detect that the item is relevant (ex. Status column = 'New') and something we can change it to after it runs (ex. Status column = 'Processed'). 

Note:  If you want to use a different interval, that can be of course be configured within the schedule itself.

Schedule:
The scheduling allows you to run the trigger workflow on a set interval that you can control and monitor.

Hi Jimmy11

Go through this article below, i believe it will help you to get a solution of your issue

https://help.k2.com/kb002027

Regards

Elvis