Applies to

Bridge by Smartsheet

ServiceNow module reference

PLANS

  • Bridge by Smartsheet

ServiceNow triggers

After integrating Bridge with ServiceNow, choose the events to trigger a workflow. 

Event type

  • When Records Are Created
  • When Records Are Updated
  • When Records Are Deleted

You can tailor triggers to specific search criteria using the ServiceNow filter query language.

To tailor triggers in the Bridge ServiceNow workflow builder

  • In the Encoded Filter field on the ServiceNow Trigger screen, enter the query you copied from ServiceNow.

Create New Record

This module lets you create a new record in an existing table in ServiceNow.

Create New Record fields

You can use data references in all these fields:

  • Table Name: In this field, enter the name of the table where you need to create a record.
  • Key #1: In this field, enter the field name of the record you need to update.
  • Value #1: In this field, enter the field value of the record you need to update.

What you'll see in the Run Log pane

Once Bridge executes the Create New Record module in a workflow, the following information will appear in the Run Log pane:

  • Data
  • State: Refer to this section to check if the module worked.
    • Code: This is the success/error code that the module pulls from Smartsheet.
    • Message: This is a system-generated message that the module pulls from Smartsheet. 
      • For example, if the module couldn’t find a value, the message that will appear is “Not found.”
    • Status: This is the status that the module pulls from Smartsheet. 
      • These are examples of status labels you might encounter:
        • Succeeded: The module successfully found the information.
        • Failed: The module didn’t find the information.

Delete Record

This module lets you delete a record in ServiceNow.

Delete Record fields

You can use data references in all these fields:

  • Table Name: In this field, enter the name of the table where you need to create a record.
  • Record Sys ID: In this field, enter the sys_id value automatically assigned to the record at the point of creation.

What you'll see in the Run Log pane

Once Bridge executes the Delete Record module in a workflow, the following information will appear in the Run Log pane:

  • Data
  • State: Refer to this section to check if the module worked.
    • Code: This is the success/error code that the module pulls from Smartsheet.
    • Message: This is a system-generated message that the module pulls from Smartsheet.
      • For example, if the module couldn’t find a value, the message that will appear is “Not found.”
    • Status: This is the status that the module pulls from Smartsheet. 
      • These are examples of status labels you might encounter:
        • Succeeded: The module successfully found the information.
        • Failed: The module didn’t find the information.

Get Group

This module is a group of actions that allows you to build for multiple potential outcomes.

Get Group fields

You can use the following fields for the following fields, except Name

  • Filter Field: A list of fields you can select from
    • Sys_ID: Unique identifier of the user record
    • Name: The name of the user 
    • Group: The name of the group

Set up the Get Group module

  1. In the Filter Field, select either sys_ID or Name.
    • Name: Type a unique name for the module. 
    • Sys-ID: Type the unique identifier for the user record.
  2. After setting up the module, build the workflow and identify the potential outcomes for it.

Use potential outcomes to guide your workflow building. These are the potential outcomes for the Get Group module:

  • Group found: The module found the group with the specified name.
  • No Group found: The module didn’t find the group with the specified name.

Continue building the workflow 

  1. In the left pane, go to the Pinned Items
  2. Then, drag a New State module to the dotted rectangular space for the path you want to follow. 
  3. In the State field, enter a name. 

What you'll see in the Run Log pane

Once Bridge executes the Get Group module, the following information will be available in the Run Log pane:

  • Data
  • State: Refer to this section to check if the module worked.
    • Code: This is the success/error code that the module returns from Smartsheet.
    • Message: This is a system-generated message that the module pulls from Smartsheet.
      • For example, if the module couldn’t find a value, the message that will appear is “Not found.”
    • Status: This is the status that the module pulls from Smartsheet. 
      • These are examples of status labels you might encounter:
        • Succeeded: The module successfully found the information. 
        • Failed: The module didn’t find the information.

Get Record

This module functions as a group of states and a junction. It works like the Get Group module and has three potential outcomes: 

  • Record found: The module found the record. 
  • No record found: The module didn’t find the record in the specific table. 
  • No table found: The module didn’t find the specific table.

Get Record fields

