ServiceNow - Basic Auth

Version: 3.0.0

Achieve end-to-end transformation for your IT services and infrastructure through a single cloud-based platform. ServiceNow IT Service Management (ITSM) software lets you consolidate fragmented tools and legacy systems while automating service management processes.

Connect ServiceNow with LogicHub

Note: From version 2.0.0 we are supporting "OAuth" authentication mechanism. Please visit here to set up OAuth.

  1. Navigate to Automations > Integrations.
  2. Search for ServiceNow.
  3. Click Details, then the + icon. Enter the required information in the following fields.
    • Label: Enter a connection name.
    • Reference Values: Define variables here to templatize integration connections and actions. For example, you can use https://www.{{hostname}}.com where, hostname is a variable defined in this input. For more information on how to add data, see 'Add Data' Input Type for Integrations.
    • Verify SSL: Select option to verify connecting server's SSL certificate (Default is Verify SSL Certificate).
    • Remote Agent: Run this integration using the LogicHub Remote Agent.
    • URL: URL of the ServiceNow server.
    • Username: Username to log in with.
    • Password: Password to log in with.
    • Client ID*: Client id to log in with.
    • Client Secret*: Client secret to log in with.
  4. After you've entered all the details, click Connect.

📘

Client ID & Client Secret are not required for ServiceNow (Basic Auth) integration.

Actions for ServiceNow

Create Incident Ticket Incident

Creates a ticket with the specified details whenever the parent table has any results.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Short Description Column NameColumn name that contains the short description of the ticket to create.Required
Advance Ticket Options ColumnColumn name that contains advance options in JSON format of the ticket to create.Optional
Create Duplicate TicketDo you want to create duplicate tickets on a short description? (Default is 'No').Optional

Output

A JSON object containing multiple rows of result:

  • has_error: True/False
  • error: message/null
  • result: Ticket Id.
3360

Update Incident Ticket

Updates a ticket with the specified details whenever the parent table has any results.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Ticket Id Column NameColumn name that contains the id of the ticket to update.Required
Short Description Column NameColumn name that contains the short description of the ticket to update.Required
Advance Ticket Options ColumnColumn name that contains advance options in JSON format of the ticket to update.Optional

Output

A JSON object containing multiple rows of result:

  • has_error: True/False
  • error: message/null
  • result: Ticket Id.
690

Get Incident Ticket

Retrieves the incident details with a given incident ID (sys_id).

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Incident Id Column NameColumn name that contains the incident ID.Required

Output

A JSON object containing multiple rows of result:

  • has_error: True/False
  • error: message/null
  • result: Incident details.
3360

Search Incident Tickets (Deprecated)

Searches your ServiceNow instance for tickets with the specified details whenever the parent table has any results.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Short Description Column NameColumn name that contains the short description of the ticket to update.Required
Jinja2 Template to filter resultsTemplate to filter results. e.g severity={{severity}}^priority={{priority}}. Note: If a short description filter is present in the template it will override the short description provided above.Optional
Number of results to returnLimit the number of query results returned.Optional
Include inactive ticketsInclude inactive tickets within the query results.Required

Output

A JSON object containing multiple rows of result:

  • has_error: True/False
  • error: message/null
  • result: Ticket details.
3360

Search Incident Tickets

Searches your ServiceNow instance for tickets with the specified details whenever the parent table has any results.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Short DescriptionJinja-templated text containing the string to search against the short_description field. e.g If search string is 'my pass' it will return incidents having short description like 'Forgot my password today.' Required
Filter ResultsJinja-templated text to filter results. e.g severity={{severity}}^priority={{priority}}. Note: If short description filter is present in template it will override the short description provided above.Optional
Number of Results to ReturnJinja-templated text to limit the number of query results returned (Default is 1000)Optional
Include Inactive TicketsInclude inactive tickets within the query resultsRequired
Time between consecutive API requests (in millis)Time to wait between consecutive API requests in milliseconds. (Default is 0 milliseconds)Optional

Output

A JSON object containing multiple rows of result:

  • has_error: True/False
  • error: message/null
  • result: Ticket details.
{
  "match_found": "true",
  "all_incidents": [
    {
      "sys_id": "552c48888c033300964f4932b03eb092",
      "number": "INC0010112"
    },
    {
      "sys_id": "a83820b58f723300e7e16c7827bdeed2",
      "number": "INC0010111"
    },
    {
      "sys_id": "73fb0e0d2f272010bf2559a72799b682",
      "number": "INC0010002"
    },
    {
      "sys_id": "6646b98d2f232010bf2559a72799b69a",
      "number": "INC0010001"
    },
    {
      "sys_id": "57af7aec73d423002728660c4cf6a71c",
      "number": "INC0009009"
    },
    {
      "sys_id": "ed92e8d173d023002728660c4cf6a7bc",
      "number": "INC0009005"
    },
    {
      "sys_id": "a623cdb073a023002728660c4cf6a768",
      "number": "INC0009001"
    },
    {
      "sys_id": "ff4c21c4735123002728660c4cf6a758",
      "number": "INC0007002"
    },
    {
      "sys_id": "f12ca184735123002728660c4cf6a7ef",
      "number": "INC0007001"
    },
    {
      "sys_id": "a2496c05731110107418660c4cf6a711",
      "number": "INC0001990"
    },
    {
      "sys_id": "85071a1347c12200e0ef563dbb9a71c1",
      "number": "INC0000059"
    },
    {
      "sys_id": "965c9e5347c12200e0ef563dbb9a7156",
      "number": "INC0000058"
    },
    {
      "sys_id": "78271e1347c12200e0ef563dbb9a7109",
      "number": "INC0000057"
    },
    {
      "sys_id": "d71f7935c0a8016700802b64c67c11c6",
      "number": "INC0000055"
    },
    {
      "sys_id": "d71da88ac0a801670061eabfe4b28f77",
      "number": "INC0000054"
    },
    {
      "sys_id": "d71b3b41c0a8016700a8ef040791e72a",
      "number": "INC0000053"
    },
    {
      "sys_id": "d7195138c0a8016700fd68449cfcd484",
      "number": "INC0000052"
    },
    {
      "sys_id": "d7158da0c0a8016700eef46c8d1f3661",
      "number": "INC0000051"
    },
    {
      "sys_id": "ef43c6d40a0a0b5700c77f9bf387afe3",
      "number": "INC0000050"
    },
    {
      "sys_id": "ef4225a40a0a0b5700d0b8a790747812",
      "number": "INC0000049"
    },
    {
      "sys_id": "a9e428cac61122760075710592216c58",
      "number": "INC0000048"
    },
    {
      "sys_id": "a9a16740c61122760004fe9095b7ddca",
      "number": "INC0000047"
    },
    {
      "sys_id": "a9e30c7dc61122760116894de7bcc7bd",
      "number": "INC0000046"
    },
    {
      "sys_id": "47204688a9fe1981011a20af100f381a",
      "number": "INC0000044"
    },
    {
      "sys_id": "471eb058a9fe198100f89592e1ea93d3",
      "number": "INC0000041"
    },
    {
      "sys_id": "471d4732a9fe198100affbf655e59172",
      "number": "INC0000040"
    },
    {
      "sys_id": "471bfbc7a9fe198101e77a3e10e5d47f",
      "number": "INC0000039"
    },
    {
      "sys_id": "4715ab62a9fe1981018c3efb96143495",
      "number": "INC0000037"
    },
    {
      "sys_id": "47064b68a9fe19810186793eefffc9b7",
      "number": "INC0000031"
    },
    {
      "sys_id": "46f67787a9fe198101e06dfcf3a78e99",
      "number": "INC0000029"
    },
    {
      "sys_id": "46f4f4dfa9fe198100063e60278f76ec",
      "number": "INC0000027"
    },
    {
      "sys_id": "46f09e75a9fe198100f4ffd8d366d17b",
      "number": "INC0000025"
    },
    {
      "sys_id": "46edaa6aa9fe198101b9d14ced16619f",
      "number": "INC0000020"
    },
    {
      "sys_id": "46e8219ba9fe1981013806b6e04fed06",
      "number": "INC0000019"
    },
    {
      "sys_id": "46e57642a9fe1981000b96a5dca501ff",
      "number": "INC0000018"
    },
    {
      "sys_id": "46e482d9a9fe198101d3e3f3e2a14459",
      "number": "INC0000017"
    },
    {
      "sys_id": "46e3e949a9fe19810069b824ba2c761a",
      "number": "INC0000016"
    },
    {
      "sys_id": "46e2fee9a9fe19810049b49dee0daf58",
      "number": "INC0000015"
    },
    {
      "sys_id": "8d6353eac0a8016400d8a125ca14fc1f",
      "number": "INC0000007"
    },
    {
      "sys_id": "e8caedcbc0a80164017df472f39eaed1",
      "number": "INC0000003"
    },
    {
      "sys_id": "9d385017c611228701d22104cc95c371",
      "number": "INC0000002"
    }
  ],
  "has_error": false,
  "error": null,
  "newest_incident": {
    "sys_id": "552c48888c033300964f4932b03eb092",
    "number": "INC0010112"
  }
}

Search Users

Searches your ServiceNow instance for users with the specified details whenever the parent table has any results.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Username Column NameColumn name that contains the user name to be queried.Required
Custom Query String Column NameColumn name that contains a user-defined query string to be used instead of the default 'user_name' query.Required
Specific Fields To Return Column NameColumn name that contains the specific fields to be returned.Optional

Output

A JSON object containing multiple rows of result:

  • has_error: True/False
  • error: message/null
  • result: User details.
3360

Get Attachments Metadata

Gets the metadata for multiple attachments.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Sysparm QueryJinja-templated query. Queries for the Attachment API are relative to the Attachments [sys_attachment] table. For example: file_name={{filename}}Optional
LimitLimit to be applied on pagination. Unusually large values can impact system performance. (Default is 10000).Optional
OffsetNumber of records to exclude from the query. Use with "Limit" to paginate the results. (Default is 0).Optional

Output

A JSON object containing details for each attachment:

  • has_error: True/False
  • error: message/null
  • other keys containing details of the attachment
1418

Get Attachment Metadata

Gets the metadata for the attachment file with a specific sys_id value.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Sys IDSelect column containing the value for sys id.Required

Output

A JSON object containing details for attachment:

  • has_error: True/False
  • error: message/null
  • other keys containing details of attachment
1418

Download Attachment

Gets the binary file attachment with a specific sys_id value.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Sys IDSelect column containing the value for sys id.Required

Output

A JSON object containing details of downloaded attachment:

  • has_error: True/False
  • error: message/null
  • lhub_file_id: file-id of the downloaded attachment local to LogicHub
1418

Upload Attachment

Uploads the specified binary file as an attachment.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
File IDSelect column containing the value for LogicHub File Id of the attachment file you want to upload.Required
File NameSelect column containing the value for file name to give to the attachment. Leaving it empty or blank column values will assign LogicHub file id as the name of the uploaded attachment.Optional
Table NameSelect column containing the value for the table name to attach the file to.Required
Table Sys IDSelect column containing the value for sys_id of the record on the specified table that you want to attach the file to.Required
Encryption ContextSelect column containing the value for sys_id of an encryption context record. Specify this parameter to allow only users with the specified encryption context to access the attachment. If you do not specify this parameter (or the column-value is blank), the attached file is not encrypted with an encryption context.Optional

Output

A JSON object containing details of uploaded attachment:

  • has_error: True/False
  • error: message/null
  • other keys containing details of attachment
1418

Delete Attachment

Deletes the attachment file with a specific sys_id value.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Sys IDSelect column containing the value for sys id.Required

Output

A JSON object containing details of uploaded attachment:

  • has_error: True/False
  • error: message/null
  • msg: Successfully deleted
1418

Get Ticket From Table

This action retrieves the record identified by the specified sys_id from the specified table.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Table NameJinja-templated text containing the value for table name. Example: {{table_name_column}}.Required
Sys IDJinja-templated text containing the value for Sys ID. Example: {{sys_id_column}}.Required

Output

A JSON object containing details of uploaded attachment:

  • has_error: True/False
  • error: message/null
  • msg: Table details
{
  "has_error": false,
  "result": {
    "task_effective_number": "INC0010112",
    "additional_assignee_list": "",
    "sla_due": "",
    "follow_up": "",
    "knowledge": "false",
    "location": "",
    "work_start": "",
    "opened_by": {
      "link": "https://dev.service-now.com/api/now/v2/table/sys_user/6816f79cc0a8016401c5a33be04be441",
      "value": "6816f79cc0a8016401c5a33be04be441"
    },
    "due_date": "",
    "sys_updated_on": "2019-07-29 18:49:28",
    "reopen_count": "0",
    "service_offering": "",
    "closed_by": "",
    "incident_state": "1",
    "reopened_by": "",
    "impact": "3",
    "work_notes_list": "",
    "rfc": "",
    "sys_domain": {
      "link": "https://dev.service-now.com/api/now/v2/table/sys_user_group/global",
      "value": "global"
    },
    "escalation": "0",
    "made_sla": "true",
    "group_list": "",
    "sys_mod_count": "0",
    "closed_at": "",
    "category": "inquiry",
    "close_notes": "",
    "route_reason": "",
    "sys_updated_by": "admin",
    "caused_by": "",
    "comments": "",
    "activity_due": "",
    "state": "1",
    "opened_at": "2019-07-29 18:48:43",
    "cmdb_ci": "",
    "sys_tags": "",
    "sys_class_name": "incident",
    "delivery_plan": "",
    "parent": "",
    "business_duration": "",
    "work_notes": "",
    "time_worked": "",
    "active": "true",
    "approval": "not requested",
    "resolved_at": "",
    "work_end": "",
    "sys_created_on": "2019-07-29 18:49:28",
    "contract": "",
    "correlation_display": "",
    "assignment_group": "",
    "subcategory": "",
    "business_service": "",
    "delivery_task": "",
    "number": "INC0010112",
    "universal_request": "",
    "notify": "1",
    "resolved_by": "",
    "upon_reject": "cancel",
    "upon_approval": "proceed",
    "expected_start": "",
    "calendar_stc": "",
    "hold_reason": "",
    "priority": "5",
    "sys_id": "552c48888c033300964f4932b03eb092",
    "child_incidents": "0",
    "company": "",
    "parent_incident": "",
    "reopened_time": "",
    "user_input": "",
    "watch_list": "",
    "caller_id": {
      "link": "https://dev.service-now.com/api/now/v2/table/sys_user/005d500b536073005e0addeeff7b12f4",
      "value": "005d500b536073005e0addeeff7b12f4"
    },
    "correlation_id": "",
    "severity": "3",
    "sys_created_by": "admin",
    "short_description": "Assessment :  ATF Assessor",
    "comments_and_work_notes": "",
    "business_stc": "",
    "description": "",
    "reassignment_count": "0",
    "approval_history": "",
    "calendar_duration": "",
    "sys_domain_path": "/",
    "problem_id": "",
    "contact_type": "",
    "close_code": "",
    "assigned_to": "",
    "approval_set": "",
    "order": "",
    "urgency": "3"
  },
  "error": null
}

Advanced API Query (Deprecated)

