Attachments
To Delete and Query from the Attachments in the tasks.
Table Specific Information
Select
The connector 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 connector.
- 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. |