This is an old revision of the document!
Create the trigger on the table where records are saved by your Versago multi-select report.
Values in <YourValue> are specific to your installation and need to be changed accordingly. The < and > symbols are removed when the desired value is entered.
CREATE TRIGGER [dbo].[twbs_tr_<TriggerName>] ON [dbo].[<TableName] AFTER INSERT AS DECLARE @vgo_Batchid nvarchar(8), @arguments nvarchar(100) --- SELECT @vgo_BatchID = vgo_BatchID FROM inserted BEGIN -- SET @Arguments = '{"vgo_BatchID":' + '"' + @vgo_BatchID + '"' + '}' -- EXECUTE [dbo].[spCallBizweaverWS] @wsMethod='POST' -- add your URL. Be sure to use http or https as appropriate. ,@wsURL='https:<YourURL>' ,@wsContent='application/json' -- Add your Auth Token from Bizweaver ,@wsAuthToken='<YourBizweaverToken>' -- Add your workflow ID from Bizweaver ,@wsTaskId='<YourWorkflowID>' ,@wsStartAfter='' ,@wsParameters= @Arguments -- Add your port number ,@wsPort='<YourPort>' END
The following video illustrates this process.
.