A dynamic link library (SQLWSCall.dll) provided by Third Wave Business Systems is required for this functionality to work. The file is installed in C:\Program Files\Bizweaver\BWPortal\BWSQLSP when Bizweaver is installed.

Execute the following SQL statements against the Master database

sp_configure 'show advanced options', 1 
GO  
RECONFIGURE 
GO  
sp_configure 'clr enabled', 1
GO  
RECONFIGURE 
GO
 
-- Create Asymmetric Key using DLL.
CREATE ASYMMETRIC KEY [bwws]
AUTHORIZATION [dbo]
-- Source DLL file must be located in C:\Program Files\Bizweaver\BWPortal\BWSQLSP, or path changed below
FROM EXECUTABLE FILE = 'C:\Program Files\Bizweaver\BWPortal\BWSQLSP\SQLWSCall.dll'
-- Create login
CREATE LOGIN TWBS
FROM ASYMMETRIC KEY [bwws]
-- Modify login
GRANT UNSAFE ASSEMBLY TO TWBS

Create an Assembly in the calling database

• In MS SQL Management Studio, expand the folder tree for the database.
• Expand the “Programmability” folder.
• Right-click on “Assemblies”; select “New Assembly”.

• Browse to folder where the SQLWSCall.dll is located and select it.
• The Assembly Name and Assembly Owner are set automatically.
• Select “External Access” from the drop-down for “Permission Set”.
• Click [OK] to register the assembly.

Create the following stored procedure in the calling database.

CREATE PROCEDURE [dbo].[spCallBizweaverWS]
@wsMethod NVARCHAR (MAX), 
@wsUrl NVARCHAR (MAX),
@wsPort NVARCHAR (MAX),
@wsContent NVARCHAR (MAX),
@wsAuthToken NVARCHAR (MAX),
@wsTaskId INT,
@wsStartAfter INT,
@wsParameters NVARCHAR (MAX)
AS EXTERNAL NAME [SQLWSCall].[StoredProcedures].[spCallBizweaverWS]

• @wsMethod: should be set to POST
• @wsUrl: URL of the BW Web Service. HTTPS://yourURL/
  • Use HTTP: or HTTPS: as appropriate for your installation.

• @wsAuthToken is the web service token defined in 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.

SET @Arguments = '{"YourTargetVariable":' + '"' + @list_of_cols_val_tab_del + '"' + '}'
EXECUTE [dbo].[spCallBizweaverWS]
@wsMethod='POST'
 
-- add your URL.  Be sure to use http or https as appropriate.
 
,@wsURL='https://YourURL'
 
,@wsContent='application/json'
 
-- 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

Home