Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with SugarCRM.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from SugarCRM, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for SugarCRM Stored Procedures
| Name | Description |
| CreateSchema | Generates a schema definition file for a specified table or view. This stored procedure supports metadata export and integration tooling. |
| DownloadFile | Downloads a file that is stored in SugarCRM document storage. This stored procedure supports integration workflows and external document access. |
| GetOAuthAccessToken | Obtains the OAuth access token to be used for authentication with SugarCRM. |