Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace:
bizweaver:exec_sql

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
bizweaver:exec_sql [2024/09/09 14:09]
dlee 		bizweaver:exec_sql [2024/09/09 14:35] (current)
dlee [Create Control Procedure]
Line 61: Line 61:
 </code> </code>
  
-  * @wsMethod: should be set to POST +  * @wsMethod: POST 
-  * @wsUrl: URL of the BW Web Service. HTTPS://yourURL/ +  * @wsUrl: <nowiki>https://<yourURL>/</nowiki> (Be sure to use http or https as appropriate) 
-    * Use HTTP:// or HTTPS:// as appropriate for your installation.+  * @wsPort: <yourPort> (Typically 443 for https or 8080 for http) 
 +  * @wsContent: 'application/json' 
 +  * @wsAuthToken: token generated in Bizweaver's Settings window 
 +  * @wsTaskId: workflow id 
 +  * @wsStartAfter: 0 
 +  * @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> 
 +    SET @wsParameters = '{"vgo_BatchID":' + '"' + @vgo_BatchID + '"' + '}' 
 +    </code>
  
-  * //@wsAuthToken// is the web service token defined in **//[[bw2:bizweaver_general_settings|Bizweaver General Settings]]//**. 
  
-  * //@wsTaskId// is the ID number of the Bizweaver workflow being called. 
- 
-  * //@wsPort// is the port number used for your Bizweaver web service. 
-    * 443 is the standard for HTTPS installations. 
-    * 80, 8080, 8081, 8090 are examples of ports typically used in HTTP installation. 
  
 =====Calling Bizweaver Using spCallBizweaverWS==== =====Calling Bizweaver Using spCallBizweaverWS====
 <code sql> <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] 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 END
 </code> </code>
bizweaver/exec_sql.1725905379.txt.gz · Last modified: 2024/09/09 14:09 by dlee

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki