Updategram Schemas

You can use updategrams to execute data manipulation commands and validate responses. You can use updategram schemas as templates for generating updategrams.

Generate an Updategram

The examples in this section show templates and the generated instances for inserts, updates, and deletes. You can generate your own schemas using the Schema Wizard in a BizTalk Server project in Visual Studio.

Execute an Updategram

Only send ports can execute updategrams. The examples in this section are of a solicit-response send port that has been configured to use the NetSuite adapter. See the Adapter Configuration section in BizTalk for more information on executing commands using send ports and receive locations.

Updategram Structure

Updategrams and updategram schemas have a declarative structure: A before block specifies the columns to update. An after block specifies how the data will change. The updategram schema maps to the types contained in the result of the command. The updategram instance maps to the values specified in the command.