Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with NetSuite.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from NetSuite, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for NetSuite Stored Procedures
| Name | Description |
| CreateSchema | Produces a schema file outlining the structure of the specified table or view, supporting data analysis and integration. |
| GetOAuthAccessToken | Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to NetSuite. |
| GetOAuthAuthorizationURL | Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process. |
| RefreshOAuthAccessToken | Refreshes an expired OAuth Access Token to maintain continuous authenticated access to NetSuite resources without requiring reauthorization from the user.. |
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with NetSuite.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from NetSuite, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for NetSuite Stored Procedures
| Name | Description |
| CreateSchema | Produces a schema file outlining the structure of the specified table or view, supporting data analysis and integration. |
| GetOAuthAccessToken | Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to NetSuite. |
| GetOAuthAuthorizationURL | Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process. |
| RefreshOAuthAccessToken | Refreshes an expired OAuth Access Token to maintain continuous authenticated access to NetSuite resources without requiring reauthorization from the user.. |