Official |[ServiceNow] Import multiple

Operation name

Import multiple

Function overview

By using "HULFT Square Connector for ServiceNow" with ServiceNow, imports the data to the Source Table that is registered to the table list of "HULFT Square Connector for ServiceNow".

Note

For the table to import data, set the Write permission in the table list of HULFT Square Connector for ServiceNow to "true".

Data model

The data model of this component is table model type.

Properties

= Remarks =

For details on use of variables, refer to Variables.

Basic settings

Item name	Required/Optional	Use of variables	Description	Remarks
Name	Required	Not available	Enter a name that is used on the script canvas.

Required settings

Item name	Required/Optional	Use of variables	Description	Remarks
Destination	Required	Not available	Select a connection resource. Add A new connection resource can be added. Edit list Connection resource settings can be edited in > HULFT INTEGRATE > Connections.
Staging Table name	Required	Available	Select the name of the staging table to read.	When you enter characters, the registered Source Table in the table list of HULFT Square Connector for ServiceNow that matches that prefix is displayed.

Item name

Required/Optional

Use of variables

Description

Remarks

Destination

Required

Not available

Select a connection resource.

Add: A new connection resource can be added.
Edit list: Connection resource settings can be edited in > HULFT INTEGRATE > Connections.

Staging Table name

Required

Available

Select the name of the staging table to read.

When you enter characters, the registered Source Table in the table list of HULFT Square Connector for ServiceNow that matches that prefix is displayed.

Property actions

Item name	Description	Remarks
Get Staging Table name from Destination	Obtain the table names from the database and set them for Staging Table name.	Enabled when Destination is selected.
Set input schema with Staging Table	Set the input schema by using the staging table.	Enabled when a value is entered in Staging Table name.

Change Api

Item name	Required/Optional	Use of variables	Description	Remarks
Automatic or Manual	Required	Not available	If you want to manually enter the URI to switch the API version of the used ServiceNow, select Manual. Automatic Use the latest API version of ServiceNow. Manual Appropriate values can be set in importMultipleApi, updateSchemaApi, and getTableListsApi.
importMultipleApi	Optional	Available	Enter the API to use in the Import multiple operation. Make sure to enter a value in {stagingTableName}.	For details about the input method, refer to "POST /now/import/{stagingTableName}/insertMultiple" of ServiceNow (https://developer.servicenow.com/dev.do#!/reference/api/rome/rest/c_ImportSetAPI#import-POST-insertMultiple?navFilter=now/import).
updateSchemaApi	Optional	Available	Enter the API to obtain Mapper. Make sure to enter a value in {TableName}.	For details about the input method, refer to "GET /now/table/{tableName}" of ServiceNow (https://developer.servicenow.com/dev.do#!/reference/api/rome/rest/c_TableAPI#table-GET).
getTableListsApi	Optional	Available	Enter the API to obtain the list of table names from the table list. Make sure to enter a value in {x_sisl_testapp_for_tablelist}.	For details about the input method, refer to "GET /now/table/{tableName}" of ServiceNow (https://developer.servicenow.com/dev.do#!/reference/api/rome/rest/c_TableAPI#table-GET).

Comment

Item name	Required/Optional	Use of variables	Description	Remarks
Comment	Optional	Not available	You can write a short description of this connector.

Schemas

Input schema

This is automatically obtained with Set input schema with Staging Table.

Output schema

None.

Mass data processing

Mass data processing isn't supported.

Transaction

Transaction isn't supported.

Parallel Stream Processing

PSP isn't supported.

Available component variables

Component variable name	Description	Remarks
message_category	When an error occurs, the category of the message code corresponding to the error is stored.	The default value is null.
message_code	When an error occurs, the code of the message code corresponding to the error is stored.	The default value is null.
message_level	When an error occurs, the severity of the message code corresponding to the error is stored.	The default value is null.
error_type	When an error occurs, the error type is stored.	The default value is null. The format of the error type is as follows. Example: "java.io.FileNotFoundException" Depending on the version of HULFT Square, the stored contents may change.
error_message	When an error occurs, the error message is stored.	The default value is null. Depending on the version of HULFT Square, the stored contents may change.
error_trace	When an error occurs, the trace information for the error is stored.	The default value is null. Depending on the version of HULFT Square, the stored contents may change.

Message codes, exception messages, and limitations

Connector	Message code	Exception message	Limitations
Messages and limitations of the ServiceNow connector		None