The following fields are appear in the Get Group module:

  • Name: This is where you assign a name to a module after dragging it to your workflow. 
    You can't use data references in this field.
  • Table Name: In this field, enter the name of the table containing the record you need. 
  • Record Sys ID: In this field, enter the sys_id value of the record you need to find.

What you'll see in the Run Log pane

Once Bridge executes the Get Group module, the following information will be available in the Run Log pane: 

  • Data
  • State: Refer to this section to check if the module worked. 
    • Code: This is the success/error code that the module returns from Smartsheet.
    • Message: This is a system-generated message that the module pulls from Smartsheet. 
      • For example, if the module couldn’t find a value, the message that will appear is “Not found.”
    • Status: This is the status that the module pulls from Smartsheet. 
      • These are examples of status labels you might encounter:
        • Succeeded: The system successfully found the information. 
        • Failed: The module didn’t find the information.

Get Records

This returns all records from a table and lets you filter its results. 

Get Records fields

You can use data references in all these fields:

  • Table Name: In this field, enter the name of the table containing the records you need.
  • Filters
    • Encoded Filter: In this field, paste the query you copied from ServiceNow.
    • Record Offset: In this field, enter the starting record index from which the module should begin finding records.
    • Results Per Page: In this field, enter the maximum number of records you need the module to return. If records exceed that number, the module will separate them into pages. Each page will hold records amounting to the number you stated in this field.

What you'll see in the Run Log pane

Once Bridge executes the Get Group module, the following information will appear in the Run Log pane: 

  • Data
  • State: Refer to this section to check if the module worked.
    • Code: This is the success/error code that the module returns from Smartsheet.
    • Message: This is a system-generated message that the module pulls from Smartsheet. 
      • For example, if the module couldn’t find a value, the message that will appear is “Not found.”
    • Status: This is the status that the module pulls from Smartsheet. 
      • These are examples of status labels you might encounter: 
        • Succeeded: The module successfully found the information.
        • Failed: The module didn’t find the information.

Get User

This module functions the same way as the Get Group and Get Record modules, and has two potential outcomes: 

  • User found: The module didn’t find a user.
  • No user found: The module didn’t find a user with the specified email address or full name.

​​​​​​

Get User fields

You can use data references in these fields except Name:

  • Name: Module name you provide after you drag the module into your workflow
  • Filter Field: A list of fields you can select from
    • Sys_ID: Unique identifier of the user record
    • User Email Address or Full Name: The user’s email address or full name

Set up the Get User module

  1. In the Name field, type a unique name for the module.
  2. In the Filter Field, select either of these options:
    • Sys-ID: Type the unique identifier for the user record. 
    • User Email Address Or Full Name: In this field, enter the user’s email address or name.

What you'll see in the Run Log pane

Once Bridge executes the Get User module in a workflow, the following information will be available in the Run Log pane: 

  • Data
  • State: Refer to this section to check if the module worked.
    • Code: This is the success/error code that the module returns from Smartsheet.
    • Message: This is a system-generated message that the module pulls from Smartsheet. 
      • For example, if the module couldn’t find a value, the message that will appear is “Not found.”
    • Status: This is the status that the module pulls from Smartsheet. 
      • These are examples of status labels you might encounter:
        • Succeeded: The module successfully found the information.
        • Failed: The module didn’t find the information.

Update Record

This module lets you update a record in ServiceNow.

Update Record fields

You can use data references in all these fields:

  • Table Name: This is the name of the table where the module can find the record you need.
  • Record Sys ID: In this field, enter the sys_id value of the record you need to update.
  • Key #1: In this field, enter the field name of the record you need to update.
  • Value #1: In this field, enter the field value of the record you need to update.

What you'll see in the Run Log pane

Once Bridge executes the Update Record module in a workflow, the following information will be available in the Run Log pane:

  • Data
  • State: Refer to this section to check if the module worked.
    • Code: This is the success/error code that the module returns from Smartsheet.
    • Message: This is a system-generated message that the module pulls from Smartsheet. 
      • For example, if the module couldn’t find a value, the message that will appear is “Not found.”
    • Status: This is the status that the module pulls from Smartsheet. 
      • These are examples of status labels you might encounter:
        • Succeeded: The module successfully found the information.
        • Failed: The module didn’t find the information.
Was this article helpful?
YesNo