SQL Server and NetSuite SOAP integration

Do everything in one place

Customize your SQL Server and NetSuite SOAP integration with the following triggers and actions.

Triggers

When this happens…

SQL Server

New row
New row in a table in SQL Server
New rows Batch
New batch of rows in a table in SQL Server
New rows via custom SQL Batch
New batch of rows via custom SQL in SQL Server
Scheduled query Batch
Scheduled query using custom SQL in SQL Server
New/updated row
New/updated row in a table in SQL Server
New/updated rows Batch
New/updated batch of rows in a table in SQL Server
New/updated rows via custom SQL Batch
New/updated batch of rows via custom SQL in SQL Server

Any other trigger you can think up

NetSuite SOAP

Export new standard records
Export new standard records in Netsuite
Export new custom records
Export new custom records in Netsuite
Export new/updated custom records
Export new/updated custom records in Netsuite
Deleted standard record
Deleted standard record in NetSuite
New classification record
New classification record in NetSuite
New classification records Batch
New classification records in NetSuite
New classification records in a saved search
New classification saved search result for record in NetSuite
New custom record
New custom record in NetSuite
New custom records Batch
New custom records in NetSuite
New custom records in a saved search
New search result for object in NetSuite
New standard record
New standard record in NetSuite
New standard records Batch
New standard records in NetSuite
New standard records in a saved search
New search result for record in NetSuite
New/updated custom record
New or updated custom record in NetSuite
New/updated custom records Batch
New or updated custom records in NetSuite
New/updated custom records in a saved search
New or updated search result for object in NetSuite
New/updated standard record
New or updated standard record in NetSuite
New/updated standard records Batch
New or updated standard records in NetSuite
Export new/updated standard records
Export new/updated standard records in Netsuite
New/updated standard records in a saved search
New or updated search result for record in NetSuite

Any other trigger you can think up

Actions

Do this…

SQL Server

Bulk load from an on-prem file
Bulk load rows into a table in SQL Server from an on-prem file
Delete rows Batch
Delete rows in a table in SQL Server
Execute stored procedure Batch
Execute stored procedure in SQL Server
Export query result
Export query result as a CSV file in SQL Server
Insert row
Insert row in a table in SQL Server
Insert rows Batch
Insert batch of rows in a table in SQL Server
Replicate schema
Replicate table schema in SQL Server
Run custom SQL Batch
Run custom SQL in SQL Server
Run long query using custom SQL
Run long query using custom SQL in SQL Server
Select rows Batch
Select rows in a table in SQL Server
Select rows using custom SQL Batch
Select rows using custom SQL in SQL Server
Replicate rows Batch
Replicate batch of rows to table in SQL Server
Get table schema
Get table schema for SQL Server
Update rows
Update rows in a table in SQL Server
Update rows Batch
Update batch of rows in a table in SQL Server
Upsert row
Upsert row in a table in SQL Server
Upsert rows Batch
Upsert batch of rows in a table in SQL Server

Any other action you can think up

NetSuite SOAP

Custom action
Custom action in NetSuite SOAP (Custom)
Create custom records in batch Batch
Create custom records in batch in Netsuite
Create custom records in bulk Batch
Create records in bulk in Netsuite
Create custom record
Create custom record in NetSuite
Create standard record
Create standard record in NetSuite
Create standard records in batch Batch
Create standard records in batch in Netsuite
Create standard records in bulk Batch
Create records in bulk in Netsuite
Attach contact to record
Attach contact to record in NetSuite
Attach file to record
Attach file to record in NetSuite
Delete custom record
Delete custom record by ID in NetSuite
Delete standard record
Delete standard record by ID in NetSuite
Execute saved search for custom record Batch
Execute saved search for custom record in NetSuite
Execute saved search for record Batch
Execute saved search for record in NetSuite
Execute SuiteQL query Batch
Execute SuiteQL query in NetSuite
Get all standard records Batch
Get all standard records in NetSuite
Get case comments Batch
Get case comments in NetSuite
Get object schema for custom record
Get object schema for a record in NetSuite
Get file by ID
Get file by ID in NetSuite
Get posting transaction summary
Get posting transaction summary in NetSuite
Get object schema for standard record
Get object schema for a record in NetSuite
Search custom records Batch
Search custom record in NetSuite
Search standard records Batch
Search standard records in NetSuite
Update custom records in batch Batch
Update custom records in batch in Netsuite
Update custom records in bulk Batch
Update records in bulk in Netsuite
Update custom record
Update custom record in NetSuite
Update standard record
Update standard record in NetSuite
Update standard records in batch Batch
Update standard records in batch in Netsuite
Update standard records in bulk Batch
Update records in bulk in Netsuite
Upsert custom records in batch Batch
Upsert custom records in batch in Netsuite
Upsert custom records in bulk Batch
Upsert records in bulk in Netsuite
Upsert custom record
Upsert custom record in NetSuite
Upsert standard record
Upsert standard record in NetSuite
Upsert standard records in batch Batch
Upsert standard records in batch in Netsuite
Upsert standard records in bulk Batch
Upsert records in bulk in Netsuite