API CreateDownloadFile

Z Podpora.nextis.cz
Přejít na: navigace, hledání

Description

Method allows You to create new download file in system.

Exact name

API_CreateDownloadFile

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@ValidFromDate datetime Valid from date
@ValidToDate datetime Valid to date
@GroupName nvarchar(200) Group name
@Title nvarchar(200) Title
@Description nvarchar(2000) Description
@FileName nvarchar(255) File name
@SortIndex int Sort index
@FILEDATA varbinary(max) File data

Return

0 : OK
100 : Item could not be created

Example

DECLARE @return_value int
Declare @fILE AS VARBINARY(MAX)
Select @fILE = CAST(bulkcolumn AS VARBINARY(MAX))
 FROM OPENROWSET(
            BULK
            'C:\test.pdf',
            SINGLE_BLOB ) AS x
			
EXEC @return_value = [API_CreateDownloadFile] @ValidFromDate = null ,@ValidToDate = null ,@GroupName= 'GroupName' ,@Title= 'Title' ,@Description= 'Description' ,@FileName= 'test.pdf' ,@SortIndex= 0 ,@FILEDATA= @fILE

Notices

None.