> ## Documentation Index
> Fetch the complete documentation index at: https://docs.pinkfish.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# servicenow-table

> ServiceNow Table - read and write any table (incident, task, change, custom)

**Server path:** `/servicenow-table` | **Type:** Application | **PCID required:** Yes

## Tools

| Tool                                                                  | Description                    |
| --------------------------------------------------------------------- | ------------------------------ |
| [`servicenow_table_create_record`](#servicenow_table_create_record)   | Create a record in a table     |
| [`servicenow_table_delete_record`](#servicenow_table_delete_record)   | Delete a record                |
| [`servicenow_table_get_record`](#servicenow_table_get_record)         | Get a single record by sys\_id |
| [`servicenow_table_list_records`](#servicenow_table_list_records)     | List records from a table      |
| [`servicenow_table_patch_record`](#servicenow_table_patch_record)     | Partially update a record      |
| [`servicenow_table_replace_record`](#servicenow_table_replace_record) | Replace a record (full update) |

***

## servicenow\_table\_create\_record

Create a record in a table

**Parameters:**

| Parameter                     | Type    | Required | Default | Description                                                                                                                      |
| ----------------------------- | ------- | -------- | ------- | -------------------------------------------------------------------------------------------------------------------------------- |
| `tableName`                   | string  | Yes      | —       | Name of the table (e.g., incident, problem, change\_request)                                                                     |
| `sysparm_display_value`       | string  | No       | —       | Return display values (true), actual values (false), or both (all)                                                               |
| `sysparm_fields`              | string  | No       | —       | Comma-separated fields to include in the response                                                                                |
| `sysparm_input_display_value` | boolean | No       | —       | Set field values using display values rather than actual values. Default: false                                                  |
| `body`                        | object  | Yes      | —       | Record fields to set. Keys are field names (e.g., short\_description, priority, assignment\_group), values are the field values. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "tableName": {
        "type": "string",
        "description": "Name of the table (e.g., incident, problem, change_request)"
      },
      "sysparm_display_value": {
        "type": "string",
        "description": "Return display values (true), actual values (false), or both (all)",
        "enum": [
          "true",
          "false",
          "all"
        ]
      },
      "sysparm_fields": {
        "type": "string",
        "description": "Comma-separated fields to include in the response"
      },
      "sysparm_input_display_value": {
        "type": "boolean",
        "description": "Set field values using display values rather than actual values. Default: false"
      },
      "body": {
        "type": "object",
        "description": "Record fields to set. Keys are field names (e.g., short_description, priority, assignment_group), values are the field values."
      }
    },
    "required": [
      "PCID",
      "tableName",
      "body"
    ]
  }
  ```
</Expandable>

***

## servicenow\_table\_delete\_record

Delete a record

**Parameters:**

| Parameter   | Type   | Required | Default | Description                                      |
| ----------- | ------ | -------- | ------- | ------------------------------------------------ |
| `tableName` | string | Yes      | —       | Name of the table                                |
| `sys_id`    | string | Yes      | —       | Unique system identifier of the record to delete |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "tableName": {
        "type": "string",
        "description": "Name of the table"
      },
      "sys_id": {
        "type": "string",
        "description": "Unique system identifier of the record to delete"
      }
    },
    "required": [
      "PCID",
      "tableName",
      "sys_id"
    ]
  }
  ```
</Expandable>

***

## servicenow\_table\_get\_record

Get a single record by sys\_id

**Parameters:**

| Parameter                        | Type    | Required | Default | Description                                                        |
| -------------------------------- | ------- | -------- | ------- | ------------------------------------------------------------------ |
| `tableName`                      | string  | Yes      | —       | Name of the table                                                  |
| `sys_id`                         | string  | Yes      | —       | Unique system identifier (32-character hex string) of the record   |
| `sysparm_display_value`          | string  | No       | —       | Return display values (true), actual values (false), or both (all) |
| `sysparm_fields`                 | string  | No       | —       | Comma-separated fields to return                                   |
| `sysparm_exclude_reference_link` | boolean | No       | —       | Exclude reference links in the response                            |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "tableName": {
        "type": "string",
        "description": "Name of the table"
      },
      "sys_id": {
        "type": "string",
        "description": "Unique system identifier (32-character hex string) of the record"
      },
      "sysparm_display_value": {
        "type": "string",
        "description": "Return display values (true), actual values (false), or both (all)",
        "enum": [
          "true",
          "false",
          "all"
        ]
      },
      "sysparm_fields": {
        "type": "string",
        "description": "Comma-separated fields to return"
      },
      "sysparm_exclude_reference_link": {
        "type": "boolean",
        "description": "Exclude reference links in the response"
      }
    },
    "required": [
      "PCID",
      "tableName",
      "sys_id"
    ]
  }
  ```
</Expandable>

***

## servicenow\_table\_list\_records

List records from a table

**Parameters:**

| Parameter                        | Type    | Required | Default | Description                                                                          |
| -------------------------------- | ------- | -------- | ------- | ------------------------------------------------------------------------------------ |
| `tableName`                      | string  | Yes      | —       | Name of the table to query (e.g., incident, task, change\_request, cmdb\_ci)         |
| `sysparm_query`                  | string  | No       | —       | Encoded query string (e.g., 'state=1^priority=2' or 'short\_descriptionLIKEserver')  |
| `sysparm_limit`                  | integer | No       | —       | Maximum number of records to return                                                  |
| `sysparm_offset`                 | integer | No       | —       | Starting index for pagination                                                        |
| `sysparm_fields`                 | string  | No       | —       | Comma-separated list of fields to return (e.g., 'sys\_id,number,short\_description') |
| `sysparm_display_value`          | string  | No       | —       | Return display values (true), actual values (false), or both (all). Default: false   |
| `sysparm_exclude_reference_link` | boolean | No       | —       | Exclude reference links in the response. Default: false                              |
| `sysparm_view`                   | string  | No       | —       | UI view to determine which fields to return                                          |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "tableName": {
        "type": "string",
        "description": "Name of the table to query (e.g., incident, task, change_request, cmdb_ci)"
      },
      "sysparm_query": {
        "type": "string",
        "description": "Encoded query string (e.g., 'state=1^priority=2' or 'short_descriptionLIKEserver')"
      },
      "sysparm_limit": {
        "type": "integer",
        "description": "Maximum number of records to return"
      },
      "sysparm_offset": {
        "type": "integer",
        "description": "Starting index for pagination"
      },
      "sysparm_fields": {
        "type": "string",
        "description": "Comma-separated list of fields to return (e.g., 'sys_id,number,short_description')"
      },
      "sysparm_display_value": {
        "type": "string",
        "description": "Return display values (true), actual values (false), or both (all). Default: false",
        "enum": [
          "true",
          "false",
          "all"
        ]
      },
      "sysparm_exclude_reference_link": {
        "type": "boolean",
        "description": "Exclude reference links in the response. Default: false"
      },
      "sysparm_view": {
        "type": "string",
        "description": "UI view to determine which fields to return",
        "enum": [
          "desktop",
          "mobile",
          "both"
        ]
      }
    },
    "required": [
      "PCID",
      "tableName"
    ]
  }
  ```
</Expandable>

***

## servicenow\_table\_patch\_record

Partially update a record

**Parameters:**

| Parameter                     | Type    | Required | Default | Description                                                                   |
| ----------------------------- | ------- | -------- | ------- | ----------------------------------------------------------------------------- |
| `tableName`                   | string  | Yes      | —       | Name of the table                                                             |
| `sys_id`                      | string  | Yes      | —       | Unique system identifier of the record to update                              |
| `sysparm_display_value`       | string  | No       | —       | Return display values (true), actual values (false), or both (all)            |
| `sysparm_fields`              | string  | No       | —       | Comma-separated fields to include in the response                             |
| `sysparm_input_display_value` | boolean | No       | —       | Set field values using display values rather than actual values               |
| `body`                        | object  | Yes      | —       | Fields to update. Only specified fields are changed; others remain unchanged. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "tableName": {
        "type": "string",
        "description": "Name of the table"
      },
      "sys_id": {
        "type": "string",
        "description": "Unique system identifier of the record to update"
      },
      "sysparm_display_value": {
        "type": "string",
        "description": "Return display values (true), actual values (false), or both (all)",
        "enum": [
          "true",
          "false",
          "all"
        ]
      },
      "sysparm_fields": {
        "type": "string",
        "description": "Comma-separated fields to include in the response"
      },
      "sysparm_input_display_value": {
        "type": "boolean",
        "description": "Set field values using display values rather than actual values"
      },
      "body": {
        "type": "object",
        "description": "Fields to update. Only specified fields are changed; others remain unchanged."
      }
    },
    "required": [
      "PCID",
      "tableName",
      "sys_id",
      "body"
    ]
  }
  ```
</Expandable>

***

## servicenow\_table\_replace\_record

Replace a record (full update)

**Parameters:**

| Parameter                     | Type    | Required | Default | Description                                                                                |
| ----------------------------- | ------- | -------- | ------- | ------------------------------------------------------------------------------------------ |
| `tableName`                   | string  | Yes      | —       | Name of the table                                                                          |
| `sys_id`                      | string  | Yes      | —       | Unique system identifier of the record to replace                                          |
| `sysparm_display_value`       | string  | No       | —       | Return display values (true), actual values (false), or both (all)                         |
| `sysparm_fields`              | string  | No       | —       | Comma-separated fields to include in the response                                          |
| `sysparm_input_display_value` | boolean | No       | —       | Set field values using display values rather than actual values                            |
| `body`                        | object  | Yes      | —       | Complete set of record fields. All writable fields not provided will be reset to defaults. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "tableName": {
        "type": "string",
        "description": "Name of the table"
      },
      "sys_id": {
        "type": "string",
        "description": "Unique system identifier of the record to replace"
      },
      "sysparm_display_value": {
        "type": "string",
        "description": "Return display values (true), actual values (false), or both (all)",
        "enum": [
          "true",
          "false",
          "all"
        ]
      },
      "sysparm_fields": {
        "type": "string",
        "description": "Comma-separated fields to include in the response"
      },
      "sysparm_input_display_value": {
        "type": "boolean",
        "description": "Set field values using display values rather than actual values"
      },
      "body": {
        "type": "object",
        "description": "Complete set of record fields. All writable fields not provided will be reset to defaults."
      }
    },
    "required": [
      "PCID",
      "tableName",
      "sys_id",
      "body"
    ]
  }
  ```
</Expandable>