Reference

Endpoint Download Attachment

Name

download_attachment

Description

Download a specific attachment by Id.

Parameters

Parameter Required Options
Name: AttachmentId

Label: Attachment ID

The attachment Id for the attachment to get. 		YES
Name: Fields

Label: Fields
Option Value
name name
resource_subtype resource_subtype
connected_to_app connected_to_app
created_at created_at
download_url download_url
host host
parent parent
parent.name parent.name
parent.resource_subtype parent.resource_subtype
permanent_url permanent_url
size size
view_url view_url

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_WSTR nvarchar(50) 50
StatusCode DT_I4 int
Name DT_WSTR nvarchar(255) 255
Path DT_WSTR nvarchar(4000) 4000
ResourceSubtype DT_WSTR nvarchar(50) 50
ConnectedToApp DT_BOOL bit
CreatedAt DT_DBTIMESTAMP datetime
DownloadUrl DT_WSTR nvarchar(500) 500
Host DT_WSTR nvarchar(50) 50
ParentId DT_WSTR nvarchar(50) 50
ParentName DT_WSTR nvarchar(255) 255
ParentResourceSubtype DT_WSTR nvarchar(50) 50
PermanentUrl DT_WSTR nvarchar(500) 500
Size DT_I4 int
ViewUrl DT_WSTR nvarchar(500) 500
If the column you are looking for is missing, consider customizing Asana Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Asana Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - Asana
Read and write Asana data effortlessly. Integrate, manage, and automate tasks, projects, workspaces, and time entries — almost no coding required.
Asana
Download Attachment
Required Parameters
Attachment ID Fill-in the parameter...
FileOverwriteMode Fill-in the parameter...
TargetFilePath Fill-in the parameter...
Optional Parameters
Fields
Continue On 404 Error (When record not found) False
SSIS API Source - Read from table or endpoint

API Destination

API Destination - Asana
Read and write Asana data effortlessly. Integrate, manage, and automate tasks, projects, workspaces, and time entries — almost no coding required.
Asana
Download Attachment
Required Parameters
Attachment ID Fill-in the parameter...
FileOverwriteMode Fill-in the parameter...
TargetFilePath Fill-in the parameter...
Optional Parameters
Fields
Continue On 404 Error (When record not found) False
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Download attachment to local disk

<p>Downloads a single attachment to a local file. Specify the attachment ID and the full path where the file should be saved. You can choose whether to overwrite an existing file, fail if it exists, or skip. Use the attachment ID from a task or project attachment list.</p> 

SELECT * FROM download_attachment 
WITH (
   AttachmentId='1208216218258030'
 , TargetFilePath='c:\temp\1208216218258030_AWS-refund-request.png' 
 , FileOverwriteMode=0 --0=AlwaysOverwrite, 1=FailIfExists, 2=SkipIfExists
)

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Download attachment to local disk

<p>Downloads a single attachment to a local file. Specify the attachment ID and the full path where the file should be saved. You can choose whether to overwrite an existing file, fail if it exists, or skip. Use the attachment ID from a task or project attachment list.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM download_attachment 
WITH (
   AttachmentId=''1208216218258030''
 , TargetFilePath=''c:\temp\1208216218258030_AWS-refund-request.png'' 
 , FileOverwriteMode=0 --0=AlwaysOverwrite, 1=FailIfExists, 2=SkipIfExists
)';

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];