To perform structured query language (SQL) operations in the NetSuite® system as part of a chain, add a step with a NetSuite JDBC connection command.
To enable these commands, an IT admin first creates a NetSuite JDBC connector.
Execute Query
Executes a SELECT
query, and receives the results as a comma-separated values (CSV) file
Inputs
Input |
Detail |
SQL Text/File |
Enter the SQL text or file to execute |
Delimiter |
Select the delimiter to use in the CSV output |
Preview Results |
To see a preview of the returned row, check this box |
Outputs
Output |
Output Type |
Record Count |
Integer |
Result Set (CSV) |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid inputs |
3 |
Error |
Failed to run the command |
Get Table Definition
Retrieves the details of a table—including its columns, primary keys, and foreign keys—as JSON
Inputs
Input |
Detail |
Table |
Enter the table to retrieve the definition of |
Outputs
Output |
Output Type |
Table Metadata |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid inputs were given |
3 |
Error |
Failed to run the command |