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

Both sides previous revision Previous revision
Next revision
Previous revision
bw:call_bizweaver_from_sql [2020/07/23 11:13]
runger [Calling Bizweaver from SAP Business One]
bw:call_bizweaver_from_sql [2020/07/23 11:14] (current)
runger [Procedure Variables]
Line 38: 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 76: 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.1595517209.txt.gz · Last modified: 2020/07/23 11:13 by runger