Skip to main content

servicenow_tables

Creates, updates, deletes, gets or lists a servicenow_tables resource.

Overview

Nameservicenow_tables
TypeResource
Idpagerduty.enrichment.servicenow_tables

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
createinsertintegration_id, cmdb_tableAdds a new ServiceNow CMDB table configuration to an existing integration. An integration may contain at most 8 tables. New tables are created with status: disabled; enable synchronization separately once the configuration has been validated.<br /><br /><!-- theme: warning --><br /><br />> ### Early Access<br />> This API is in Early Access and may change at any time. Contact your PagerDuty account team to request access.<br /><br />Scoped OAuth requires: contextual_data.write<br />
updateupdateintegration_id, table_id, cmdb_tableReplaces a ServiceNow CMDB table configuration. This is a full replacement — all fields, including ci_table_name and the complete field_mappings list, must be provided. A table can only be updated while its synchronization is disabled and before its initial backfill has started.<br /><br /><!-- theme: warning --><br /><br />> ### Early Access<br />> This API is in Early Access and may change at any time. Contact your PagerDuty account team to request access.<br /><br />Scoped OAuth requires: contextual_data.write<br />
deletedeleteintegration_id, table_idRemoves a ServiceNow CMDB table configuration from an integration. The table's generated enrichment schema is removed and its data synchronization is disabled.<br /><br /><!-- theme: warning --><br /><br />> ### Early Access<br />> This API is in Early Access and may change at any time. Contact your PagerDuty account team to request access.<br /><br />Scoped OAuth requires: contextual_data.write<br />
enableexecintegration_id, table_idEnables data synchronization for a ServiceNow CMDB table configuration. Once enabled, the table's enrichment schema is populated with CI data from ServiceNow and kept up to date with periodic syncs. This operation is idempotent — enabling an already-enabled table succeeds.<br /><br /><!-- theme: warning --><br /><br />> ### Early Access<br />> This API is in Early Access and may change at any time. Contact your PagerDuty account team to request access.<br /><br />Scoped OAuth requires: contextual_data.write<br />
testexecintegration_id, table_idValidates a ServiceNow CMDB table configuration by running a live query against ServiceNow and returning up to 10 sample records. Use this before enabling synchronization to confirm that the credentials, table name, query filter, and mapped fields are correct. Records are returned keyed by ServiceNow field name.<br /><br /><!-- theme: warning --><br /><br />> ### Early Access<br />> This API is in Early Access and may change at any time. Contact your PagerDuty account team to request access.<br /><br />Scoped OAuth requires: contextual_data.read<br />

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
integration_idstringBase32-encoded UUID v7 (26 uppercase alphanumeric characters) identifying the ServiceNow enrichment integration.
table_idstringBase32-encoded UUID v7 (26 uppercase alphanumeric characters) identifying the CMDB table configuration.

INSERT examples

Adds a new ServiceNow CMDB table configuration to an existing integration. An integration may contain at most 8 tables. New tables are created with status: disabled; enable synchronization separately once the configuration has been validated.<br /><br /><!-- theme: warning --><br /><br />> ### Early Access<br />> This API is in Early Access and may change at any time. Contact your PagerDuty account team to request access.<br /><br />Scoped OAuth requires: contextual_data.write<br />

INSERT INTO pagerduty.enrichment.servicenow_tables (
cmdb_table,
integration_id
)
SELECT
'{{ cmdb_table }}' /* required */,
'{{ integration_id }}'
RETURNING
cmdb_table
;

UPDATE examples

Replaces a ServiceNow CMDB table configuration. This is a full replacement — all fields, including ci_table_name and the complete field_mappings list, must be provided. A table can only be updated while its synchronization is disabled and before its initial backfill has started.<br /><br /><!-- theme: warning --><br /><br />> ### Early Access<br />> This API is in Early Access and may change at any time. Contact your PagerDuty account team to request access.<br /><br />Scoped OAuth requires: contextual_data.write<br />

UPDATE pagerduty.enrichment.servicenow_tables
SET
cmdb_table = '{{ cmdb_table }}'
WHERE
integration_id = '{{ integration_id }}' --required
AND table_id = '{{ table_id }}' --required
AND cmdb_table = '{{ cmdb_table }}' --required
RETURNING
cmdb_table;

DELETE examples

Removes a ServiceNow CMDB table configuration from an integration. The table's generated enrichment schema is removed and its data synchronization is disabled.<br /><br /><!-- theme: warning --><br /><br />> ### Early Access<br />> This API is in Early Access and may change at any time. Contact your PagerDuty account team to request access.<br /><br />Scoped OAuth requires: contextual_data.write<br />

DELETE FROM pagerduty.enrichment.servicenow_tables
WHERE integration_id = '{{ integration_id }}' --required
AND table_id = '{{ table_id }}' --required
;

Lifecycle Methods

Enables data synchronization for a ServiceNow CMDB table configuration. Once enabled, the table's enrichment schema is populated with CI data from ServiceNow and kept up to date with periodic syncs. This operation is idempotent — enabling an already-enabled table succeeds.<br /><br /><!-- theme: warning --><br /><br />> ### Early Access<br />> This API is in Early Access and may change at any time. Contact your PagerDuty account team to request access.<br /><br />Scoped OAuth requires: contextual_data.write<br />

EXEC pagerduty.enrichment.servicenow_tables.enable
@integration_id='{{ integration_id }}' --required,
@table_id='{{ table_id }}' --required
;