JDBC Driver for Asana

Build 23.0.8839

Attachments

To Delete and Query from the Attachments in the tasks.

Table Specific Information

Select

The driver 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 driver.

  • 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839