Table of Contents

Connections

Commands

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

Did this answer your question?