Differences

This shows you the differences between two versions of the page.

--- bw:bizweaver_multiselect_trigger [2019/12/13 11:37]
runger
+++ bw:bizweaver_multiselect_trigger [2020/04/28 15:23] (current)
runger
@@ Line 19: / Line 19: @@
 EXECUTE [dbo].[spCallBizweaverWS]
 @wsMethod='POST'
--- add your URL.  Be sure to use http or https as appropriate.
+-- add your URL.  Be sure to use http:// or https:// as appropriate.
-,@wsURL='https:<YourURL>'
+,@wsURL='https://<YourURL>'
-,@wsContent='application/json'
+,@wsContent ='application/json'
 -- Add your Auth Token from Bizweaver
-,@wsAuthToken='<YourBizweaverToken>'
+,@wsAuthToken ='<YourBizweaverToken>'
 -- Add your workflow ID from Bizweaver
-,@wsTaskId='<YourWorkflowID>'
+,@wsTaskId = <YourWorkflowID>
-,@wsStartAfter=''
+,@wsStartAfter = 0
-,@wsParameters= @Arguments
+,@wsParameters = @Arguments
 -- Add your port number
-,@wsPort='<YourPort>'
+,@wsPort = <YourPort>
 END
 </code>
+If your are calling Bizweaver without any parameters the @Arguments value will look like this:
+SET @Arguments = '{}'
+<WRAP center round tip 80%>
+Be aware that when you call Bizweaver using this method the target table of the Versago multi-select report is locked until the workflow completes.  This means that to get records for processing you will need to use the "with (NOLOCK)" modifier in any SELECT statement that reads the target table.  It also means that you cannot write directly back to the target table if needed.  In this case you may need to write the results from the processing to another table that can be linked to the original target table for reporting purposed.
+</WRAP>
+----
 The following video illustrates this process.

Wiki

User Tools

Site Tools

Differences

Page Tools