ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Bullhorn CRM の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにBullhorn CRM から関連するレスポンスデータを返します。
CData SSIS Components for Bullhorn CRM ストアドプロシージャ
| Name | Description |
| CreateSchema | Generates a schema file for a specified table or view. This stored procedure supports development and documentation workflows by exporting the structural definition of an entity. |
| DownloadFile | Downloads a file that is attached to a specified entity. This stored procedure supports document management by retrieving attachments that users need to review or archive. |
| GetOAuthAccessToken | Gets an authentication token from BullhornCRM. |
| GetOAuthAuthorizationURL | Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the OAuthAccessToken from this URL. |
| RefreshOAuthAccessToken | Use this procedure to refresh the access token. |
| UploadFile | Uploads a file to a specified entity. This stored procedure supports documentation workflows by allowing users to add attachments that enhance record completeness or compliance. |