Searches your ServiceNow instance for tickets with the specified details whenever the parent table has any results.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Table NameJinja-templated text containing the value for table name. Example: {{table_name_column}}.
Advanced API QueryJinja-templated text for advanced api query. Example: sysparm_query=sys_id={{sys_id}}^priority={{priority}}.
For excluding inactive tickets include sysparm_query=active=true in here.
For sorting the results by number field include sysparm_query=ORDERBYDESCnumber in here.
For more information on all the parameters please refer: https://docs.servicenow.com/bundle/paris-application-development/page/integrate/inbound-rest/concept/c_TableAPI.html#c_TableAPI
Optional
Number of results to returnLimit the number of query results returned (Default is 100,000).Optional

Output

A JSON object containing details of uploaded attachment:

  • has_error: True/False
  • error: message/null
  • msg: Table details
{
  "match_found": "true",
  "all_incidents": [
    {
      "sys_id": "552c48888c033300964f4932b03eb092",
      "number": "INC0010112"
    },
    {
      "sys_id": "a83820b58f723300e7e16c7827bdeed2",
      "number": "INC0010111"
    },
    {
      "sys_id": "73fb0e0d2f272010bf2559a72799b682",
      "number": "INC0010002"
    },
    {
      "sys_id": "6646b98d2f232010bf2559a72799b69a",
      "number": "INC0010001"
    },
    {
      "sys_id": "57af7aec73d423002728660c4cf6a71c",
      "number": "INC0009009"
    },
    {
      "sys_id": "ed92e8d173d023002728660c4cf6a7bc",
      "number": "INC0009005"
    },
    {
      "sys_id": "a623cdb073a023002728660c4cf6a768",
      "number": "INC0009001"
    },
    {
      "sys_id": "ff4c21c4735123002728660c4cf6a758",
      "number": "INC0007002"
    },
    {
      "sys_id": "f12ca184735123002728660c4cf6a7ef",
      "number": "INC0007001"
    },
    {
      "sys_id": "a2496c05731110107418660c4cf6a711",
      "number": "INC0001990"
    },
    {
      "sys_id": "85071a1347c12200e0ef563dbb9a71c1",
      "number": "INC0000059"
    },
    {
      "sys_id": "965c9e5347c12200e0ef563dbb9a7156",
      "number": "INC0000058"
    },
    {
      "sys_id": "78271e1347c12200e0ef563dbb9a7109",
      "number": "INC0000057"
    },
    {
      "sys_id": "d71f7935c0a8016700802b64c67c11c6",
      "number": "INC0000055"
    },
    {
      "sys_id": "d71da88ac0a801670061eabfe4b28f77",
      "number": "INC0000054"
    },
    {
      "sys_id": "d71b3b41c0a8016700a8ef040791e72a",
      "number": "INC0000053"
    },
    {
      "sys_id": "d7195138c0a8016700fd68449cfcd484",
      "number": "INC0000052"
    },
    {
      "sys_id": "d7158da0c0a8016700eef46c8d1f3661",
      "number": "INC0000051"
    },
    {
      "sys_id": "ef43c6d40a0a0b5700c77f9bf387afe3",
      "number": "INC0000050"
    },
    {
      "sys_id": "ef4225a40a0a0b5700d0b8a790747812",
      "number": "INC0000049"
    },
    {
      "sys_id": "a9e428cac61122760075710592216c58",
      "number": "INC0000048"
    },
    {
      "sys_id": "a9a16740c61122760004fe9095b7ddca",
      "number": "INC0000047"
    },
    {
      "sys_id": "a9e30c7dc61122760116894de7bcc7bd",
      "number": "INC0000046"
    },
    {
      "sys_id": "47204688a9fe1981011a20af100f381a",
      "number": "INC0000044"
    },
    {
      "sys_id": "471eb058a9fe198100f89592e1ea93d3",
      "number": "INC0000041"
    },
    {
      "sys_id": "471d4732a9fe198100affbf655e59172",
      "number": "INC0000040"
    },
    {
      "sys_id": "471bfbc7a9fe198101e77a3e10e5d47f",
      "number": "INC0000039"
    },
    {
      "sys_id": "4715ab62a9fe1981018c3efb96143495",
      "number": "INC0000037"
    },
    {
      "sys_id": "47064b68a9fe19810186793eefffc9b7",
      "number": "INC0000031"
    },
    {
      "sys_id": "46f67787a9fe198101e06dfcf3a78e99",
      "number": "INC0000029"
    },
    {
      "sys_id": "46f4f4dfa9fe198100063e60278f76ec",
      "number": "INC0000027"
    },
    {
      "sys_id": "46f09e75a9fe198100f4ffd8d366d17b",
      "number": "INC0000025"
    },
    {
      "sys_id": "46edaa6aa9fe198101b9d14ced16619f",
      "number": "INC0000020"
    },
    {
      "sys_id": "46e8219ba9fe1981013806b6e04fed06",
      "number": "INC0000019"
    },
    {
      "sys_id": "46e57642a9fe1981000b96a5dca501ff",
      "number": "INC0000018"
    },
    {
      "sys_id": "46e482d9a9fe198101d3e3f3e2a14459",
      "number": "INC0000017"
    },
    {
      "sys_id": "46e3e949a9fe19810069b824ba2c761a",
      "number": "INC0000016"
    },
    {
      "sys_id": "46e2fee9a9fe19810049b49dee0daf58",
      "number": "INC0000015"
    },
    {
      "sys_id": "8d6353eac0a8016400d8a125ca14fc1f",
      "number": "INC0000007"
    },
    {
      "sys_id": "e8caedcbc0a80164017df472f39eaed1",
      "number": "INC0000003"
    },
    {
      "sys_id": "9d385017c611228701d22104cc95c371",
      "number": "INC0000002"
    }
  ],
  "has_error": false,
  "error": null,
  "newest_incident": {
    "sys_id": "552c48888c033300964f4932b03eb092",
    "number": "INC0010112"
  }
}

