Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector 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 Tableau Connector 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. |