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
To execute a SELECT query and receives its results as a comma-separated values (CSV) file, use an Execute query command.
Properties
| Property |
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. |
| JDBC driver version |
Select the NetSuite JDBC driver to use. |
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
To retrieve the details of a table—including its columns, primary keys, and foreign keys—as JSON, use a Get table definition command.
Properties
| Property |
Detail |
| Table |
Enter the table whose definition is to be retrieved. |
| JDBC driver version |
Select the NetSuite JDBC driver to use. |
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 |