Advanced API Query

Searches your ServiceNow instance for resources with the specified details whenever the parent table has any results. Use the API endpoint query parameters to perform an advanced search.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Table NameJinja-templated text containing the value for table name. Example: {{table_name_column}}.Required
Advanced API QueryJinja-templated text for advanced api query. Example: sysparm_query=sys_id={{sys_id}}^priority={{priority}}.For excluding inactive tickets include sysparm_query=active=true in here.For sorting the results by number field include sysparm_query=ORDERBYDESCnumber in here.For more information on all the parameters please refer: https://docs.servicenow.com/bundle/paris-application-development/page/integrate/inbound-rest/concept/c_TableAPI.html#c_TableAPIOptional
Number of Results to ReturnJinja-templated to limit the number of query results returned (Default is 1000)Optional

Output

JSON containing the following items:

{
  "match_found": "true",
  "all_incidents": [
    {
      "sys_id": "552c48888c033300964f4932b03eb092",
      "number": "INC0010112"
    },
    {
      "sys_id": "a83820b58f723300e7e16c7827bdeed2",
      "number": "INC0010111"
    },
    {
      "sys_id": "73fb0e0d2f272010bf2559a72799b682",
      "number": "INC0010002"
    },
    {
      "sys_id": "6646b98d2f232010bf2559a72799b69a",
      "number": "INC0010001"
    },
    {
      "sys_id": "57af7aec73d423002728660c4cf6a71c",
      "number": "INC0009009"
    },
    {
      "sys_id": "ed92e8d173d023002728660c4cf6a7bc",
      "number": "INC0009005"
    },
    {
      "sys_id": "a623cdb073a023002728660c4cf6a768",
      "number": "INC0009001"
    },
    {
      "sys_id": "ff4c21c4735123002728660c4cf6a758",
      "number": "INC0007002"
    },
    {
      "sys_id": "f12ca184735123002728660c4cf6a7ef",
      "number": "INC0007001"
    },
    {
      "sys_id": "a2496c05731110107418660c4cf6a711",
      "number": "INC0001990"
    },
    {
      "sys_id": "85071a1347c12200e0ef563dbb9a71c1",
      "number": "INC0000059"
    },
    {
      "sys_id": "965c9e5347c12200e0ef563dbb9a7156",
      "number": "INC0000058"
    },
    {
      "sys_id": "78271e1347c12200e0ef563dbb9a7109",
      "number": "INC0000057"
    },
    {
      "sys_id": "d71f7935c0a8016700802b64c67c11c6",
      "number": "INC0000055"
    },
    {
      "sys_id": "d71da88ac0a801670061eabfe4b28f77",
      "number": "INC0000054"
    },
    {
      "sys_id": "d71b3b41c0a8016700a8ef040791e72a",
      "number": "INC0000053"
    },
    {
      "sys_id": "d7195138c0a8016700fd68449cfcd484",
      "number": "INC0000052"
    },
    {
      "sys_id": "d7158da0c0a8016700eef46c8d1f3661",
      "number": "INC0000051"
    },
    {
      "sys_id": "ef43c6d40a0a0b5700c77f9bf387afe3",
      "number": "INC0000050"
    },
    {
      "sys_id": "ef4225a40a0a0b5700d0b8a790747812",
      "number": "INC0000049"
    },
    {
      "sys_id": "a9e428cac61122760075710592216c58",
      "number": "INC0000048"
    },
    {
      "sys_id": "a9a16740c61122760004fe9095b7ddca",
      "number": "INC0000047"
    },
    {
      "sys_id": "a9e30c7dc61122760116894de7bcc7bd",
      "number": "INC0000046"
    },
    {
      "sys_id": "47204688a9fe1981011a20af100f381a",
      "number": "INC0000044"
    },
    {
      "sys_id": "471eb058a9fe198100f89592e1ea93d3",
      "number": "INC0000041"
    },
    {
      "sys_id": "471d4732a9fe198100affbf655e59172",
      "number": "INC0000040"
    },
    {
      "sys_id": "471bfbc7a9fe198101e77a3e10e5d47f",
      "number": "INC0000039"
    },
    {
      "sys_id": "4715ab62a9fe1981018c3efb96143495",
      "number": "INC0000037"
    },
    {
      "sys_id": "47064b68a9fe19810186793eefffc9b7",
      "number": "INC0000031"
    },
    {
      "sys_id": "46f67787a9fe198101e06dfcf3a78e99",
      "number": "INC0000029"
    },
    {
      "sys_id": "46f4f4dfa9fe198100063e60278f76ec",
      "number": "INC0000027"
    },
    {
      "sys_id": "46f09e75a9fe198100f4ffd8d366d17b",
      "number": "INC0000025"
    },
    {
      "sys_id": "46edaa6aa9fe198101b9d14ced16619f",
      "number": "INC0000020"
    },
    {
      "sys_id": "46e8219ba9fe1981013806b6e04fed06",
      "number": "INC0000019"
    },
    {
      "sys_id": "46e57642a9fe1981000b96a5dca501ff",
      "number": "INC0000018"
    },
    {
      "sys_id": "46e482d9a9fe198101d3e3f3e2a14459",
      "number": "INC0000017"
    },
    {
      "sys_id": "46e3e949a9fe19810069b824ba2c761a",
      "number": "INC0000016"
    },
    {
      "sys_id": "46e2fee9a9fe19810049b49dee0daf58",
      "number": "INC0000015"
    },
    {
      "sys_id": "8d6353eac0a8016400d8a125ca14fc1f",
      "number": "INC0000007"
    },
    {
      "sys_id": "e8caedcbc0a80164017df472f39eaed1",
      "number": "INC0000003"
    },
    {
      "sys_id": "9d385017c611228701d22104cc95c371",
      "number": "INC0000002"
    }
  ],
  "has_error": false,
  "error": null,
  "newest_incident": {
    "sys_id": "552c48888c033300964f4932b03eb092",
    "number": "INC0010112"
  }
}

