---
sourceDocument: Australia API Reference
sourceDocumentLink: https://www.servicenow.com/docs/r/api-reference

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia API Reference

ft:clusterId :

    - crapiref

bundleId :

    - crapiref

workflow :

    - Creator


---

# Table API

# Table API {#ariaid-title1}

* Release version: Australia
* 
* Updated March 12, 2026
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 31 minutes to read

The Table API provides endpoints that allow you to perform create,
read, update, and delete (CRUD) operations on existing tables.

The calling user must have sufficient roles to access the data in the table specified in the
request.

View a list of all tables by navigating to System DefinitionTables, or in the drop-down tableName path parameter for any Table API endpoint in the REST API Explorer.

## Table - DELETE /now/table/{tableName}/{sys_id} {#ariaid-title2}

Deletes the specified record from the specified table.

### URL format {#table-DELETE__section_ls4_vk5_wlb}

Versioned URL:
/api/now/{api_version}/table/{tableName}/{sys_id}

Default URL:
/api/now/table/{tableName}/{sys_id}  
Note:  
Available versions are specified in the [REST API Explorer](https://www.servicenow.com/docs/zBKcyeP3If8_~R67hD_ZHg "In this tutorial you will use the REST API Explorer to test the ServiceNow REST APIs."). For scripted REST APIs there is additional version information on the [Scripted REST Service form](https://www.servicenow.com/docs/Zk3PxcZ0l8CqUYfw7mHiLg "The scripted REST API feature allows application developers to build custom web service APIs.").

### Supported request parameters

{#table-DELETE__entry__2}{#table-DELETE__version-not_optional-RESTAPI}

| Name | Description |
|-|-|
| api_version | Optional. Version of the endpoint to access. For example, <kbd class="ph userinput">v1</kbd> or <kbd class="ph userinput">v2</kbd>. Only specify this value to use an endpoint version other than the latest. Data type: String |
| sys_id | Sys_id of the record to delete. Data type: String |
| tableName | Name of the table from which to delete the specified record, such as "incident" or "asset". Data type: String |
[Table 1. Path parameters]

{#table-DELETE__entry__10}

| Name | Description |
|-|-|
| sysparm_query_no_domain | Flag that indicates whether to restrict the record search to only the domains for which the logged in user is configured. Valid values: * false: Exclude the record if it is in a domain that the currently logged in user is not configured to access. * true: Include the record even if it is in a domain that the currently logged in user is not configured to access. {#table-DELETE__ul_pxp_3c1_3nb} Data type: Boolean Default: false Note: The sysparm_query_no_domain parameter is available only to system administrators or users who have the query_no_domain_table_api role. |
[Table 2. Query parameters]

{#table-DELETE__entry__14}

| Name | Description |
|-|-|
| None |   |
[Table 3. Request body parameters (XML or JSON)]

### Headers

The following request and response headers apply to this HTTP
action only, or apply to this action in a distinct way. For a list of general headers used
in the REST API, see [Supported REST API headers](https://www.servicenow.com/docs/qh7RcF0RI6a~i9u3octdlg "REST (REpresentational State Transfer) is a simple stateless architecture that provides standards between computer systems on the web, making it easier for them to communicate with each other.").
{#table-DELETE__entry__18}{#table-DELETE__accept-RESTAPI}

| Header | Description |
|-|-|
| Accept | Data format of the response body. Supported types: application/json or application/xml. Default: application/json |
[Table 4. Request headers]

{#table-DELETE__entry__22}

| Header | Description |
|-|-|
| None |   |
[Table 5. Response headers]

### Status codes

The following status codes apply to this HTTP action. For a
list of possible status codes used in the REST API, see [REST API HTTP response
codes](https://www.servicenow.com/docs/qh7RcF0RI6a~i9u3octdlg "REST (REpresentational State Transfer) is a simple stateless architecture that provides standards between computer systems on the web, making it easier for them to communicate with each other.").
{#table-DELETE__entry__26}

| Status code | Description |
|-|-|
| 204 | Indicates that the request completed successfully. |
[Table 6. Status codes]

### Response body parameters (JSON or XML)

{#table-DELETE__entry__30}

| Name | Description |
|-|-|
| None |   |
[ ]

### cURL request

Delete a record from the Incident table.

    curl "https://instance.servicenow.com/api/now/table/incident/d977b66a4f411200adf9f8e18110c7b2" \
    --request DELETE \
    --header "Accept:application/json" \
    --user 'username':'password'

There is no response body.

    None

## Table - GET /now/table/{tableName} {#ariaid-title3}

Retrieves multiple records for the specified table.
For basic instructions, see [Retrieve existing incidents](https://www.servicenow.com/docs/zBKcyeP3If8_~R67hD_ZHg "In this tutorial you will use the REST API Explorer to test the ServiceNow REST APIs.").

### URL format

Versioned URL:
/api/now/{api_version}/table/{tableName}

Default URL:
/api/now/table/{tableName}  
Note:  
Available versions are specified in the [REST API Explorer](https://www.servicenow.com/docs/zBKcyeP3If8_~R67hD_ZHg "In this tutorial you will use the REST API Explorer to test the ServiceNow REST APIs."). For scripted REST APIs there is additional version information on the [Scripted REST Service form](https://www.servicenow.com/docs/Zk3PxcZ0l8CqUYfw7mHiLg "The scripted REST API feature allows application developers to build custom web service APIs.").

### Supported request parameters

{#table-GET__entry__2}{#table-GET__version-not_optional-RESTAPI}

| Name | Description |
|-|-|
| api_version | Optional. Version of the endpoint to access. For example, <kbd class="ph userinput">v1</kbd> or <kbd class="ph userinput">v2</kbd>. Only specify this value to use an endpoint version other than the latest. Depending on the version, this endpoint returns different results on a valid query. * Version 1 returns error code 404 with no results. * Version 2 returns success code 200 and an empty array as the response body. {#table-GET__ul_byj_5kw_w4b} Data type: String |
| tableName | Name of the table from which to retrieve the records. Data type: String |
[Table 7. Path parameters]

{#table-GET__entry__8}{#table-GET__rest_api_sysparm_display_value_param}{#table-GET__rest_api_sysparm_exclude_reference_link}{#table-GET__rest_api_sysparm_fields_param}{#table-GET__sysparm-limit-RESTAPI}{#table-GET__sysparm_offset-ph-RESTAPI}{#table-GET__rest_api_sysparm_query_param}{#table-GET__rest_api_param_sysparm_suppress_pagination}

| Name | Description |
|-|-|
| name-value pairs | Name-value pairs to use to filter the result set. This parameter is mutually exclusive with sysparm_query. For example, instead of using `&sysparm_query=active=true`, you can simplify the calling statement by using `&active=true`. You can also use the display value when the field is a choice or reference type field, such as `&state=closed` instead of `&state=7`. To specify multiple key-value pairs, separate each with an ampersand, such as `&active=true&assigned_to=john.smith`. Data type: String |
| sysparm_display_value | Determines the type of data returned, either the actual values from the database or the display values of the fields. Display values are manipulated based on the actual value in the database and user or system settings and preferences. If returning display values, the value that is returned is dependent on the field type. * Choice fields: The database value may be a number, but the display value will be more descriptive. * Date fields: The database value is in UTC format, while the display value is based on the user's time zone. * Encrypted text: The database value is encrypted, while the displayed value is unencrypted based on the user's encryption context. * Reference fields: The database value is sys_id, but the display value is a display field of the referenced record. Data type: String Valid values: * true: Returns the display values for all fields. * false: Returns the actual values from the database. * all: Returns both actual and display values. {#table-GET__ul_vzj_1pw_pp} Default: false Note: There is no preferred method for setting this parameter. However, specifying the display value may cause performance issues since it is not reading directly from the database and may include referencing other fields and records. For more information on display values and actual values, see [Table API FAQs (KB0534905).](https://support.servicenow.com/kb_view.do?sysparm_article=KB0534905) |
| sysparm_exclude_reference_link | Flag that indicates whether to exclude Table API links for reference fields. Valid values: * true: Exclude Table API links for reference fields. * false: Include Table API links for reference fields. {#table-GET__ul_llg_cnr_tgb} Data type: Boolean Default: false |
| sysparm_fields | Comma-separated list of fields to return in the response. Invalid fields are ignored. Data type: String Default: Return all fields. |
| sysparm_limit | Maximum number of records to return. For requests that exceed this number of records, use the sysparm_offset parameter to paginate record retrieval. This limit is applied before ACL evaluation. If no records return, including records you have access to, rearrange the record order so records you have access to return first. Note: Unusually large sysparm_limit values can impact system performance. Data type: Number Default: 10000 |
| sysparm_no_count | Flag that indicates whether to execute a `select count(*)` query on the table to return the number of rows in the associated table. Valid values: * true: Do not execute a `select count(*)`. * false: Execute a `select count(*)`. {#table-GET__ul_j2x_wm1_3nb} Data type: Boolean Default: false |
| sysparm_offset | Starting record index for which to begin retrieving records. Use this value to paginate record retrieval. This functionality enables the retrieval of all records, regardless of the number of records, in small manageable chunks. For example, the first time you call this endpoint, sysparm_offset is set to "0". To simply page through all available records, use `sysparm_offset=sysparm_offset+sysparm_limit`, until you reach the end of all records.{#table-GET__sysparm_offset-p-RESTAPI} Don't pass a negative number in the sysparm_offset parameter. Data type: Number Default: 0 |
| sysparm_query | [Encoded query](https://www.servicenow.com/docs/access?context=c_EncodedQueryStrings&version=australia&pubname=australia-platform-user-interface&ft:locale=en-US) used to filter the result set. You can use a UI filter to obtain a properly encoded query. Syntax: `sysparm_query=<col_name><operator><value>`. Column names, operators, and values are case-sensitive. * \<col_name\>: Name of the table column to filter on. * \<operator\>: Supports the following values: * `=`: \<col_name\> exactly matches \<value\>. * `!=`: \<col_name\> does not match \<value\>. * `LIKE`: \<col_name\> contains the specified string \<value\>. Only works for \<col_name\> fields whose data type is string. * `STARTSWITH`: \<col_name\> starts with the specified string \<value\>. Only works for \<col_name\> fields whose data type is string. * `ENDSWITH`: \<col_name\> ends with the specified string \<value\>. Only works for \<col_name\> fields whose data type is string. * `^`: AND operator to add an additional query condition. Records included in the result set match both conditions. * `^OR`: OR operator to add an additional query condition. Records included in the result set match at least one of the conditions. {#table-GET__ul_bgf_5vz_mlb} * \<value\>: Value to filter on. {#table-GET__ul_g2p_svz_mlb}For more information about operators, see [Operators available for filters and queries](https://www.servicenow.com/docs/access?context=r_OpAvailableFiltersQueries&version=australia&pubname=australia-platform-user-interface&ft:locale=en-US). Queries can contain multiple conditions. For example, the following query returns records where the caller is the current user and the record is active. `sysparm_query=caller_id=javascript:gs.getUserID()^active=true` Encoded queries also support order by ascending and descending functionality. To sort responses based on certain fields, use the `ORDERBY` and `ORDERBYDESC` clauses in sysparm_query. Syntax: * `ORDERBY<col_name>` * `ORDERBYDESC<col_name>` {#table-GET__ul_sq4_rc1_nlb} For example, the following query gets all active records and orders the results in ascending order by number, and then in descending order by category. `sysparm_query=active=true^ORDERBYnumber^ORDERBYDESCcategory` By default, if part of a query is invalid, such as an invalid field name, the instance ignores the invalid part. It then returns rows using only the valid portion of the query. Set the property glide.invalid_query.returns_no_rows to <kbd class="ph userinput">true</kbd> to instead return no rows on an invalid query. Note: The glide.invalid_query.returns_no_rows property controls the behavior of all queries across the instance, such as in lists, scripts (GlideRecord.query()), and web service APIs. Data type: String |
| sysparm_query_category | Name of the category to use for queries. Data type: String |
| sysparm_query_no_domain | Flag that indicates whether to restrict the record search to only the domains for which the logged in user is configured. Valid values: * false: Exclude the record if it is in a domain that the currently logged in user is not configured to access. * true: Include the record even if it is in a domain that the currently logged in user is not configured to access. {#table-GET__ul_pxp_3c1_3nb} Data type: Boolean Default: false Note: The sysparm_query_no_domain parameter is available only to system administrators or users who have the query_no_domain_table_api role. |
| sysparm_suppress_pagination_header | Flag that indicates whether to remove the Link header from the response. The Link header provides various URLs to relative pages in the record set which you can use to paginate the returned record set. Valid values: * true: Remove the Link header from the response. * false: Do not remove the Link header from the response. {#table-GET__ul_pmz_vbl_tgb} Data type: Boolean Default: false |
| sysparm_view | UI view for which to render the data. Determines the fields returned in the response. Valid values: * desktop * mobile * both {#table-GET__ul_wr5_5xl_tgb} If you also specify the sysparm_fields parameter, it takes precedent. Data type: String |
[Table 8. Query parameters]

{#table-GET__entry__34}

| Name | Description |
|-|-|
| None |   |
[Table 9. Request body parameters (XML or JSON)]

### Headers

The following request and response headers apply to this HTTP
action only, or apply to this action in a distinct way. For a list of general headers used
in the REST API, see [Supported REST API headers](https://www.servicenow.com/docs/qh7RcF0RI6a~i9u3octdlg "REST (REpresentational State Transfer) is a simple stateless architecture that provides standards between computer systems on the web, making it easier for them to communicate with each other.").
{#table-GET__entry__38}{#table-GET__accept-RESTAPI}

| Header | Description |
|-|-|
| Accept | Data format of the response body. Supported types: application/json or application/xml. Default: application/json |
[Table 10. Request headers]

{#table-GET__entry__42}

| Header | Description |
|-|-|
| Link | Relative URLs, based on the previous request, that you can use to page through the available record set. For example: `https://<instance name>.servicenow.com/api/now/table/cmdb_ci?sysparm_offset=40&sysparm_limit=1000>;rel="next"`, `https://<instance name>.servicenow.com/api/now/table/cmdb_ci?sysparm_offset=40&sysparm_limit=1000>;rel="prev"`, `https://<instance name>.servicenow.com/api/now/table/cmdb_ci?sysparm_offset=0&sysparm_limit=1000>;rel="first"`, `https://<instance name>.servicenow.com/api/now/table/cmdb_ci?sysparm_offset=2780&sysparm_limit=1000>;rel="last"` For additional information on the rel parameter, refer to <https://html.spec.whatwg.org/multipage/links.html#linkTypes>. |
| X-Total-Count | Total count of records returned by the query. |
[Table 11. Response headers]

### Status codes

The following status codes apply to this HTTP action. For a
list of possible status codes used in the REST API, see [REST API HTTP response
codes](https://www.servicenow.com/docs/qh7RcF0RI6a~i9u3octdlg "REST (REpresentational State Transfer) is a simple stateless architecture that provides standards between computer systems on the web, making it easier for them to communicate with each other.").
{#table-GET__entry__48}

| Status code | Description |
|-|-|
| 200 | Request completed successfully. If a valid query returned no results, the response body contains only an empty result array. |
[Table 12. Status codes]

### Response body parameters (JSON or XML)

{#table-GET__entry__52}

| Parameter | Description |
|-|-|
| name-value pairs | Field names and values of all parameters within the specified record or those specified in the query parameters. |
[ ]

### cURL request

Retrieve the first record from the Problem table.

    curl "https://instance.servicenow.com/api/now/table/problem?sysparm_limit=1" \
    --request GET \
    --header "Accept:application/json" \
    --user 'username':'password'

The response contains the name-value pairs for the requested record.

    {
      "result": [
        {
          "parent": "",
          "made_sla": "true",
          "watch_list": "",
          "upon_reject": "cancel",
          "sys_updated_on": "2016-01-19 04:52:04",
          "approval_history": "",
          "number": "PRB0000050",
          "sys_updated_by": "glide.maint",
          "opened_by": {
            "link": "https://instance.servicenow.com/api/now/table/sys_user/glide.maint",
            "value": "glide.maint"
          },
          "user_input": "",
          "sys_created_on": "2016-01-19 04:51:19",
          "sys_domain": {
            "link": "https://instance.servicenow.com/api/now/table/sys_user_group/global",
            "value": "global"
          },
          "state": "4",
          "sys_created_by": "glide.maint",
          "knowledge": "false",
          "order": "",
          "closed_at": "2016-01-19 04:52:04",
          "cmdb_ci": {
            "link": "https://instance.servicenow.com/api/now/table/cmdb_ci/55b35562c0a8010e01cff22378e0aea9",
            "value": "55b35562c0a8010e01cff22378e0aea9"
          },
          "delivery_plan": "",
          "impact": "3",
          "active": "false",
          "work_notes_list": "",
          "business_service": "",
          "priority": "4",
          "sys_domain_path": "/",
          "time_worked": "",
          "expected_start": "",
          "rejection_goto": "",
          "opened_at": "2016-01-19 04:49:47",
          "business_duration": "1970-01-01 00:00:00",
          "group_list": "",
          "work_end": "",
          "approval_set": "",
          "wf_activity": "",
          "work_notes": "",
          "short_description": "Switch occasionally drops connections",
          "correlation_display": "",
          "delivery_task": "",
          "work_start": "",
          "assignment_group": "",
          "additional_assignee_list": "",
          "description": "Switch occasionally drops connections",
          "calendar_duration": "1970-01-01 00:02:17",
          "close_notes": "updated firmware",
          "sys_class_name": "problem",
          "closed_by": "",
          "follow_up": "",
          "sys_id": "04ce72c9c0a8016600b5b7f75ac67b5b",
          "contact_type": "phone",
          "urgency": "3",
          "company": "",
          "reassignment_count": "",
          "activity_due": "",
          "assigned_to": "",
          "comments": "",
          "approval": "not requested",
          "sla_due": "",
          "comments_and_work_notes": "",
          "due_date": "",
          "sys_mod_count": "1",
          "sys_tags": "",
          "escalation": "0",
          "upon_approval": "proceed",
          "correlation_id": "",
          "location": ""
        }
      ]
    }

## Table - GET /now/table/{tableName}/{sys_id} {#ariaid-title4}

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

### URL format {#table-GET-id__section_rg1_dcv_wlb}

Versioned URL:
/api/now/{api_version}/table/{tableName}/{sys_id}

Default URL:
/api/now/table/{tableName}/{sys_id}  
Note:  
Available versions are specified in the [REST API Explorer](https://www.servicenow.com/docs/zBKcyeP3If8_~R67hD_ZHg "In this tutorial you will use the REST API Explorer to test the ServiceNow REST APIs."). For scripted REST APIs there is additional version information on the [Scripted REST Service form](https://www.servicenow.com/docs/Zk3PxcZ0l8CqUYfw7mHiLg "The scripted REST API feature allows application developers to build custom web service APIs.").

### Supported request parameters

{#table-GET-id__entry__2}{#table-GET-id__version-not_optional-RESTAPI}

| Name | Description |
|-|-|
| api_version | Optional. Version of the endpoint to access. For example, <kbd class="ph userinput">v1</kbd> or <kbd class="ph userinput">v2</kbd>. Only specify this value to use an endpoint version other than the latest. Data type: String |
| sys_id | Sys_id of the record to retrieve. Data type: String |
| tableName | Name of the table from which to retrieve the record. Data type: String |
[Table 13. Path parameters]

{#table-GET-id__entry__10}

| Name | Description |
|-|-|
| sysparm_display_value | Determines the type of data returned, either the actual values from the database or the display values of the fields. Display values are manipulated based on the actual value in the database and user or system settings and preferences. If returning display values, the value that is returned is dependent on the field type. * Choice fields: The database value may be a number, but the display value will be more descriptive. * Date fields: The database value is in UTC format, while the display value is based on the user's time zone. * Encrypted text: The database value is encrypted, while the displayed value is unencrypted based on the user's encryption context. * Reference fields: The database value is sys_id, but the display value is a display field of the referenced record. Data type: String Valid values: * true: Returns the display values for all fields. * false: Returns the actual values from the database. * all: Returns both actual and display values. {#table-GET-id__ul_vzj_1pw_pp} Default: false Note: There is no preferred method for setting this parameter. However, specifying the display value may cause performance issues since it is not reading directly from the database and may include referencing other fields and records. For more information on display values and actual values, see [Table API FAQs (KB0534905).](https://support.servicenow.com/kb_view.do?sysparm_article=KB0534905) |
| sysparm_exclude_reference_link | Flag that indicates whether to exclude Table API links for reference fields. Valid values: * true: Exclude Table API links for reference fields. * false: Include Table API links for reference fields. {#table-GET-id__ul_llg_cnr_tgb} Data type: Boolean Default: false |
| sysparm_fields | Comma-separated list of fields to return in the response. Invalid fields are ignored. Data type: String Default: Return all fields. |
| sysparm_query_no_domain | Flag that indicates whether to restrict the record search to only the domains for which the logged in user is configured. Valid values: * false: Exclude the record if it is in a domain that the currently logged in user is not configured to access. * true: Include the record even if it is in a domain that the currently logged in user is not configured to access. {#table-GET-id__ul_pxp_3c1_3nb} Data type: Boolean Default: false Note: The sysparm_query_no_domain parameter is available only to system administrators or users who have the query_no_domain_table_api role. |
| sysparm_view | UI view for which to render the data. Determines the fields returned in the response. Valid values: * desktop * mobile * both {#table-GET-id__ul_wr5_5xl_tgb} If you also specify the sysparm_fields parameter, it takes precedent. Data type: String |
[Table 14. Query parameters]

{#table-GET-id__entry__22}

| Name | Description |
|-|-|
| None |   |
[Table 15. Request body parameters (XML or JSON)]

### Headers

The following request and response headers apply to this HTTP
action only, or apply to this action in a distinct way. For a list of general headers used
in the REST API, see [Supported REST API headers](https://www.servicenow.com/docs/qh7RcF0RI6a~i9u3octdlg "REST (REpresentational State Transfer) is a simple stateless architecture that provides standards between computer systems on the web, making it easier for them to communicate with each other.").
{#table-GET-id__entry__26}{#table-GET-id__accept-RESTAPI}

| Header | Description |
|-|-|
| Accept | Data format of the response body. Supported types: application/json or application/xml. Default: application/json |
[Table 16. Request headers]

{#table-GET-id__entry__30}

| Header | Description |
|-|-|
| None |   |
[Table 17. Response headers]

### Status codes

The following status codes apply to this HTTP action. For a
list of possible status codes used in the REST API, see [REST API HTTP response
codes](https://www.servicenow.com/docs/qh7RcF0RI6a~i9u3octdlg "REST (REpresentational State Transfer) is a simple stateless architecture that provides standards between computer systems on the web, making it easier for them to communicate with each other.").
{#table-GET-id__entry__34}

| Status code | Description |
|-|-|
| 200 | Successful. The request was successfully processed. |
| 404 | Not found. The requested item wasn't found. |
[Table 18. Status codes]

### Response body parameters (JSON or XML)

{#table-GET-id__entry__40}

| Parameter | Description |
|-|-|
| name-value pairs | Field names and values of all parameters within the specified record or those specified in the query parameters. |
[ ]

### cURL request

Retrieve a record from the Incident table.

    curl "https://instance.servicenow.com/api/now/table/incident/a9e30c7dc61122760116894de7bcc7bd" \
    --request GET \
    --header "Accept:application/json" \
    --user 'username':'password'

The response contains the name-value pairs for the requested record.

    {
      "result": {
        "upon_approval": "",
        "location": {
          "link": "https://instance.servicenow.com/api/now/table/cmn_location/105cf7f3c611227501e75e08b14a38ba",
          "value": "105cf7f3c611227501e75e08b14a38ba"
        },
        "expected_start": "",
        "reopen_count": "",
        "close_notes": "",
        "additional_assignee_list": "",
        "impact": "1",
        "urgency": "3",
        "correlation_id": "",
        "sys_tags": "",
        "sys_domain": {
          "link": "https://instance.servicenow.com/api/now/table/sys_user_group/global",
          "value": "global"
        },
        "description": "",
        "group_list": "",
        "priority": "3",
        "delivery_plan": "",
        "sys_mod_count": "4",
        "work_notes_list": "",
        "business_service": "",
        "follow_up": "",
        "closed_at": "",
        "sla_due": "2015-11-11 22:04:15",
        "delivery_task": "",
        "sys_updated_on": "2015-11-01 22:37:27",
        "parent": "",
        "work_end": "",
        "number": "INC0000046",
        "closed_by": "",
        "work_start": "",
        "calendar_stc": "",
        "category": "software",
        "business_duration": "",
        "incident_state": "1",
        "activity_due": "",
        "correlation_display": "",
        "company": "",
        "active": "true",
        "due_date": "",
        "assignment_group": {
          "link": "https://instance.servicenow.com/api/now/table/sys_user_group/8a4dde73c6112278017a6a4baf547aa7",
          "value": "8a4dde73c6112278017a6a4baf547aa7"
        },
        "caller_id": {
          "link": "https://instance.servicenow.com/api/now/table/sys_user/46c6f9efa9fe198101ddf5eed9adf6e7",
          "value": "46c6f9efa9fe198101ddf5eed9adf6e7"
        },
        "knowledge": "false",
        "made_sla": "false",
        "comments_and_work_notes": "",
        "parent_incident": "",
        "state": "1",
        "user_input": "",
        "sys_created_on": "2015-11-01 22:05:30",
        "approval_set": "",
        "reassignment_count": "1",
        "rfc": "",
        "child_incidents": "",
        "opened_at": "2015-11-02 22:04:15",
        "short_description": "Can't access SFA software",
        "order": "",
        "sys_updated_by": "glide.maint",
        "resolved_by": "",
        "notify": "1",
        "upon_reject": "",
        "approval_history": "",
        "problem_id": {
          "link": "https://instance.servicenow.com/api/now/table/problem/a9e4890bc6112276003d7a5a5c774a74",
          "value": "a9e4890bc6112276003d7a5a5c774a74"
        },
        "work_notes": "",
        "calendar_duration": "",
        "close_code": "",
        "sys_id": "a9e30c7dc61122760116894de7bcc7bd",
        "approval": "not requested",
        "caused_by": "",
        "severity": "3",
        "sys_created_by": "admin",
        "resolved_at": "",
        "assigned_to": "",
        "business_stc": "",
        "wf_activity": "",
        "sys_domain_path": "/",
        "cmdb_ci": {
          "link": "https://instance.servicenow.com/api/now/table/cmdb_ci/a9c0c8d2c6112276018f7705562f9cb0",
          "value": "a9c0c8d2c6112276018f7705562f9cb0"
        },
        "opened_by": {
          "link": "https://instance.servicenow.com/api/now/table/sys_user/46c6f9efa9fe198101ddf5eed9adf6e7",
          "value": "46c6f9efa9fe198101ddf5eed9adf6e7"
        },
        "subcategory": "",
        "rejection_goto": "",
        "sys_class_name": "incident",
        "watch_list": "",
        "time_worked": "",
        "contact_type": "phone",
        "escalation": "0",
        "comments": ""
      }
    }

## Table - PATCH /now/table/{tableName}/{sys_id} {#ariaid-title5}

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

### URL format {#table-PATCH__section_jmq_j2v_wlb}

Versioned URL:
/api/now/{api_version}/table/{tableName}/{sys_id}

Default URL:
/api/now/table/{tableName}/{sys_id}  
Note:  
Available versions are specified in the [REST API Explorer](https://www.servicenow.com/docs/zBKcyeP3If8_~R67hD_ZHg "In this tutorial you will use the REST API Explorer to test the ServiceNow REST APIs."). For scripted REST APIs there is additional version information on the [Scripted REST Service form](https://www.servicenow.com/docs/Zk3PxcZ0l8CqUYfw7mHiLg "The scripted REST API feature allows application developers to build custom web service APIs.").

### Supported request parameters

{#table-PATCH__entry__2}{#table-PATCH__version-not_optional-RESTAPI}

| Name | Description |
|-|-|
| api_version | Optional. Version of the endpoint to access. For example, <kbd class="ph userinput">v1</kbd> or <kbd class="ph userinput">v2</kbd>. Only specify this value to use an endpoint version other than the latest. Data type: String |
| sys_id | Sys_id of the record to update. Data type: String |
| tableName | Name of the table in which to the specified record is located. Data type: String |
[Table 19. Path parameters]

{#table-PATCH__entry__10}

| Name | Description |
|-|-|
| sysparm_display_value | Determines the type of data returned, either the actual values from the database or the display values of the fields. Display values are manipulated based on the actual value in the database and user or system settings and preferences. If returning display values, the value that is returned is dependent on the field type. * Choice fields: The database value may be a number, but the display value will be more descriptive. * Date fields: The database value is in UTC format, while the display value is based on the user's time zone. * Encrypted text: The database value is encrypted, while the displayed value is unencrypted based on the user's encryption context. * Reference fields: The database value is sys_id, but the display value is a display field of the referenced record. Data type: String Valid values: * true: Returns the display values for all fields. * false: Returns the actual values from the database. * all: Returns both actual and display values. {#table-PATCH__ul_vzj_1pw_pp} Default: false Note: There is no preferred method for setting this parameter. However, specifying the display value may cause performance issues since it is not reading directly from the database and may include referencing other fields and records. For more information on display values and actual values, see [Table API FAQs (KB0534905).](https://support.servicenow.com/kb_view.do?sysparm_article=KB0534905) |
| sysparm_fields | Comma-separated list of fields to return in the response. Invalid fields are ignored. Data type: String Default: Return all fields. |
| sysparm_input_display_value | Flag that indicates whether to set field values using the display value or the actual value. Depending on the different types of fields, the endpoint may manipulate the passed in display values to store the proper values in the database. For example, if you send the display name for a reference field, the endpoint stores the sys_id for that value in the database. For date and time fields, when this parameter is true, the date and time value is adjusted for the current user's timezone. When false, the date and time value is inserted using the GMT timezone. Valid values: * true: Treats input values as display values and they are manipulated so they are stored properly in the database. * false: Treats input values as actual values and stores them in the database without manipulation. {#table-PATCH__ul_shq_cfx_pp} Data type: Boolean Default: false - This matches the data type that is returned during data retrieval (GET methods), which is the actual values. Note: To set the value of an encrypted field, you must set this parameter to <kbd class="ph userinput">true</kbd>. If this parameter is not set to true, values submitted to encrypted fields are not saved. Additionally, the requesting user must have the appropriate encryption context prior to submitting the request. Encrypted fields are hidden for users without the appropriate encryption context. For more information on field encryption see [Encryption](https://www.servicenow.com/docs/access?context=encryption-landing&version=australia&pubname=australia-platform-security&ft:locale=en-US). |
| sysparm_query_no_domain | Flag that indicates whether to restrict the record search to only the domains for which the logged in user is configured. Valid values: * false: Exclude the record if it is in a domain that the currently logged in user is not configured to access. * true: Include the record even if it is in a domain that the currently logged in user is not configured to access. {#table-PATCH__ul_pxp_3c1_3nb} Data type: Boolean Default: false Note: The sysparm_query_no_domain parameter is available only to system administrators or users who have the query_no_domain_table_api role. |
| sysparm_view | UI view for which to render the data. Determines the fields returned in the response. Valid values: * desktop * mobile * both {#table-PATCH__ul_wr5_5xl_tgb} If you also specify the sysparm_fields parameter, it takes precedent. Data type: String |
[Table 20. Query parameters]

{#table-PATCH__entry__22}

| Name | Description |
|-|-|
| name-value pairs | Field name and the new value for each parameter to update in the specified record. Note: All fields within a record may not be available for update. For example, fields that have a prefix of "sys_" are typically system parameters that are automatically generated and cannot be updated. |
[Table 21. Request body parameters (XML or JSON)]

### Headers

The following request and response headers apply to this HTTP
action only, or apply to this action in a distinct way. For a list of general headers used
in the REST API, see [Supported REST API headers](https://www.servicenow.com/docs/qh7RcF0RI6a~i9u3octdlg "REST (REpresentational State Transfer) is a simple stateless architecture that provides standards between computer systems on the web, making it easier for them to communicate with each other.").
{#table-PATCH__entry__26}{#table-PATCH__accept-RESTAPI}{#table-PATCH__content_type-RESTAPI}

| Header | Description |
|-|-|
| Accept | Data format of the response body. Supported types: application/json or application/xml. Default: application/json |
| Content-Type | Data format of the request body. Supported types: application/json or application/xml. Default: application/json |
| X-no-response-body | By default, responses include body content detailing the modified record. Set this request header to true to suppress the response body. |
[Table 22. Request headers]

{#table-PATCH__entry__34}

| Header | Description |
|-|-|
| None |   |
[Table 23. Response headers]

### Status codes

The following status codes apply to this HTTP action. For a
list of possible status codes used in the REST API, see [REST API HTTP response
codes](https://www.servicenow.com/docs/qh7RcF0RI6a~i9u3octdlg "REST (REpresentational State Transfer) is a simple stateless architecture that provides standards between computer systems on the web, making it easier for them to communicate with each other.").
{#table-PATCH__entry__38}{#table-PATCH__entry-200-status-code}{#table-PATCH__entry-400-status-code}{#table-PATCH__entry-404-status-code}

| Status code | Description |
|-|-|
| 200 | Successful. The request was successfully processed. |
| 400 | Bad Request. A bad request type or malformed request was detected. |
| 404 | Not found. The requested item wasn't found. |
[Table 24. Status codes]

### Response body parameters (JSON or XML)

{#table-PATCH__entry__46}

| Name | Description |
|-|-|
| name-value pairs | Field names and values of all parameters within the specified record or those specified in the query parameters. |
[ ]

### cURL request

Update a record in the Incident table.

    curl "https://instance.servicenow.com/api/now/table/incident/ef43c6d40a0a0b5700c77f9bf387afe3" \
    --request PATCH \
    --header "Accept:application/json" \
    --header "Content-Type:application/json" \
    --data "{'assigned_to':'681b365ec0a80164000fb0b05854a0cd','urgency':'1','comments':'Elevating urgency, this is a blocking issue'}" \
    --user 'username':'password'

The response contains the name-value pairs for the updated record.

    {
      "result": {
        "upon_approval": "proceed",
        "location": {
          "link": "https://instance.servicenow.com/api/now/table/cmn_location/108752c8c611227501d4ab0e392ba97f",
          "value": "108752c8c611227501d4ab0e392ba97f"
        },
        "expected_start": "",
        "reopen_count": "",
        "close_notes": "",
        "additional_assignee_list": "",
        "impact": "1",
        "urgency": "1",
        "correlation_id": "",
        "sys_tags": "",
        "sys_domain": {
          "link": "https://instance.servicenow.com/api/now/table/sys_user_group/global",
          "value": "global"
        },
        "description": "",
        "group_list": "",
        "priority": "1",
        "delivery_plan": "",
        "sys_mod_count": "7",
        "work_notes_list": "",
        "business_service": "",
        "follow_up": "",
        "closed_at": "",
        "sla_due": "2017-07-05 05:58:24",
        "delivery_task": "",
        "sys_updated_on": "2016-01-22 14:12:37",
        "parent": "",
        "work_end": "",
        "number": "INC0000050",
        "closed_by": "",
        "work_start": "",
        "calendar_stc": "",
        "category": "hardware",
        "business_duration": "",
        "incident_state": "2",
        "activity_due": "2016-01-22 16:12:37",
        "correlation_display": "",
        "company": {
          "link": "https://instance.servicenow.com/api/now/table/core_company/31bea3d53790200044e0bfc8bcbe5dec",
          "value": "31bea3d53790200044e0bfc8bcbe5dec"
        },
        "active": "true",
        "due_date": "",
        "assignment_group": {
          "link": "https://instance.servicenow.com/api/now/table/sys_user_group/8a5055c9c61122780043563ef53438e3",
          "value": "8a5055c9c61122780043563ef53438e3"
        },
        "caller_id": {
          "link": "https://instance.servicenow.com/api/now/table/sys_user/5b7c200d0a640069006b3845b5d0fa7c",
          "value": "5b7c200d0a640069006b3845b5d0fa7c"
        },
        "knowledge": "false",
        "made_sla": "true",
        "comments_and_work_notes": "",
        "parent_incident": "",
        "state": "2",
        "user_input": "",
        "sys_created_on": "2015-11-02 18:05:40",
        "approval_set": "",
        "reassignment_count": "0",
        "rfc": "",
        "child_incidents": "",
        "opened_at": "2015-11-02 21:58:24",
        "short_description": "Can't access Exchange server - is it down?",
        "order": "",
        "sys_updated_by": "admin",
        "resolved_by": "",
        "notify": "1",
        "upon_reject": "cancel",
        "approval_history": "",
        "problem_id": "",
        "work_notes": "",
        "calendar_duration": "",
        "close_code": "",
        "sys_id": "ef43c6d40a0a0b5700c77f9bf387afe3",
        "approval": "not requested",
        "caused_by": "",
        "severity": "3",
        "sys_created_by": "glide.maint",
        "resolved_at": "",
        "assigned_to": {
          "link": "https://instance.servicenow.com/api/now/table/sys_user/681b365ec0a80164000fb0b05854a0cd",
          "value": "681b365ec0a80164000fb0b05854a0cd"
        },
        "business_stc": "",
        "wf_activity": "",
        "sys_domain_path": "/",
        "cmdb_ci": {
          "link": "https://instance.servicenow.com/api/now/table/cmdb_ci/281190e3c0a8000b003f593aa3f20ca6",
          "value": "281190e3c0a8000b003f593aa3f20ca6"
        },
        "opened_by": {
          "link": "https://instance.servicenow.com/api/now/table/sys_user/glide.maint",
          "value": "glide.maint"
        },
        "subcategory": "",
        "rejection_goto": "",
        "sys_class_name": "incident",
        "watch_list": "",
        "time_worked": "",
        "contact_type": "phone",
        "escalation": "3",
        "comments": ""
      }
    }

## Table - POST /now/table/{tableName} {#ariaid-title6}

Inserts one record in the specified table. Multiple record insertion is not supported
by this method.

### URL format {#table-POST__section_pxb_vfv_wlb}

Versioned URL:
/api/now/{api_version}/table/{tableName}

Default URL:
/api/now/table/{tableName}  
Note:  
Available versions are specified in the [REST API Explorer](https://www.servicenow.com/docs/zBKcyeP3If8_~R67hD_ZHg "In this tutorial you will use the REST API Explorer to test the ServiceNow REST APIs."). For scripted REST APIs there is additional version information on the [Scripted REST Service form](https://www.servicenow.com/docs/Zk3PxcZ0l8CqUYfw7mHiLg "The scripted REST API feature allows application developers to build custom web service APIs.").

### Supported request parameters

{#table-POST__entry__2}{#table-POST__version-not_optional-RESTAPI}

| Name | Description |
|-|-|
| api_version | Optional. Version of the endpoint to access. For example, <kbd class="ph userinput">v1</kbd> or <kbd class="ph userinput">v2</kbd>. Only specify this value to use an endpoint version other than the latest. Data type: String |
| tableName | Name of the table in which to save the record. Data type: String |
[Table 25. Path parameters]

{#table-POST__entry__8}

| Name | Description |
|-|-|
| sysparm_display_value | Determines the type of data returned, either the actual values from the database or the display values of the fields. Display values are manipulated based on the actual value in the database and user or system settings and preferences. If returning display values, the value that is returned is dependent on the field type. * Choice fields: The database value may be a number, but the display value will be more descriptive. * Date fields: The database value is in UTC format, while the display value is based on the user's time zone. * Encrypted text: The database value is encrypted, while the displayed value is unencrypted based on the user's encryption context. * Reference fields: The database value is sys_id, but the display value is a display field of the referenced record. Data type: String Valid values: * true: Returns the display values for all fields. * false: Returns the actual values from the database. * all: Returns both actual and display values. {#table-POST__ul_vzj_1pw_pp} Default: false Note: There is no preferred method for setting this parameter. However, specifying the display value may cause performance issues since it is not reading directly from the database and may include referencing other fields and records. For more information on display values and actual values, see [Table API FAQs (KB0534905).](https://support.servicenow.com/kb_view.do?sysparm_article=KB0534905) |
| sysparm_exclude_reference_link | Flag that indicates whether to exclude Table API links for reference fields. Valid values: * true: Exclude Table API links for reference fields. * false: Include Table API links for reference fields. {#table-POST__ul_llg_cnr_tgb} Data type: Boolean Default: false |
| sysparm_fields | Comma-separated list of fields to return in the response. Invalid fields are ignored. Data type: String Default: Return all fields. |
| sysparm_input_display_value | Flag that indicates whether to set field values using the display value or the actual value. Depending on the different types of fields, the endpoint may manipulate the passed in display values to store the proper values in the database. For example, if you send the display name for a reference field, the endpoint stores the sys_id for that value in the database. For date and time fields, when this parameter is true, the date and time value is adjusted for the current user's timezone. When false, the date and time value is inserted using the GMT timezone. Valid values: * true: Treats input values as display values and they are manipulated so they are stored properly in the database. * false: Treats input values as actual values and stores them in the database without manipulation. {#table-POST__ul_shq_cfx_pp} Data type: Boolean Default: false - This matches the data type that is returned during data retrieval (GET methods), which is the actual values. Note: To set the value of an encrypted field, you must set this parameter to <kbd class="ph userinput">true</kbd>. If this parameter is not set to true, values submitted to encrypted fields are not saved. Additionally, the requesting user must have the appropriate encryption context prior to submitting the request. Encrypted fields are hidden for users without the appropriate encryption context. For more information on field encryption see [Encryption](https://www.servicenow.com/docs/access?context=encryption-landing&version=australia&pubname=australia-platform-security&ft:locale=en-US). |
| sysparm_view | UI view for which to render the data. Determines the fields returned in the response. Valid values: * desktop * mobile * both {#table-POST__ul_wr5_5xl_tgb} If you also specify the sysparm_fields parameter, it takes precedent. Data type: String |
[Table 26. Query parameters]

{#table-POST__entry__20}

| Name | Description |
|-|-|
| name-value pairs | Field name and the associated value for each parameter to define in the specified record. Note: All fields within a record may not be available for update. For example, fields that have a prefix of "sys_" are typically system parameters that are automatically generated and cannot be updated.Fields that are not specified and not auto generated by the system are set to the associated data type's null value. |
[Table 27. Request body parameters (XML or JSON)]

### Headers

The following request and response headers apply to this HTTP
action only, or apply to this action in a distinct way. For a list of general headers used
in the REST API, see [Supported REST API headers](https://www.servicenow.com/docs/qh7RcF0RI6a~i9u3octdlg "REST (REpresentational State Transfer) is a simple stateless architecture that provides standards between computer systems on the web, making it easier for them to communicate with each other.").
{#table-POST__entry__24}{#table-POST__accept-RESTAPI}{#table-POST__content_type-RESTAPI}

| Header | Description |
|-|-|
| Accept | Data format of the response body. Supported types: application/json or application/xml. Default: application/json |
| Content-Type | Data format of the request body. Supported types: application/json or application/xml. Default: application/json |
| X-no-response-body | By default, responses include body content detailing the new record. Set this header to true in the request to suppress the response body. |
[Table 28. Request headers]

{#table-POST__entry__32}

| Header | Description |
|-|-|
| Location | Location of the created resource. |
[Table 29. Response headers]

### Status codes

The following status codes apply to this HTTP action. For a
list of possible status codes used in the REST API, see [REST API HTTP response
codes](https://www.servicenow.com/docs/qh7RcF0RI6a~i9u3octdlg "REST (REpresentational State Transfer) is a simple stateless architecture that provides standards between computer systems on the web, making it easier for them to communicate with each other.").
{#table-POST__entry__36}{#table-POST__entry-400-status-code}{#table-POST__entry-404-status-code}

| Status code | Description |
|-|-|
| 201 | Indicates that the request completed successfully. |
| 400 | Bad Request. A bad request type or malformed request was detected. |
| 404 | Not found. The requested item wasn't found. |
[Table 30. Status codes]

### Response body parameters (JSON or XML)

{#table-POST__entry__44}

| Name | Description |
|-|-|
| name-value pairs | Field names and values of all parameters within the newly created record or those specified in the query parameters. |
[ ]

### cURL request

Insert a new record into the Incident table.

    curl "https://instance.servicenow.com/api/now/table/incident" \
    --request POST \
    --header "Accept:application/json" \
    --header "Content-Type:application/json" \
    --data "{'short_description':'Unable to connect to office wifi','assignment_group':'287ebd7da9fe198100f92cc8d1d2154e','urgency':'2','impact':'2'}" \
    --user 'username':'password'

The response contains the name-value pairs for the new record.

    {
      "result": {
        "upon_approval": "proceed",
        "location": "",
        "expected_start": "",
        "reopen_count": "0",
        "close_notes": "",
        "additional_assignee_list": "",
        "impact": "2",
        "urgency": "2",
        "correlation_id": "",
        "sys_tags": "",
        "sys_domain": {
          "link": "https://instance.servicenow.com/api/now/table/sys_user_group/global",
          "value": "global"
        },
        "description": "",
        "group_list": "",
        "priority": "3",
        "delivery_plan": "",
        "sys_mod_count": "0",
        "work_notes_list": "",
        "business_service": "",
        "follow_up": "",
        "closed_at": "",
        "sla_due": "",
        "delivery_task": "",
        "sys_updated_on": "2016-01-22 14:28:24",
        "parent": "",
        "work_end": "",
        "number": "INC0010002",
        "closed_by": "",
        "work_start": "",
        "calendar_stc": "",
        "category": "inquiry",
        "business_duration": "",
        "incident_state": "1",
        "activity_due": "",
        "correlation_display": "",
        "company": "",
        "active": "true",
        "due_date": "",
        "assignment_group": {
          "link": "https://instance.servicenow.com/api/now/table/sys_user_group/287ebd7da9fe198100f92cc8d1d2154e",
          "value": "287ebd7da9fe198100f92cc8d1d2154e"
        },
        "caller_id": "",
        "knowledge": "false",
        "made_sla": "true",
        "comments_and_work_notes": "",
        "parent_incident": "",
        "state": "1",
        "user_input": "",
        "sys_created_on": "2016-01-22 14:28:24",
        "approval_set": "",
        "reassignment_count": "0",
        "rfc": "",
        "child_incidents": "0",
        "opened_at": "2016-01-22 14:28:24",
        "short_description": "Unable to connect to office wifi",
        "order": "",
        "sys_updated_by": "admin",
        "resolved_by": "",
        "notify": "1",
        "upon_reject": "cancel",
        "approval_history": "",
        "problem_id": "",
        "work_notes": "",
        "calendar_duration": "",
        "close_code": "",
        "sys_id": "c537bae64f411200adf9f8e18110c76e",
        "approval": "not requested",
        "caused_by": "",
        "severity": "3",
        "sys_created_by": "admin",
        "resolved_at": "",
        "assigned_to": "",
        "business_stc": "",
        "wf_activity": "",
        "sys_domain_path": "/",
        "cmdb_ci": "",
        "opened_by": {
          "link": "https://instance.servicenow.com/api/now/table/sys_user/6816f79cc0a8016401c5a33be04be441",
          "value": "6816f79cc0a8016401c5a33be04be441"
        },
        "subcategory": "",
        "rejection_goto": "",
        "sys_class_name": "incident",
        "watch_list": "",
        "time_worked": "",
        "contact_type": "phone",
        "escalation": "0",
        "comments": ""
      }
    }

## Table - PUT /now/table/{tableName}/{sys_id} {#ariaid-title7}

Updates the specified record with the request body.

### URL format

Versioned URL:
/api/now/{api_version}/table/{tableName}/{sys_id}

Default URL:
/api/now/table/{tableName}/{sys_id}  
Note:  
Available versions are specified in the [REST API Explorer](https://www.servicenow.com/docs/zBKcyeP3If8_~R67hD_ZHg "In this tutorial you will use the REST API Explorer to test the ServiceNow REST APIs."). For scripted REST APIs there is additional version information on the [Scripted REST Service form](https://www.servicenow.com/docs/Zk3PxcZ0l8CqUYfw7mHiLg "The scripted REST API feature allows application developers to build custom web service APIs.").

### Supported request parameters

{#table-PUT__entry__2}{#table-PUT__version-not_optional-RESTAPI}

| Name | Description |
|-|-|
| api_version | Optional. Version of the endpoint to access. For example, <kbd class="ph userinput">v1</kbd> or <kbd class="ph userinput">v2</kbd>. Only specify this value to use an endpoint version other than the latest. Data type: String |
| sys_id | Unique identifier of the record to update. Data type: String |
| tableName | Name of the table in which the record is located. Data type: String |
[Table 31. Path parameters]

{#table-PUT__entry__10}{#table-PUT__sysparm_view-entry-RESTAPI}

| Name | Description |
|-|-|
| sysparm_display_value | Determines the type of data returned, either the actual values from the database or the display values of the fields. Display values are manipulated based on the actual value in the database and user or system settings and preferences. If returning display values, the value that is returned is dependent on the field type. * Choice fields: The database value may be a number, but the display value will be more descriptive. * Date fields: The database value is in UTC format, while the display value is based on the user's time zone. * Encrypted text: The database value is encrypted, while the displayed value is unencrypted based on the user's encryption context. * Reference fields: The database value is sys_id, but the display value is a display field of the referenced record. Data type: String Valid values: * true: Returns the display values for all fields. * false: Returns the actual values from the database. * all: Returns both actual and display values. {#table-PUT__ul_vzj_1pw_pp} Default: false Note: There is no preferred method for setting this parameter. However, specifying the display value may cause performance issues since it is not reading directly from the database and may include referencing other fields and records. For more information on display values and actual values, see [Table API FAQs (KB0534905).](https://support.servicenow.com/kb_view.do?sysparm_article=KB0534905) |
| sysparm_exclude_reference_link | Flag that indicates whether to exclude Table API links for reference fields. Valid values: * true: Exclude Table API links for reference fields. * false: Include Table API links for reference fields. {#table-PUT__ul_llg_cnr_tgb} Data type: Boolean Default: false |
| sysparm_fields | Comma-separated list of fields to return in the response. Invalid fields are ignored. Data type: String Default: Return all fields. |
| sysparm_input_display_value | Flag that indicates whether to set field values using the display value or the actual value. Valid values: * true: Treats input values as display values and they are manipulated so they can be stored properly in the database. * false: Treats input values as actual values and stored them in the database without manipulation. {#table-PUT__ul_shq_cfx_pp} Data type: Boolean Default: false Note: * If this parameter is set to true, pay attention to input values, especially date values, as these are interpreted as being supplied via the user time zone preference and are transformed into UTC format. * To set the value of an encrypted field, you must set this parameter to <kbd class="ph userinput">true</kbd>. If this parameter is not set to true, values submitted to encrypted fields are not saved. Additionally, the requesting user must have the appropriate encryption context prior to submitting the request. Encrypted fields are hidden for users without the appropriate encryption context. For more information on display values and actual values, see [Table API FAQs (KB0534905)](https://support.servicenow.com/kb_view.do?sysparm_article=KB0534905). For more information on field encryption see [Field Encryption](https://www.servicenow.com/docs/access?context=field-encryption&version=australia&pubname=australia-platform-security&ft:locale=en-US). {#table-PUT__ul_sn1_ffx_pp} |
| sysparm_query_no_domain | Flag that indicates whether to restrict the record search to only the domains for which the logged in user is configured. Valid values: * false: Exclude the record if it is in a domain that the currently logged in user is not configured to access. * true: Include the record even if it is in a domain that the currently logged in user is not configured to access. {#table-PUT__ul_pxp_3c1_3nb} Data type: Boolean Default: false Note: The sysparm_query_no_domain parameter is available only to system administrators or users who have the query_no_domain_table_api role. |
| sysparm_view | UI view for which to render the data. Determines the fields returned in the response. Valid values: * desktop * mobile * both {#table-PUT__ul_wr5_5xl_tgb} If you also specify the sysparm_fields parameter, it takes precedent. Data type: String |
[Table 32. Query parameters]

{#table-PUT__entry__24}

| Name | Description |
|-|-|
| name-value pairs | Name-value pairs for the field(s) to update in the associated table. For example, to update the short description file, enter a name-value pair similar to the following: `--data "{\"short_description\": \"my short desc\" }" \`. |
[Table 33. Request body parameters (XML or JSON)]

### Headers

The following request and response headers apply to this HTTP
action only, or apply to this action in a distinct way. For a list of general headers used
in the REST API, see [Supported REST API headers](https://www.servicenow.com/docs/qh7RcF0RI6a~i9u3octdlg "REST (REpresentational State Transfer) is a simple stateless architecture that provides standards between computer systems on the web, making it easier for them to communicate with each other.").
{#table-PUT__entry__28}{#table-PUT__accept-RESTAPI}

| Header | Description |
|-|-|
| Accept | Data format of the response body. Supported types: application/json or application/xml. Default: application/json |
| Content-Type | Data format of the request body. Supported types: application/json or application/xml. |
| X-no-response-body | By default, responses include body content detailing the modified record. Set this header to true in the request to suppress the response body. |
[Table 34. Request headers]

{#table-PUT__entry__36}

| Header | Description |
|-|-|
| None |   |
[Table 35. Response headers]

### Status codes

The following status codes apply to this HTTP action. For a
list of possible status codes used in the REST API, see [REST API HTTP response
codes](https://www.servicenow.com/docs/qh7RcF0RI6a~i9u3octdlg "REST (REpresentational State Transfer) is a simple stateless architecture that provides standards between computer systems on the web, making it easier for them to communicate with each other.").
{#table-PUT__entry__40}{#table-PUT__entry-200-status-code}{#table-PUT__entry-400-status-code}{#table-PUT__entry-404-status-code}

| Status code | Description |
|-|-|
| 200 | Successful. The request was successfully processed. |
| 400 | Bad Request. A bad request type or malformed request was detected. |
| 404 | Not found. The requested item wasn't found. |
[Table 36. Status codes]

### Response body parameters (JSON or XML)

{#table-PUT__entry__48}

| Name | Description |
|-|-|
| name-value pairs | All fields (not just modified) with their associated values for the change request. |
[ ]

### cURL request

Update a record in the Incident table.

    curl "https://instance.servicenow.com/api/now/table/incident/ef43c6d40a0a0b5700c77f9bf387afe3" \
    --request PUT \
    --header "Accept:application/json" \
    --header "Content-Type:application/json" \
    --data "{'assigned_to':'681b365ec0a80164000fb0b05854a0cd','urgency':'1','comments':'Elevating urgency, this is a blocking issue'}" \
    --user 'username':'password'

The response contains the name-value pairs for the updated record.

    {
      "result": {
        "upon_approval": "proceed",
        "location": {
          "link": "https://instance.servicenow.com/api/now/table/cmn_location/108752c8c611227501d4ab0e392ba97f",
          "value": "108752c8c611227501d4ab0e392ba97f"
        },
        "expected_start": "",
        "reopen_count": "",
        "close_notes": "",
        "additional_assignee_list": "",
        "impact": "1",
        "urgency": "1",
        "correlation_id": "",
        "sys_tags": "",
        "sys_domain": {
          "link": "https://instance.servicenow.com/api/now/table/sys_user_group/global",
          "value": "global"
        },
        "description": "",
        "group_list": "",
        "priority": "1",
        "delivery_plan": "",
        "sys_mod_count": "7",
        "work_notes_list": "",
        "business_service": "",
        "follow_up": "",
        "closed_at": "",
        "sla_due": "2017-07-05 05:58:24",
        "delivery_task": "",
        "sys_updated_on": "2016-01-22 14:12:37",
        "parent": "",
        "work_end": "",
        "number": "INC0000050",
        "closed_by": "",
        "work_start": "",
        "calendar_stc": "",
        "category": "hardware",
        "business_duration": "",
        "incident_state": "2",
        "activity_due": "2016-01-22 16:12:37",
        "correlation_display": "",
        "company": {
          "link": "https://instance.servicenow.com/api/now/table/core_company/31bea3d53790200044e0bfc8bcbe5dec",
          "value": "31bea3d53790200044e0bfc8bcbe5dec"
        },
        "active": "true",
        "due_date": "",
        "assignment_group": {
          "link": "https://instance.servicenow.com/api/now/table/sys_user_group/8a5055c9c61122780043563ef53438e3",
          "value": "8a5055c9c61122780043563ef53438e3"
        },
        "caller_id": {
          "link": "https://instance.servicenow.com/api/now/table/sys_user/5b7c200d0a640069006b3845b5d0fa7c",
          "value": "5b7c200d0a640069006b3845b5d0fa7c"
        },
        "knowledge": "false",
        "made_sla": "true",
        "comments_and_work_notes": "",
        "parent_incident": "",
        "state": "2",
        "user_input": "",
        "sys_created_on": "2015-11-02 18:05:40",
        "approval_set": "",
        "reassignment_count": "0",
        "rfc": "",
        "child_incidents": "",
        "opened_at": "2015-11-02 21:58:24",
        "short_description": "Can't access Exchange server - is it down?",
        "order": "",
        "sys_updated_by": "admin",
        "resolved_by": "",
        "notify": "1",
        "upon_reject": "cancel",
        "approval_history": "",
        "problem_id": "",
        "work_notes": "",
        "calendar_duration": "",
        "close_code": "",
        "sys_id": "ef43c6d40a0a0b5700c77f9bf387afe3",
        "approval": "not requested",
        "caused_by": "",
        "severity": "3",
        "sys_created_by": "glide.maint",
        "resolved_at": "",
        "assigned_to": {
          "link": "https://instance.servicenow.com/api/now/table/sys_user/681b365ec0a80164000fb0b05854a0cd",
          "value": "681b365ec0a80164000fb0b05854a0cd"
        },
        "business_stc": "",
        "wf_activity": "",
        "sys_domain_path": "/",
        "cmdb_ci": {
          "link": "https://instance.servicenow.com/api/now/table/cmdb_ci/281190e3c0a8000b003f593aa3f20ca6",
          "value": "281190e3c0a8000b003f593aa3f20ca6"
        },
        "opened_by": {
          "link": "https://instance.servicenow.com/api/now/table/sys_user/glide.maint",
          "value": "glide.maint"
        },
        "subcategory": "",
        "rejection_goto": "",
        "sys_class_name": "incident",
        "watch_list": "",
        "time_worked": "",
        "contact_type": "phone",
        "escalation": "3",
        "comments": ""
      }
    }

*[\>]: and then