Attachments
To Delete and Query from the Attachments in the tasks.
Table Specific Information
Select
The add-in will use the Asana API to process WHERE clause conditions built with the following column and operator. The TaskId or Id is required to make a request and the rest of the filter is executed client side within the add-in.
- Id supports the '=' comparison.
- TaskId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM Attachments WHERE Id = '1134618934491707' SELECT * FROM Attachments WHERE TaskId = '1128092964672854'
Delete
Following is an example of how to delete from Attachments table:
DELETE FROM Attachments WHERE Id = '1134618934491707'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Globally unique ID of the attachment. | |
| Name | String | True |
The name of the file. | |
| Host | String | True |
The service hosting the attachment. Valid values are asana, dropbox, gdrive and box. | |
| CreatedAt | Datetime | True |
The time at which this attachment was uploaded. | |
| ViewURL | String | True |
The URL where the attachment can be viewed, which may be friendlier to users in a browser than just directing them to a raw file. | |
| DownloadURL | String | True |
May be null if the attachment is hosted by box. If present, this URL may only be valid for 1 hour from the time of retrieval. You should avoid persisting this URL somewhere and just refresh it on demand to ensure you do not keep stale URLs. | |
| TaskId | String | True |
Tasks.Id |
The task this attachment is attached to. |
| ResourceType | String | True |
The resource type of this resource. | |
| ResourceSubtype | String | True |
The service hosting the attachment. Valid values are asana, dropbox, gdrive, onedrive, box, vimeo, and external. | |
| PermanentURL | String | True |
PermanentURL | |
| Size | Integer | True |
The size of the attachment in bytes. Only present when the resource_subtype is asana. | |
| ConnectedToApp | Boolean | True |
Whether the attachment is connected to the app making the request for the purposes of showing an app components widget. Only present when the resource_subtype is external or gdrive. |