bw:bizweaver_multiselect_trigger

This is an old revision of the document!


Trigger Configuration for Versago Multi-Select Report Processing

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.

Trigger.txt
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.

.

bw/bizweaver_multiselect_trigger.1576255071.txt.gz · Last modified: 2019/12/13 11:37 by runger