ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、ServiceNow の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにServiceNow から関連するレスポンスデータを返します。

CData SSIS Components for ServiceNow ストアドプロシージャ


Name	Description
AddToCart	Adds the specified item to the cart of the current user.
CreateRecord	Inserts the specified record into the target table in ServiceNow.
CreateSchema	Creates a schema file for the specified table or view. It you specify 'Location' connection property, the schema file will be created in the directory it addresses.
DeleteRecord	Deletes the specified record into the target table in ServiceNow.
DownloadAttachment	Download a file attachment from a specific record.
GetOAuthAccessToken	Gets the OAuth access token from ServiceNow.
GetOAuthAuthorizationURL	Gets the Service Now authorization URL. Access the URL returned in the output in a Web browser. This requests the access token that can be used as part of the connection string to Service Now.
GetRecord	Retrieves the specified record of the target table in ServiceNow.
GetTableSchema	Creates a JSONSchema of the target table in ServiceNow.
RefreshOAuthAccessToken	Refreshes the OAuth access token used for authentication with various ServiceNow services.
SubmitOrder	Checks out the user cart, based on the current check-out type (one-step or two-step).
UpdateRecord	Updates the specified record into the target table in ServiceNow.
UploadAttachment	Upload a file as an attachment to a specified record.