Create Record in Table

This action Inserts one record in the specified table.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Table NameJinja-templated text containing the value for table name. Example: {{table_name}}.Required
Request BodyJinja-templated text containing the Field name and the associated value for each parameter to define in the JSON format. Example: {"assigned_to": "1234abcd","urgency": "1","comments": "This is a blocking issue"}. (Default value is empty JSON)Optional
Sysparm FieldsJinja-templated text containing the comma-separated list of fields to return in the response. Example: 'parent,sys_id'.Optional

Output

A JSON object:

{
	"work_notes": "",
	"opened_at": "2022-05-13 10:00:36",
	"notify": "1",
	"upon_approval": "proceed",
	"parent_incident": "",
	"number": "INC0010023",
	"universal_request": "",
	"parent": "",
	"sys_mod_count": "0",
	"caused_by": "",
	"priority": "5",
	"reassignment_count": "0",
	"location": "",
	"reopened_time": "",
	"sys_updated_on": "2022-05-13 10:00:36",
	"sys_id": "0c5f79bf2f134110e747811df699b6bd",
	"state": "1",
	"incident_state": "1",
	"contact_type": "",
	"business_duration": "",
	"correlation_id": "",
	"description": "",
	"child_incidents": "0",
	"sla_due": "",
	"expected_start": "",
	"comments_and_work_notes": "",
	"opened_by": {
		"link": "https://instance.service-now.com/api/now/v2/table/sys_user/6816f79cc0a8016401c5a33be04be441",
		"value": "6816f79cc0a8016401c5a33be04be441"
	},
	"watch_list": "",
	"cmdb_ci": "",
	"short_description": "",
	"impact": "3",
	"time_worked": "",
	"resolved_at": "",
	"delivery_plan": "",
	"upon_reject": "cancel",
	"task_effective_number": "INC0010023",
	"route_reason": "",
	"problem_id": "",
	"calendar_duration": "",
	"assignment_group": "",
	"work_notes_list": "",
	"caller_id": "",
	"sys_created_by": "admin",
	"group_list": "",
	"resolved_by": "",
	"sys_created_on": "2022-05-13 10:00:36",
	"urgency": "3",
	"sys_domain": {
		"link": "https://instance.service-now.com/api/now/v2/table/sys_user_group/global",
		"value": "global"
	},
	"company": "",
	"subcategory": "",
	"business_service": "",
	"origin_id": "",
	"approval": "not requested",
	"has_error": false,
	"reopen_count": "0",
	"assigned_to": "",
	"calendar_stc": "",
	"rfc": "",
	"user_input": "",
	"error": null,
	"made_sla": "true",
	"approval_set": "",
	"correlation_display": "",
	"additional_assignee_list": "",
	"order": "",
	"approval_history": "",
	"closed_at": "",
	"cause": "",
	"close_notes": "",
	"due_date": "",
	"knowledge": "false",
	"category": "inquiry",
	"origin_table": "",
	"activity_due": "",
	"severity": "3",
	"delivery_task": "",
	"escalation": "0",
	"work_end": "",
	"sys_domain_path": "/",
	"hold_reason": "",
	"reopened_by": "",
	"sys_class_name": "incident",
	"service_offering": "",
	"work_start": "",
	"close_code": "",
	"sys_updated_by": "admin",
	"closed_by": "",
	"business_impact": "",
	"contract": "",
	"follow_up": "",
	"comments": "",
	"sys_tags": "",
	"active": "true",
	"business_stc": ""
}

Delete Record from Table

This action Deletes the specified record from the specified table.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Table NameJinja-templated text containing the value for table name. Example: {{table_name}}.Required
Sys IdJinja-templated text containing the Sys Id of the record. Example {{sys_id}}.Required
Sysparm QueryJinja-templated boolean value containing the flag that indicates whether to restrict the record search to only the domains for which the logged in user is configured. (Default is false)Optional

Output

A JSON object:

