Methods

List Cell History

Gets the cell modification history.

Authorizations:

APITokenOAuth2 (READ_SHEETS)

path Parameters

sheetId required	number Sheet Id of the sheet being accessed.
rowId required	number Row Id in the sheet being accessed.
columnId required	number Column Id in the sheet being accessed.

query Parameters

include	string A comma-separated list of elements to copy: columnType - includes the columnType attribute for each Cell object objectValue - when used in combination with a level query parameter, includes the email addresses for a multi-contact cell. Enum: "columnType" "objectValue"
pageSize	number Default: 100 The maximum number of items to return per page. Unless otherwise stated for a specific endpoint, defaults to 100. If only page is specified, defaults to a page size of 100. For reports, the default is 100 rows. If you need larger sets of data from your report, returns a maximum of 10,000 rows per request.
page	number Default: 1 Which page to return. Defaults to 1 if not specified. If you specify a value greater than the total number of pages, the last page of results is returned.
level	integer Default: 0 Specifies whether object data types, such as multi-contact data are returned in a backwards-compatible, text format in text/number columns. - Set `level=0` (default) to use text/number columns for multi-contact data and multi-picklist data. - Set `level=1` to use multiple-entry contact list columns for multi-contact data; multi-picklist data is returned in text/number columns. - Set `level=2` to use multiple-entry contact list columns for multi-contact data and use multiple-entry picklist columns for multi-picklist data.

header Parameters

Authorization

string

API Access Token used to authenticate requests to Smartsheet APIs.

Example: Bearer JKlMNOpQ12RStUVwxYZAbcde3F5g6hijklM789

Responses

Request samples

curl 'https://api.smartsheet.com/2.0/sheets/{sheetId}/rows/{rowId}/columns/{columnId}/history?include=columnType' \
-H "Authorization: Bearer JKlMNOpQ12RStUVwxYZAbcde3F5g6hijklM789"

Response samples

200
default

Content type

application/json

{"pageNumber": 1,
"pageSize": 50,
"totalPages": 25,
"totalCount": 136,
"data": [{"modifiedAt": "2019-08-24T14:15:22Z",
"modifiedBy": {"email": "jane.doe@smartsheet.com",
"name": "Jane Doe"
},
"columnId": 0,
"columnType": "string",
"conditionalFormat": "string",
"displayValue": "string",
"format": "string",
"formula": "string",
"hyperlink": {"reportId": 0,
"sheetId": 0,
"sightId": 0,
"url": "string"
},
"image": {"altText": "string",
"height": 0,
"id": "string",
"width": 0
},
"linkInFromCell": {"columnId": 0,
"rowId": 0,
"sheetId": 0,
"sheetName": "string",
"status": "BLOCKED"
},
"linksOutToCells": [{"columnId": 0,
"rowId": 0,
"sheetId": 0,
"sheetName": "string",
"status": "BLOCKED"
}
],
"objectValue": {"objectType": "ABSTRACT_DATETIME"
},
"overrideValidation": true,
"strict": true,
"value": "string"
}
]
}

➔ Next to Related Items