Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with MYOB.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from MYOB, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for MYOB Stored Procedures
| Name | Description |
| GetOAuthAccessToken | Gets an authentication token from MYOB. |
| GetOAuthAuthorizationURL | Gets the authorization URL that must be opened separately by the user to grant access to your application. When CompanyFileId is not set, the generated URL requires admin consent to resolve one. GetOAuthAuthorizationURL is only needed when developing Web apps. You can use the authorization code returned from this URL to request an OAuth access token. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with MYOB. |
| UpdateTimesheet | Creates or completely replaces one employee timesheet period. |