{
	"message": "record deleted successfully",
	"has_error": false,
	"error": null
}

Get Records from Table

This action Retrieves multiple records for the specified table.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Table NameJinja-templated text containing the value for table name. Example: {{table_name}}.Required
Sysparm FieldsJinja-templated text containing the comma-separated list of fields to return in the response. Example: 'parent,sys_id'.Optional
Sysparm LimitJinja-templated integer value containing the maximum records to return. (Default is 1000)Optional
Sysparm QueryJinja-templated text containing the encoded query used to filter the result set. Example 'true^ORDERBYnumber^ORDERBYDESCcategory'.Optional
Sysparm Query CategoryJinja-templated text containing the name of the category to use for queries. Example {{query_category}}Optional

Output

A JSON object:

{
	"has_error": false,
	"result": [{
		"task_effective_number": "INC0009002",
		"additional_assignee_list": "",
		"sla_due": "",
		"follow_up": "",
		"knowledge": "false",
		"location": "",
		"work_start": "",
		"opened_by": {
			"link": "https://dev63356.service-now.com/api/now/v2/table/sys_user/6816f79cc0a8016401c5a33be04be441",
			"value": "6816f79cc0a8016401c5a33be04be441"
		},
		"due_date": "",
		"sys_updated_on": "2022-03-18 03:57:25",
		"reopen_count": "0",
		"service_offering": "",
		"closed_by": {
			"link": "https://dev63356.service-now.com/api/now/v2/table/sys_user/6816f79cc0a8016401c5a33be04be441",
			"value": "6816f79cc0a8016401c5a33be04be441"
		},
		"incident_state": "7",
		"reopened_by": "",
		"work_notes_list": "",
		"rfc": "",
		"sys_domain": {
			"link": "https://dev63356.service-now.com/api/now/v2/table/sys_user_group/global",
			"value": "global"
		},
		"escalation": "0",
		"origin_id": "",
		"made_sla": "true",
		"group_list": "",
		"sys_mod_count": "9",
		"closed_at": "2018-12-10 03:29:08",
		"sys_tags": "",
		"origin_table": "",
		"category": "Hardware",
		"close_notes": "This is not an issue with the USB port. Replaced the headset to resolve the issue.",
		"route_reason": "",
		"sys_updated_by": "system",
		"caused_by": "",
		"comments": "",
		"activity_due": "",
		"state": "7",
		"opened_at": "2018-09-16 12:49:23",
		"cmdb_ci": "",
		"cause": "",
		"impact": "2",
		"sys_class_name": "incident",
		"delivery_plan": "",
		"parent": "",
		"business_duration": "1970-01-01 00:00:00",
		"work_notes": "",
		"time_worked": "",
		"active": "false",
		"approval": "not requested",
		"resolved_at": "2018-09-16 12:51:17",
		"work_end": "",
		"sys_created_on": "2018-09-16 12:50:05",
		"contract": "",
		"correlation_display": "",
		"assignment_group": "",
		"business_impact": "",
		"subcategory": "",
		"business_service": "",
		"delivery_task": "",
		"number": "INC0009002",
		"universal_request": "",
		"notify": "1",
		"resolved_by": {
			"link": "https://dev63356.service-now.com/api/now/v2/table/sys_user/6816f79cc0a8016401c5a33be04be441",
			"value": "6816f79cc0a8016401c5a33be04be441"
		},
		"upon_reject": "cancel",
		"upon_approval": "proceed",
		"expected_start": "",
		"calendar_stc": "114",
		"hold_reason": "",
		"priority": "3",
		"sys_id": "1c832706732023002728660c4cf6a7b9",
		"child_incidents": "1",
		"company": "",
		"parent_incident": "",
		"reopened_time": "",
		"user_input": "",
		"watch_list": "",
		"caller_id": {
			"link": "https://dev63356.service-now.com/api/now/v2/table/sys_user/77ad8176731313005754660c4cf6a7de",
			"value": "77ad8176731313005754660c4cf6a7de"
		},
		"correlation_id": "",
		"severity": "3",
		"sys_created_by": "admin",
		"short_description": "My computer is not detecting the headphone device",
		"comments_and_work_notes": "",
		"business_stc": "0",
		"description": "My computer is not detecting the headphone device. It could be an issue with the USB port.",
		"reassignment_count": "0",
		"approval_history": "",
		"calendar_duration": "1970-01-01 00:01:54",
		"sys_domain_path": "/",
		"problem_id": "",
		"contact_type": "",
		"close_code": "Solved (Permanently)",
		"assigned_to": "",
		"approval_set": "",
		"order": "",
		"urgency": "2"
	}],
	"error": null
}

Get Single Record by Id from Table

This action Retrieves the record identified by the specified sys_id from the specified table.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Table NameJinja-templated text containing the value for table name. Example: {{table_name}}.Required
Sys IdJinja-templated text containing the Sys Id of the record. Example {{sys_id}}.Required
Sysparm FieldsJinja-templated text containing the comma-separated list of fields to return in the response. Example: 'parent,sys_id'.Optional

Output

A JSON object:

{
	"has_error": false,
	"sys_id": "76654ab32f534110e747811df699b67f",
	"parent": "",
	"error": null
}

Update Record from Table

