# Get an update request

Gets the specified update request for the sheet that has a future schedule.

The rowIds and columnIds in the returned UpdateRequest object represent the list at the time
the update request was created or last modified. The lists may contain Ids of rows or columns
that are no longer valid (for example, they have been removed from the sheet).

Endpoint: GET /sheets/{sheetId}/updaterequests/{updateRequestId}
Version: 2.0.0
Security: APIToken, OAuth2

## Path parameters:

  - `sheetId` (number, required)
    Sheet Id of the sheet being accessed.

  - `updateRequestId` (string, required)
    ID of the Update Request

## Header parameters:

  - `Authorization` (string)
    API Access Token used to authenticate requests to Smartsheet APIs.
    Example: "Bearer JKlMNOpQ12RStUVwxYZAbcde3F5g6hijklM789"

  - `smartsheet-integration-source` (string)
    Uses the following metadata to distinguish between human-initiated API requests and third-party service-initiated calls by AI Connectors or ITSM:

- Integration source type
- Organization name
- Integration source name 

Format:


TYPE,OrgName,SourceName


Examples: 

AI,SampleOrg,My-AI-Connector-v2

SCRIPT,SampleOrg2,Accounting-updater-script

APPLICATION,SampleOrg3,SheetUpdater
    Example: "AI,SampleOrg,My-AI-Connector-v2"

## Response 200 fields (application/json):

  - `rowIds` (array)
    The Ids of rows to be included.

  - `columnIds` (array)
    The Id of the columns to be included.

  - `includeAttachments` (boolean)
    Indicates whether to include attachments in the email.

  - `includeDiscussions` (boolean)
    Indicates whether to include discussions in the email.

  - `layout` (boolean)
    One of the following values: HORIZONTAL or VERTICAL. Optional, defaults to HORIZONTAL when multiple rows are being sent and to VERTICAL when a single row is being sent. HORIZONTAL formats the rows being sent as a grid, whereas VERTICAL formats the rows being sent as separate cards.

  - `ccMe` (boolean)
    Indicates whether to send a copy of the email to the sender.

  - `message` (string)
    The message of the email.

  - `sendTo` (array)
    Array of recipients.

  - `subject` (string)
    The subject of the email.

  - `id` (number)
    Id of the update request.

  - `createdAt` (any)
    The date and time for when this request was originally created.

Read-only.

  - `modifiedAt` (any)
    The date and time for when the last change was made to this request.

Read-only.

  - `schedule` (object)
    The schedule for which update requests are sent out.

  - `schedule.type` (string)
    Type of schedule.
    Enum: "ONCE", "DAILY", "WEEKLY", "MONTHLY", "YEARLY"

  - `schedule.dayDescriptors` (array)
    A string array consists of one or more of the following values:
* DAY, WEEKDAY, WEEKEND
* SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY

The subset of values applicable to the schedule type are as followed:

| Value         | Daily schedule | Weekly schedule | Monthly schedule |
|---------------|----------------|-----------------|------------------|
| DAY       |                |                 |       ✓      |
| WEEKDAY   |      ✓     |                 |       ✓      |
| WEEKEND   |                |                 |       ✓      |
| SUNDAY    |                |      ✓      |       ✓      |
| MONDAY    |                |      ✓      |       ✓      |
| TUESDAY   |                |      ✓      |       ✓      |
| WEDNESDAY |                |      ✓      |       ✓      |
| THURSDAY  |                |      ✓      |       ✓      |
| FRIDAY    |                |      ✓      |       ✓      |
| SATURDAY  |                |      ✓      |       ✓      |

For more details, refer to the Table of Schedule Object’s Attributes below.
    Enum: "DAY", "WEEKDAY", "WEEKEND", "SUNDAY", "MONDAY", "TUESDAY", "WEDNESDAY", "THURSDAY", "FRIDAY", "SATURDAY"

  - `schedule.dayOfMonth` (number)
    The day within the month.

Valid range is 1 to 28.

This attribute is applicable to the following schedule type:
 * MONTHLY

For more details, refer to the Table of Schedule Object’s Attributes below.

  - `schedule.dayOrdinal` (string)
    Must be one of the following values:
  * FIRST or LAST
  * SECOND, THIRD, or FOURTH

This attribute is applicable to the following schedule type:
  * MONTHLY

  For more details, refer to the Table of Schedule Object’s Attributes below.
    Enum: "FIRST", "LAST", "SECOND", "THIRD", "FOURTH"

  - `schedule.repeatEvery` (number)
    Frequency on which the request is delivered. The unit is a function of the type attribute. For example,
for MONTHLY schedule, repeatEvery=1 means every month.

Valid range is 1 to 99.

This attribute is applicable to the following schedule types: DAILY, WEEKLY, MONTHLY, or YEARLY.
For more details, refer to the Table of Schedule Object’s Attributes below.

  - `schedule.endAt` (any)
    The date, time, and time zone at which the delivery schedule ends.

The value is either in a string format or a numeric format:

* When the value is a string, it must be a valid ISO-8601 date and time with an offset (YYYY-MM-DDThh:mm:ssTZD).
* When the value is a number, it represents a date and time with no offset (UTC time zone). See Dates and Times for more information.

The value must be later than startAt and the current date and time.

The value must contain zero hours, zero minutes, and zero seconds.

The offset (time zone) value must be the same as the offset (time zone) value in startAt.

This attribute is applicable to the following schedule types: DAILY, WEEKLY, MONTHLY, YEARLY. For more details, refer to the Table of Schedule Object’s Attributes below.

  - `schedule.lastSentAt` (any)
    The date and time for when the last request was sent.

  - `schedule.nextSendAt` (any)
    The date and time for when the next request is scheduled to send.

  - `schedule.startAt` (any)
    The date, time, and time zone at which the first delivery starts.

The value is either in a string format or a numeric format:

 *   When the value is a string, it must be a valid ISO-8601 date and time with an offset (YYYY-MM-DDThh:mm:ssTZD).
 *   When the value is a number, it represents a date and time with no offset (UTC time zone). See [Dates and times](/api/smartsheet/guides/basics/dates-and-times) for more information.

For ONCE schedule type, it must be later than the current date time.

For all other schedule types, it must be later than “2000-01-01T00:00:00Z” in string format or 946684800000 in numeric format.

The value must contain zero minutes and zero seconds.

This attribute is applicable to all schedule types.

For more details, refer to the Table of Schedule Object’s Attributes below.

  - `sentBy` (object)
    User object containing name and email of the sender.

  - `sentBy.email` (string)
    Example: "jane.doe@smartsheet.com"

  - `sentBy.name` (string)
    Example: "Jane Doe"