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 |
| Attach | Links a specified attachment (for example, 'document', 'image') to an existing NetSuite record for easy reference. |
| AttachRelationship | Associates a contact with an existing NetSuite record, establishing a relationship link. |
| CheckJobStatus | Retrieves the current status (for example, 'pending', 'completed', 'failed') of a specified NetSuite job process. |
| CreateRestletSchema | Generates and stores the schema definition for a specified NetSuite RESTlet, facilitating API integration. |
| CreateSavedSearchSchema | Generates and saves the schema for a specified NetSuite Saved Search, enabling structured data queries. |
| CreateSchema | Produces a schema file outlining the structure of the specified table or view, supporting data analysis and integration. |
| Detach | Removes a previously attached file (for example, 'image', 'document') from the specified NetSuite record. |
| DetachRelationship | Removes an established relationship, such as a contact association, from a specified NetSuite record. |
| DownloadFile | Fetches and downloads files stored in NetSuite for local access or backup. |
| GetExtraColumnInfo | Provides detailed metadata about specific table columns, including properties not available through standard queries. |
| GetExtraTableInfo | Returns comprehensive metadata about specified tables, including additional attributes beyond standard table definitions. |
| GetJobResults | Retrieves detailed output and results from an executed NetSuite job or batch process. |
| 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. |
| GetRoles | Returns a list of NetSuite user roles associated with the credentials specified in the connection string. The User and Password connection properties are required. |
| InitializeVendorBill | Prepares a new NetSuite Vendor Bill record by populating required fields, facilitating further transaction processing. |
| SubmitSoapRequest | Generates and stores table schema based on NetSuite Simple Object Access Protocol (SOAP) requests, aiding in data structure understanding. |
| UploadFile | Uploads files (for example, 'documents', 'media') to NetSuite, enabling storage and sharing within the platform. |