ServiceNow - New/updated record triggers

New/updated record

This trigger picks up records that are created or updated in the selected table. Each record is processed as a separate job. It checks for new or updated records once every poll interval.

New/updated record trigger

Input fields

Input field	Description
From	Records created or updated after this time will be processed by the recipe. If left blank, the default time will be set to one day before the recipe is first started.
Table	Select a table to pick up new or updated records from.

Output fields

The output datatree of this trigger contains the full set of columns from the selected table. All default and custom columns are supported. The output fields will be displayed only after a table is provided, either by selecting a table from the pick list or by providing the full table name.

Output fields

New/updated record (real-time)

This trigger picks up records in the selected table as soon they are created or updated. Each record is processed as a separate job. It makes use of business rules to detect and trigger a new or updated record event to be processed.

To use this trigger, the connected user must have sufficient access control to sys_script table. Learn how to configure access control for real time triggers.

New/updated record trigger

Input fields

Input field	Description
Table	Select a table to pick up new or updated records from.
Query	ServiceNow query to filter the records you want. Example: active=true^stateIN1,3. If your query contains the operator VALCHANGES, CHANGESFROM, CHANGESTO, you must select Yes to the Disable polling? input field. Learn more (opens new window).
When first started, this recipe should pick up events from	Records created or updated after this time will be processed by the recipe. If left blank, the default time will be set to one day before the recipe is first started. Learn more about this input field.
Disable polling?	Polling allows us to retrospectively pull records from a previous timestamp specified in the When first started, this recipe should pick up events from field. In cases where your Query contains VALCHANGES, CHANGESFROM, CHANGESTO operators, you must disable polling. In all other cases, polling is highly recommended.

Output fields

The output datatree of this trigger contains the full set of columns from the selected table. All default and custom columns are supported. The output fields will be displayed only after a table is provided, either by selecting a table from the pick list or by providing the full table name.

Output fields

Input field definitions

When first started, this recipe should pick up events from

This is a user-defined time that marks the earliest time that the trigger should pick up created or updated records. If left blank, the default time will be set to one day before the recipe is first started.

The Updated (sys_updated_on) column is used to determine the time that a record is created or updated. Only records with Updated (sys_updated_on) timestamp later than the time specified in From will be processed by the trigger.

Updated (sys_updated_on) timestamp

Table

Select the table to process records from. This can be done either by selecting a table from the pick list, or toggling the input field to text mode and typing the full table name.

Make sure that the user used in the connection has sufficient access control to the selected table.