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

Output Columns

Input Columns

Examples

SSIS

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

API Source

API Source - 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

Delete table row

Required Parameters
TableName	Fill-in the parameter...
SysId	Fill-in the parameter...
Optional Parameters
RawOutputDataRowTemplate	{}
EnableRawOutputModeSingleRow	True
ContineOn404Error	True

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 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]

Delete

Required Parameters
TableName	Fill-in the parameter...
SysId	Fill-in the parameter...
Optional Parameters
RawOutputDataRowTemplate	{}
EnableRawOutputModeSingleRow	True
ContineOn404Error	True

ODBC application

Use these SQL queries in your ODBC application data source:

Delete table row

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

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 [dynamic_table_name]
WHERE sys_id = ''abcd-1234-sysid''
WITH
(
    "TableName" = ''abcd-1234-tablename''
)';

EXEC (@MyQuery) AT [LS_TO_SERVICENOW_IN_GATEWAY];