Checking ServiceNow REST API details

To retrieve details using REST API explorer for a given Change ticket on ServiceNow:
  1. Login to ServiceNow using your credentials.
  2. Search or navigate to REST API Explorer.
  3. Select tableName value from the dropdown list.
  4. Enter the value for sysparm_query (number=<change ticket>).
    For example, number=CHG0030682
  5. Get ‘sysID’ API response body for the change ticket. 
    {
  "result": [
    {
      "u_glide_date_1": "",
      "parent": "",
      "reason": "",
      "made_sla": "true",
      "backout_plan": "",
      "watch_list": "",
      "u_integer_4": "",
      "upon_reject": "cancel",
      "sys_updated_on": "2016-11-11 07:58:35",
      "type": "Comprehensive",
      "conflict_status": "Not Run",
      "approval_history": "",
      "number": "CHG0030682",
      "test_plan": "",
      "sys_updated_by": "admin",
      "opened_by": {
        "link": "https://ven01189.service-now.com/api/now/table/sys_user/6816f79cc0a8016401c5a33be04be441",
        "value": "6816f79cc0a8016401c5a33be04be441"
      },
      "user_input": "",
      "requested_by_date": "",
      "sys_created_on": "2016-11-11 07:08:22",
      "sys_domain": {
        "link": "https://ven01189.service-now.com/api/now/table/sys_user_group/global",
        "value": "global"
      },
      "state": "4",
      "sys_created_by": "admin",
      "knowledge": "false",
      "order": "",
      "phase": "requested",
      "closed_at": "2016-11-11 07:58:35",
      "cmdb_ci": {
        "link": "https://ven01189.service-now.com/api/now/table/cmdb_ci/0ca262a80f4fa200c3e6cd8ce1050e68",
        "value": "0ca262a80f4fa200c3e6cd8ce1050e68"
      },
      "delivery_plan": "",
      "impact": "3",
      "active": "false",
      "review_comments": "kk_vs1",
      "work_notes_list": "",
      "business_service": "",
      "priority": "2",
      "time_worked": "",
      "cab_recommendation": "",
      "expected_start": "",
      "production_system": "false",
      "rejection_goto": "",
      "opened_at": "2016-11-11 07:08:22",
      "review_date": "",
      "business_duration": "",
      "group_list": "",
      "requested_by": {
        "link": "https://ven01189.service-now.com/api/now/table/sys_user/kk",
        "value": "kk"
      },
      "work_end": "",
      "change_plan": "",
      "phase_state": "open",
      "approval_set": "",
      "cab_date": "",
      "wf_activity": "",
      "work_notes": "",
      "implementation_plan": "",
      "u_table_name_1": "",
      "end_date": "2016-11-12 00:00:00",
      "short_description": "Create VS on UAT",
      "correlation_display": "",
      "delivery_task": "",
      "work_start": "",
      "assignment_group": "",
      "additional_assignee_list": "",
      "outside_maintenance_schedule": "false",
      "description": "Create VS",
      "calendar_duration": "",
      "close_notes": "Closing the ticket from AppViewX.",
      "sys_class_name": "change_request",
      "closed_by": {
        "link": "https://ven01189.service-now.com/api/now/table/sys_user/6816f79cc0a8016401c5a33be04be441",
        "value": "6816f79cc0a8016401c5a33be04be441"
      },
      "follow_up": "",
      "sys_id": "25e553cd0f07e200c3e6cd8ce1050e14",
      "contact_type": "phone",
      "urgency": "3",
      "scope": "3",
      "company": "",
      "justification": "",
      "reassignment_count": "0",
      "review_status": "3",
      "activity_due": "",
      "assigned_to": "",
      "start_date": "2016-11-07 00:00:00",
      "u_field_name_3": "",
      "u_field_name_1": "",
      "comments": "",
      "u_field_name_2": "",
      "u_journal_1": "",
      "approval": "approved",
      "sla_due": "",
      "comments_and_work_notes": "",
      "due_date": "",
      "sys_mod_count": "4",
      "sys_tags": "",
      "conflict_last_run": "",
      "escalation": "0",
      "upon_approval": "proceed",
      "correlation_id": "",
      "location": "",
      "risk": "4",
      "category": "Hardware"
    }
  ]
}
  6. Enter or select the following field information to get ‘CI’ specific details.
    tableName CIs Affected (task_ci)
    sysparm_query task=’sysID’ (task=25e553cd0f07e200c3e6cd8ce1050e14)
    sysparm_display_value true
    Response for sysid from task_ci table. 
    {
  "result": [
    {
      "sys_id": "39e593010f47e200c3e6cd8ce1050e8a",
      "sys_updated_by": "admin",
      "task": {
        "display_value": "CHG0030682",
        "link": "https://ven01189.service-now.com/api/now/table/task/25e553cd0f07e200c3e6cd8ce1050e14"
      },
      "applied": "false",
      "sys_created_on": "2016-11-11 07:08:23",
      "xml": "",
      "sys_mod_count": "0",
      "sys_updated_on": "2016-11-11 07:08:23",
      "sys_tags": "",
      "applied_date": "",
      "ci_item": {
        "display_value": "117",
        "link": "https://ven01189.service-now.com/api/now/table/cmdb_ci/0ca262a80f4fa200c3e6cd8ce1050e68"
      },
      "sys_created_by": "admin"
    }
  ]
}