Differences

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

--- bizweaver:exec_sql [2024/09/09 14:30]
dlee [Create Control Procedure]
+++ bizweaver:exec_sql [2024/09/09 14:35] (current)
dlee [Create Control Procedure]
@@ Line 68: / Line 68: @@
   * @wsTaskId: workflow id
   * @wsStartAfter: 0
-  * @wsParameters: arguments must be passed using label:value pairs enclosed in double quotes
+  * @wsParameters: arguments must be passed using label:value pairs enclosed in double quotes and brackets
     * Example: the variable name in the Bizweaver workflow is vgo_BatchID (case sensitive)
     <code sql>
@@ Line 79: / Line 79: @@
 <code sql>
-set @Arguments = '{"YourTargetVariable":' + '"' + @list_of_cols_val_tab_del + '"' + '}'
+DECLARE @Arguments NVARCHAR(MAX)
+SET @Arguments = '{"YourTargetVariable":' + '"' + @list_of_cols_val_tab_del + '"' + '}'
 EXECUTE [dbo].[spCallBizweaverWS]
-@wsMethod='POST'
+    @wsMethod='POST'
+    ,@wsURL='https://YourURL'
--- add your URL.  Be sure to use http or https as appropriate.
+    ,@wsPort='443'
+    ,@wsContent='application/json'
-,@wsURL='https://YourURL'
+    ,@wsAuthToken='xyxyxyxyxyxyxyxyx'
+    ,@wsTaskId='999'
-,@wsContent='application/json'
+    ,@wsStartAfter='0'
+    ,@wsParameters= @Arguments
--- Add your Auth Token from Bizweaver
-,@wsAuthToken='xyxyxyxyxyxyxyxyx'
--- Add your workflow ID from Bizweaver
-,@wsTaskId='999'
-  ,@wsStartAfter=''
-,@wsParameters= @Arguments
--- Add your port number
-  ,@wsPort='443'
 END
 </code>

Wiki