ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、NetSuite の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにNetSuite から関連するレスポンスデータを返します。

CData ODBC Driver for NetSuite ストアドプロシージャ


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.