This shows you the differences between two versions of the page.
| 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 | + | The Bizweaver call can only be made using a POST transaction. |
| =====Procedure Variables===== | =====Procedure Variables===== | ||
| Line 39: | Line 38: | ||
| * // | * // | ||
| - | * This value is left " | ||
| * // | * // | ||
| Line 77: | Line 75: | ||
| </ | </ | ||
| - | =====Calling Bizweaver Using GET==== | ||
| - | |||
| - | <code sql> | ||
| - | |||
| - | -- | ||
| - | -- Code to call workflow | ||
| - | -- | ||
| - | IF @object_type = ' | ||
| - | BEGIN | ||
| - | set @Arguments = ' | ||
| - | -- | ||
| - | EXECUTE [dbo].[spCallBizweaverWS] | ||
| - | @wsMethod=' | ||
| - | |||
| - | -- add your URL. Be sure to use http or https as appropriate. | ||
| - | |||
| - | , | ||
| - | |||
| - | , | ||
| - | |||
| - | , | ||
| - | |||
| - | -- Add your workflow ID from Bizweaver | ||
| - | |||
| - | , | ||
| - | |||
| - | , | ||
| - | |||
| - | , | ||
| - | |||
| - | -- Add your port number | ||
| - | |||
| - | , | ||
| - | END | ||
| - | </ | ||