Reference

Table Tables

Description

No description available

Supported Operations

Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.
Method Supported Reference EndPoint
SELECT get_tables
INSERT
UPDATE
UPSERT
DELETE
LOOKUP

Examples

SSIS

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

Read from Tables table using 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
Tables
There are no parameters to configure.
SSIS API Source - Read from table or endpoint

Read/write to Tables table using API Destination

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
Tables
Select
There are no parameters to configure.
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get a list of tables 

SELECT * FROM Tables

SQL Server

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

Get a list of tables 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Tables';

EXEC (@MyQuery) AT [LS_TO_SERVICENOW_IN_GATEWAY];