Creates a new record for the table targeted in the URL.

Input fields

All fields from the targeted table, excluding system fields. Fields configured as mandatory in the System Dictionary are reflected in the WSDL with the attribute minOccurs=1.

Output fields

Table 1. Insert method output fields
Table type Output fields
Regular The sys_id field and the display value of the target table (table) are returned.
Import set

The sys_id of the import set row, the name of the transformed target table (table), the display_name for the transformed target table, the display_value of the transformed target row, and a status field, which can contain inserted, updated, or error.

There can be an optional status_message field or an error_message field value when status=error.

When an insert did not cause a target row to be transformed (skipped because a key value is not specified), the sys_id field will contain the sys_id of the import set row, rather than the targeted transform table.

Import set with multiple transforms The response from this type of insert will contain multiple sets of fields from the regular import set table insert wrapped in a multiInsertResponse parent element. Each set will contain a map field, showing which transform map created the response.

Sample SOAP messages for a regular table

The following example shows an insert that specifies the short description only:

<?xml version="1.0" encoding="ISO-8859-1"?>
<SOAP-ENV:Envelope xmlns:tns="" 
  xmlns:xsi="" xmlns:xsd="" 
        <insert xmlns="">
            <short_description xsi:type="xsd:string">This is a test</short_description>

The resulting response looks like this:

<?xml version="1.0" encoding="ISO-8859-1"?>
<SOAP-ENV:Envelope SOAP-ENV:encodingStyle="" 
  xmlns:tns="" xmlns:xsd="" 
        <insertResponse xmlns="">

Language-specific sample messages

For language-specific insert samples, refer to the following topics:

Perl SOAP::Lite

Java Apache Axis2

Microsoft .NET