ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Backlog の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにBacklog から関連するレスポンスデータを返します。
CData Excel Add-In for Backlog ストアドプロシージャ
| Name | Description |
| AddStar | Adds star. |
| AttachFileToWiki | Attaches file to Wiki. |
| DownloadFile | Download a specified document. |
| DownloadIssueAttachment | Downloads issue's attachment file. |
| DownloadProjectIcon | Download project icon. |
| DownloadPullRequestAttachment | Downloads attached files on pull requests. |
| DownloadSharedFile | Download a specified shared file. |
| DownloadSpaceLogo | Download a specified document. |
| DownloadWikiPageAttachment | Downloads Wiki page's attachment file. |
| GetOAuthAccessToken | Gets an authentication token from Backlog. |
| 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. |
| GetOwnUser | Returns own information about user. |
| LinkSharedFilesToWiki | Links Shared Files to Wiki. |
| MarkWatchingAsRead | Mark a watching as read. |
| PostAttachmentFile | Posts an attachment file for issue or wiki. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with Backlog. |
| RemoveProjectIssueType | Delete the Project Issue Type. |
| RemoveProjectStatus | Delete the Project Status. |
| RemoveSharedFileFromWiki | Removes link to shared file from Wiki. |
| UpdatePullRequestCommentInformation | Updates pull request comment information.Authenticated user can update his own comments. |
| UpdateSpaceNotification | Updates space notification. |