Upload Attachment (Single file)
Name
post_attachment
Description
Upload files to Zendesk which can be used as attachment later. [API reference]
Parameters
Parameter | Label | Required | Options | Description |
---|---|---|---|---|
filename | File Name | YES | File name for display purpose | |
path | File Path (Local) | YES | ||
token | Token for exising Upload Session | NO | Blank if creating a new upload |
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
token |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
expires_at |
DT_DBTIMESTAMP
|
datetime
|
False |
||
attachment_id |
DT_I8
|
bigint
|
False |
||
attachment_file_name |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
attachment_content_url |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
attachment_url |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
attachment_content_type |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
attachment_size |
DT_I8
|
bigint
|
False |
||
attachment_height |
DT_I4
|
int
|
False |
||
attachment_width |
DT_I4
|
int
|
False |
||
attachment_deleted |
DT_BOOL
|
bit
|
False |
||
attachment_inline |
DT_BOOL
|
bit
|
False |
||
attachment_thumbnail_id |
DT_I8
|
bigint
|
False |
||
attachment_thumbnail_file_name |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
attachment_thumbnail_content_url |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
attachment_thumbnail_url |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
attachment_thumbnail_content_type |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
attachment_thumbnail_size |
DT_I8
|
bigint
|
False |
||
attachment_thumbnail_height |
DT_I4
|
int
|
False |
||
attachment_thumbnail_width |
DT_I4
|
int
|
False |
||
attachment_thumbnail_deleted |
DT_BOOL
|
bit
|
False |
||
attachment_thumbnail_inline |
DT_BOOL
|
bit
|
False |
If the column you are looking for is missing, consider customizing Zendesk Connector.
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 Zendesk Connector in API Source component to read data or in API Destination component to read/write data:
Upload Attachment (Single file) using API Source
Zendesk
Upload Attachment (Single file)

Upload Attachment (Single file) using API Destination
Zendesk
Upload Attachment (Single file)

ODBC application
Use these SQL queries in your ODBC application data source:
Upload attachment
SELECT * FROM post_attachment
WITH
(
"filename" = 'abcd-1234-filename',
"path" = 'abcd-1234-path'
)
SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Upload attachment
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM post_attachment
WITH
(
"filename" = ''abcd-1234-filename'',
"path" = ''abcd-1234-path''
)';
EXEC (@MyQuery) AT [LS_TO_ZENDESK_IN_GATEWAY];