Stored Procedures
ストアドプロシージャはファンクションライクなインターフェースで、JSON の単純なSELECT 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにJSON から関連するレスポンスデータを返します。
CData Power BI Connector for JSON Stored Procedures
| Name | Description |
| CreateSchema | Generates a schema file that defines the structure of a JSON table, including field names and data types. |
| DeleteFile | Deletes a specified JSON file from local storage or a connected cloud service. |
| DownloadFile | Downloads a JSON file from a local directory or remote storage location to the specified path. |
| GetOAuthAccessToken | Obtains the OAuth access token to be used for authentication with data sources using OAuth. |
| GetOAuthAuthorizationURL | Obtains the OAuth authorization URL used for authentication with data sources using OAuth. |
| ListFiles | Lists all available JSON files within a specified local or cloud-based directory, including file names and paths. |
| RefreshOAuthAccessToken | Exchanges a refresh token for a new access token. |
| UploadFile | Uploads a JSON file from a local directory to the specified destination, such as cloud or remote storage. |