Endpoint Update a Table Row

Name

update_table_row

Description

Insert a row into the table. [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 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 update 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]

Update

Required Parameters
TableName	Fill-in the parameter...
SysId	Fill-in the parameter...
Optional Parameters
ContineOn404Error	True

ODBC application

Use these SQL queries in your ODBC application data source:

Update an incident

UPDATE incident
SET cause = 'A bug in the software'
   ,severity = 3
   ,incident_state = 2
WHERE sys_id = 'SYS_ID_GOES_HERE'

SQL Server

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

Update an incident

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE incident
SET cause = ''A bug in the software''
   ,severity = 3
   ,incident_state = 2
WHERE sys_id = ''SYS_ID_GOES_HERE''';

EXEC (@MyQuery) AT [LS_TO_SERVICENOW_IN_GATEWAY];