Help Desk

Submit a ticket My Tickets
Welcome
Login

NetSuite JDBC Command Reference

Connector to NetSuite via JDBC and SQL

Connections

NetSuite JDBC

The connector to NetSuite via JDBC and SQL.

Inputs

Input Type Detail Notes
Username TextField The username to authenticate with.
Password TextField The password to authenticate with.
Connection URL TextField The connection url. (e.g jdbc:ns://{Server Host}:{Server Port};ServerDataSource={Server Data Source};encrypted=1;Ciphersuites={Cipher Suite};CustomProperties=(AccountID={Account Id};RoleID={Role Id}))

Commands

Execute Query

Execute a SELECT query and receive the results as a CSV.

Inputs

Input Type Detail Notes
SQL Text/File TextField The SQL text or file to execute
Delimiter DropdownField The delimiter to use for the CSV file output.
Preview Results BooleanField Check this if you would like to see a preview of the returned rows.

Outputs

Output Output Type Notes
Record Count Integer
Result Set (CSV) File
SQL Error Json

Exit Codes

Code Type Detail
0 Success Success
1 Error Invalid inputs were given
3 Error Failed to run the command

Get Table Definition

Retrieve the details of a table including the columns, primary keys and foreign keys in a JSON format

Inputs

Input Type Detail Notes
Table TextField The table of which to retrieve the definition

Outputs

Output Output Type Notes
Table Metadata File
SQL Error Json

Exit Codes

Code Type Detail
0 Success Success
1 Error Invalid inputs were given
3 Error Failed to run the command
B
Brian is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.