This action Updates the specified record with the name-value pairs included in the request body.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Table NameJinja-templated text containing the value for table name. Example: {{table_name}}.Required
Sys IdJinja-templated text containing the Sys Id of the record. Example {{sys_id}}.Required
Sysparm FieldsJinja-templated text containing the comma-separated list of fields to return in the response. Example: 'parent,sys_id'.Optional
Request BodyJinja-templated text containing the Field name and the associated value for each parameter to define in the JSON format. Example: {"assigned_to": "1234abcd","urgency": "1","comments": "This is a blocking issue"}. (Default value is empty JSON)Optional

Output

A JSON object:

{
	"work_notes": "",
	"opened_at": "2022-05-13 10:27:16",
	"notify": "1",
	"upon_approval": "proceed",
	"parent_incident": "",
	"number": "INC0010024",
	"universal_request": "",
	"parent": "",
	"sys_mod_count": "0",
	"caused_by": "",
	"priority": "5",
	"reassignment_count": "0",
	"location": "",
	"reopened_time": "",
	"sys_updated_on": "2022-05-13 10:27:16",
	"sys_id": "76654ab32f534110e747811df699b67f",
	"state": "1",
	"incident_state": "1",
	"contact_type": "",
	"business_duration": "",
	"correlation_id": "",
	"description": "",
	"child_incidents": "0",
	"sla_due": "",
	"expected_start": "",
	"comments_and_work_notes": "",
	"opened_by": {
		"link": "https://instance.service-now.com/api/now/v2/table/sys_user/6816f79cc0a8016401c5a33be04be441",
		"value": "6816f79cc0a8016401c5a33be04be441"
	},
	"watch_list": "",
	"cmdb_ci": "",
	"short_description": "",
	"impact": "3",
	"time_worked": "",
	"resolved_at": "",
	"delivery_plan": "",
	"upon_reject": "cancel",
	"task_effective_number": "INC0010024",
	"route_reason": "",
	"problem_id": "",
	"calendar_duration": "",
	"assignment_group": "",
	"work_notes_list": "",
	"caller_id": "",
	"sys_created_by": "admin",
	"group_list": "",
	"resolved_by": "",
	"sys_created_on": "2022-05-13 10:27:16",
	"urgency": "3",
	"sys_domain": {
		"link": "https://instance.service-now.com/api/now/v2/table/sys_user_group/global",
		"value": "global"
	},
	"company": "",
	"subcategory": "",
	"business_service": "",
	"origin_id": "",
	"approval": "not requested",
	"has_error": false,
	"reopen_count": "0",
	"assigned_to": "",
	"calendar_stc": "",
	"rfc": "",
	"user_input": "",
	"error": null,
	"made_sla": "true",
	"approval_set": "",
	"correlation_display": "",
	"additional_assignee_list": "",
	"order": "",
	"approval_history": "",
	"closed_at": "",
	"cause": "",
	"close_notes": "",
	"due_date": "",
	"knowledge": "false",
	"category": "inquiry",
	"origin_table": "",
	"activity_due": "",
	"severity": "3",
	"delivery_task": "",
	"escalation": "0",
	"work_end": "",
	"sys_domain_path": "/",
	"hold_reason": "",
	"reopened_by": "",
	"sys_class_name": "incident",
	"service_offering": "",
	"work_start": "",
	"close_code": "",
	"sys_updated_by": "admin",
	"closed_by": "",
	"business_impact": "",
	"contract": "",
	"follow_up": "",
	"comments": "",
	"sys_tags": "",
	"active": "true",
	"business_stc": ""
}

Order Specified Catalog Item

Order the specified catalog item.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input NameDescriptionRequired
Sys IDJinja-templated text containing the value of sys id. Example: {{sys_id}}Required
QuantityJinja-templated text containing the number of item to add (Default is 1). Example: {{sysparm_quantity}}Optional
Mandatory Cart Item VariableJinja-templated text containing JSON formatted name, value pairs of all mandatory cart item variables. Example: {"priority": "{{high}}", "{{prop}}": "default"}Optional
Sysparm Also Request ForJinja-templated text containing Comma-separated string of user sys_ids of other users for which to order the specified item. User sys_ids are located in the User [sys_user] table. Example: {{request_for}}Optional

Output

JSON containing the following items:

{
  "result": {
    "sys_id": "cf56a3fcdb3a2300e890f71fbf9619ac",
    "number": "REQ0010012",
    "request_number": "REQ0010012",
    "request_id": "cf56a3fcdb3a2300e890f71fbf9619ac",
    "table": "sc_request"
  },
  "error":null,
  "has_error":false
}

Release Notes

  • v3.0.0 - Updated architecture to support IO via filesystem
  • v2.4.3 - Deprecated 2 actions (Search Incident Tickets and Advanced API Query) and replaced with the new ones with different default value(i.e. 1000) for Number of Results to Return.
  • v2.3.0 - Added 1 action: Order Specified Catalog Item.
  • v2.2.1 - Added 5 actions Create Record in Table, Delete Record from Table, Get Records from Table, Get Single Record by Id from Table, and Update Record from Table.
  • v2.1.3 - Resolved bug for action validation.

© 2017-2021 LogicHub®. All Rights Reserved.