Official |[ServiceNow] Export

Operation name

Export

Function overview

By using "HULFT Square Connector for ServiceNow" with ServiceNow, outputs data from the target table that is registered to the table list of "HULFT Square Connector for ServiceNow".

Note

For the table to export, set the Read 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.
Table name	Required	Available	Select the name of the target table to read.	When you enter characters, the registered target table in the table list of HULFT Square Connector for ServiceNow that matches that prefix is displayed.
name-value pairs	Optional	Available	Filter the records to obtain by column names and values. You can operate the filtered contents with the following buttons: Up Moves the selected column name and value upward by one row. Down Moves the selected column name and value downward by one row. Add Adds a column name and value. Delete Removes the column name and value.
sysparm_fields	Optional	Available	If you specify column names by separating with a comma (","), only the specified column names are obtained.
sysparm_limit	Optional	Available	If you enter a numerical value, only the specified number of records is obtained.	You can enter a value of "1" or more.
sysparm_offset	Optional	Available	If you enter a numerical value, the records after that record are obtained.	You can enter a value of "0" or more.

Property actions

Item name	Description	Remarks
Get Table name from Destination	Obtain the table names from the database and set them for Table name.	Enabled when Destination is selected.
Set output schema with Table	Set the output schema by using the table.	Enabled when a value is entered in 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 exportApi, updataSchemaApi, and getTableListsApi.
exportApi	Optional	Available	Enter the API to use in the Export operation. 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).
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

None.

Output schema

This is automatically obtained with Set output schema with Table.

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
count	The number of records exported from ServiceNow is stored.
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