Info_AttachmentVersions
Read data on the versions of the attachments in your Smartsheet sheets.
Table-specific information
SELECT
Retrieve all attachment versions of an attachment in the sheet.SELECT * FROM Info_AttachmentVersions WHERE SheetId = '8449165781585796' AND AttachmentId = '2879526696423300'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the attachment version. | |
| SheetId | String | The unique identifier of the sheet in which the attachment is located. | |
| AttachmentId | String | The unique identifier of the attachment (Id of the most recent version). | |
| Name | String | The name of the attachment. | |
| MimeType | String | The attachment MIME type (e.g. 'PNG'). | |
| CreatedAt | Timestamp | The time when the attachment was created. | |
| ParentId | String | The unique identifier of the object to which the attachment belongs to. | |
| ParentType | String | The type of object to which the attachment belongs to.
使用できる値は次のとおりです。SHEET, ROW, COMMENT | |
| UserName | String | The full name of the user who created the attachment. | |
| UserEmail | String | The email address of the user who created the attachment. | |
| URL | String | The temporary URL of the attachment. | |
| SizeInKB | Long | The size of the attachment in kilobytes. | |
| Description | String | The description of the attachment. |