insertMultiple

  • Release version: Xanadu
  • Updated August 1, 2024
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of insertMultiple

    The insertMultiple function allows for the creation of multiple new records in a specified table within ServiceNow. Users can insert up to 200 records in a single operation, with the option to gradually increase this limit based on instance performance.

    Show full answer Show less

    Key Features

    • Input Fields: The insertMultiple element can include multiple record tags, each containing relevant fields from the target table, excluding system fields.
    • Output Fields: The insertMultipleResponse returns details such as sysid, display value, and status of each inserted record, including additional information for import set and multiple transforms.
    • SOAP Message Examples: Provides sample SOAP requests and corresponding responses for both regular and import set tables, illustrating how to structure requests and interpret responses.

    Key Outcomes

    By utilizing the insertMultiple function, ServiceNow customers can efficiently create several records at once, enhancing data entry processes and improving productivity. The detailed response structure helps users track the status of each record and troubleshoot any errors that may arise during the insertion process.

    Creates multiple new records for the table targeted in the URL.

    Input fields

    The insertMultiple element may contain 1 or more record tags that contains all fields from the targeted table, excluding system fields. Limit the number of records inserted in a single operation to no more than 200. You can gradually increase this number with subsequent exports if the increase does not negatively impact instance performance.

    Output fields

    The insertMultipleResponse tag is followed by 1 or more record tags that contains:

    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:

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:inc="http://www.service-now.com/incident">
   <soapenv:Header/>
   <soapenv:Body>
      <inc:insertMultiple>
         <record>
            <short_description>this is test 1</short_description>
         </record>
         <record>
            <short_description>this is test 2</short_description>
         </record>
         <record>
            <short_description>this is test 3</short_description>
         </record>
      </inc:insertMultiple>
   </soapenv:Body>
</soapenv:Envelope>

    The resulting response looks like this:

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:inc="http://www.service-now.com/incident">
   <soapenv:Header/>
   <soapenv:Body>
      <insertMultipleResponse>
         <insertResponse>
            <sys_id>168160ad4a36231200a89091281dc803</sys_id>
            <number>INC0055180</number>
         </insertResponse>
         <insertResponse>
            <sys_id>1681622e4a36231200a8909115e5c388</sys_id>
            <number>INC0055181</number>
         </insertResponse>
         <insertResponse>
            <sys_id>1681626e4a36231200a89091fa3c0aa8</sys_id>
            <number>INC0055182</number>
         </insertResponse>
      </insertMultipleResponse>
   </soapenv:Body>
</soapenv:Envelope>

    Sample SOAP messages for an import set table

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

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:imp="http://www.service-now.com/imp_notification">
   <soapenv:Header/>
   <soapenv:Body>
      <imp:insertMultiple>:-->
         <imp:record>
            <imp:message>one</imp:message>
            <imp:uuid>a</imp:uuid>
         </imp:record>
         <imp:record>
            <imp:message>two</imp:message>
            <imp:uuid>b</imp:uuid>
         </imp:record>
         <imp:record>
            <imp:message>three</imp:message>
            <imp:uuid>c</imp:uuid>
         </imp:record>
      </imp:insertMultiple>
   </soapenv:Body>
</soapenv:Envelope>

    The resulting response looks like this:

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:imp="http://www.service-now.com/imp_notification">
   <soapenv:Header/>
   <soapenv:Body>
      <insertMultipleResponse>
         <insertResponse>
            <sys_id>1296b3ab0a0a0b5b73e966fbfab7acde</sys_id>
            <table>incident</table>
            <display_name>number</display_name>
            <display_value>INC0010033</display_value>
            <status>ignored</status>
            <status_message>No field values changed</status_message>
         </insertResponse>
         <insertResponse>
            <sys_id>1296b48e0a0a0b5b62513bb5974a7d96</sys_id>
            <table>incident</table>
            <display_name>number</display_name>
            <display_value>INC0010034</display_value>
            <status>ignored</status>
            <status_message>No field values changed</status_message>
         </insertResponse>
         <insertResponse>
            <sys_id>1296b58b0a0a0b5b468f534659538b9a</sys_id>
            <table>incident</table>
            <display_name>number</display_name>
            <display_value>INC0010035</display_value>
            <status>ignored</status>
            <status_message>No field values changed</status_message>
         </insertResponse>
      </insertMultipleResponse>
   </soapenv:Body>
</soapenv:Envelope>