Reference

Endpoint Delete a Table Row


Name

insert_table_row

Description

Insert a row into the table. [API reference]

Related Tables

[Dynamic Table]

Parameters

Parameter Required Options
Name: TableName

Label: TableName

Table name
YES

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
sys_id DT_WSTR nvarchar(64) 64
[$parent.Pivot_Name$] DT_WSTR nvarchar(2000) 2000
If the column you are looking for is missing, consider customizing ServiceNow Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
[$parent.Pivot_Name$] DT_WSTR nvarchar(2000) 2000
Required columns that you need to supply are bolded.

Examples

SSIS

Use ServiceNow Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Destination

This Endpoint belongs to the [Dynamic Table] table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to delete a table row:

API Destination - ServiceNow
Allows the reading and writing of incidents, attachments, and more in ServiceNow without coding! The ZappySys ServiceNow API Connector provides easy-to-use, high-performance API access.
ServiceNow
[Dynamic Table]
Insert
Required Parameters
TableName Fill-in the parameter...
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Create an incident

INSERT INTO incident(incident_state, severity, category, cause)
VALUES (3, 1, 'software', 'Missing a software feature.')

insert_table_row endpoint belongs to [Dynamic Table] table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Create an incident

DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO incident(incident_state, severity, category, cause)
VALUES (3, 1, ''software'', ''Missing a software feature.'')';

EXEC (@MyQuery) AT [LS_TO_SERVICENOW_IN_GATEWAY];

insert_table_row endpoint belongs to [Dynamic Table] table(s), and can therefore be used via those table(s).