Wiki

Scale Your Enterprise

User Tools

Site Tools


bw:call_bizweaver_from_sql

Differences

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

Link to this comparison view

Next revision
Previous revision
bw:call_bizweaver_from_sql [2019/10/17 11:59]
runger created
bw:call_bizweaver_from_sql [2020/07/23 11:14] (current)
runger [Procedure Variables]
Line 11: Line 11:
   * You can also test what type of transaction has been posted (Add, Update, etc.).   * You can also test what type of transaction has been posted (Add, Update, etc.).
  
-The Bizweaver call can be made using either POST or GET **POST is preferred** as it provides authentication that is not provided using GET. +The Bizweaver call can only be made using POST transaction.
 =====Procedure Variables===== =====Procedure Variables=====
  
Line 39: Line 38:
  
   * //@wsAuthToken// is the web service token defined in **//[[bw:bizweaver_general_settings|Bizweaver General Settings]]//**.   * //@wsAuthToken// is the web service token defined in **//[[bw:bizweaver_general_settings|Bizweaver General Settings]]//**.
-    * This value is left "blank" when using GET. 
  
   * //@wsTaskId// is the ID number of the Bizweaver workflow being called.   * //@wsTaskId// is the ID number of the Bizweaver workflow being called.
Line 77: Line 75:
 </code> </code>
  
-=====Calling Bizweaver Using GET==== 
- 
-<code sql> 
- 
--- 
--- Code to call workflow 
--- 
-IF @object_type = 'X' 
-BEGIN 
-set @Arguments = '{YourTargetVariable:''' + @list_of_cols_val_tab_del + '''}' 
--- 
-EXECUTE [dbo].[spCallBizweaverWS] 
-@wsMethod='GET' 
- 
--- add your URL.  Be sure to use http or https as appropriate. 
- 
-,@wsURL='https://YourURL' 
- 
-,@wsContent='application/json' 
- 
-,@wsAuthToken='' 
- 
--- Add your workflow ID from Bizweaver 
- 
-,@wsTaskId='999' 
- 
-,@wsStartAfter='' 
- 
-,@wsParameters= @Arguments 
- 
--- Add your port number 
- 
-,@wsPort='443' 
-END 
-</code> 
  
bw/call_bizweaver_from_sql.1571327951.txt.gz · Last modified: 2019/10/17 11:59 by runger