Endpoint

Delete table row

Name

delete_table_row

Description

Delete the specified row in the table by row 'sys_id'. [API reference]

Related Tables

[Dynamic Table]

Parameters

Parameter	Label	Required	Options	Description
TableName	TableName	YES		Table name
SysId	SysId	YES		Row 'sys_id'

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
status	`DT_WSTR`	`nvarchar(64)`	64	`False`
sys_id	`DT_WSTR`	`nvarchar(64)`	64	`False`
http_status	`DT_I4`	`int`		`False`

If the column you are looking for is missing, consider customizing ServiceNow Connector.

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
sys_id	`DT_WSTR`	`nvarchar(500)`	500	`False`

Required columns that you need to supply are bolded.

Examples

SSIS

Use ServiceNow Connector in API Source component to read data or in API Destination component to read/write data:

Delete rows from [Dynamic Table] table using API Destination

This Endpoint belongs to [Dynamic Table] table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

ServiceNow

[Dynamic Table]

Delete

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Delete table row

SELECT * FROM delete_table_row
WHERE sys_id = 'abcd-1234-sysid'
WITH
(
    "TableName" = 'abcd-1234-tablename'
)

delete_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:

Delete table row

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM delete_table_row
WHERE sys_id = ''abcd-1234-sysid''
WITH
(
    "TableName" = ''abcd-1234-tablename''
)';

EXEC (@MyQuery) AT [LS_TO_SERVICENOW_IN_GATEWAY];

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