EndPoint Download Attachment

Name

download_attachment

Description

Download a specific attachment by Id.

Parameters

Parameter

Label

Required

Options

Description

AttachmentId

Attachment ID

YES

The attachment Id for the attachment to get.

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	Raw
Id	`DT_WSTR`	`nvarchar(50)`	50	`False`
StatusCode	`DT_I4`	`int`		`False`
Name	`DT_WSTR`	`nvarchar(255)`	255	`False`
Path	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
ResourceSubtype	`DT_WSTR`	`nvarchar(50)`	50	`False`
ConnectedToApp	`DT_BOOL`	`bit`		`False`
CreatedAt	`DT_DBTIMESTAMP`	`datetime`		`False`
DownloadUrl	`DT_WSTR`	`nvarchar(500)`	500	`False`
Host	`DT_WSTR`	`nvarchar(50)`	50	`False`
ParentId	`DT_WSTR`	`nvarchar(50)`	50	`False`
ParentName	`DT_WSTR`	`nvarchar(255)`	255	`False`
ParentResourceSubtype	`DT_WSTR`	`nvarchar(50)`	50	`False`
PermanentUrl	`DT_WSTR`	`nvarchar(500)`	500	`False`
Size	`DT_I4`	`int`		`False`
ViewUrl	`DT_WSTR`	`nvarchar(500)`	500	`False`

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	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 component to read data or in API Destination component to read/write data:

Download Attachment using API Source

Asana

Download Attachment

SSIS API Source - Read from table or endpoint

Download Attachment using API Destination

Asana

Download Attachment

SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Download Attachment to Local Disk

Download Attachment to Local Disk File.

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

Download Attachment to Local Disk File.

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 [LINKED_SERVER_TO_ASANA_IN_DATA_GATEWAY];