BizTalk Adapter for NetSuite

Build 20.0.7606

SQL Command Schemas

SQL command schemas allow you to retrieve and update NetSuite data in BizTalk through an SQL interface. For example, you can execute a parameterized query when a message is received, with the message containing the input parameter values.

Executing SQL Statements

The following sections show example requests, responses, and schemas for the appropriate ports.

SELECT Command Schemas

You can execute SELECT commands by generating SELECT Command Schemas for both receive locations and solicit-response send ports.

INSERT Command Schemas

You can execute INSERT statements by generating INSERT Command Schemas for send ports.

UPDATE Command Schemas

You can execute UPDATE statements by generating UPDATE Command Schemas for send ports.

DELETE Command Schemas

You can execute DELETE statements by generating DELETE Command Schemas for send ports.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7606