Introduction

Enzo Server
  Installation
  Quick Start
  Core Features
    Async Calls
    ConnectionStrings
    Edge Cache
    HTTP Access
    Scheduling
    Views
  Advanced Capabilities
    Change Data Capture
  Administration
    Configuration Settings
    Logins & ACL
    Auditing
    Current Executions
    Linked Server
    SSL

  User Guides
     Sharding
     Sharding Overview

     SharePoint

   Adapters
    All Adapters
    Azure Bus
    Azure IoT Hub
    Azure Key Vault
    Azure Storage
    Couchbase
    CSV
    DB (RDBMS)
    Files
    Flight Aware
    FTP
    Geonames
    HttpEndpoint (REST)
    Insteon
    Loggly
    Messaging (SMS/SMTP)
    MongoDB
    Motus
    MSAD
    MSMQ
    Pipeline
    Pressero
    RabbitMQ
    SalesForce
    Shard
    SharePoint
    SQL Server
    Threading
    Twilio
    Twitter
    VellemanDMX
    Weather (Underground)
    Whiparound
    WMI
    Xls (Excel)
    ZIP


  SDK
    Overview
    Installation
    DevHost
    Create A Simple Adapter
    Handler Columns

    Advanced SDK Concepts
      Handler Decorators
      Dynamic Columns
      Table & Table Enumerators
      Virtual Tables

/adapters/ftp




FTP


This adapter allows you to access FTP servers and access files directly.


Configuration Settings



Name Description Default
Boolean _isDefault Make this the default configuration. Defaults to true if configName is already the default.
String uri FTP target URL or URI, including "ftp://"
String uid FTP login UserId
String pwd FTP login password
Boolean isPassive Enable passive mode False
Boolean isBinary Enable binary file transmission False
Boolean isSSL Use SSL encryption over transmission False

Handlers



append Appends data at the end of a file using the default connection file type (binary or ascii). details 

Arguments

Name Description Default
fileName R The name of the file
content R The content to append

SQL Call

EXEC ftp.append './files/test.txt', 'more data'


Http Call

/bsc/ftp/append

Output Columns

This call does not return data.

append_ascii Appends data at the end of an ascii file. details 

Arguments

Name Description Default
fileName R The name of the file
content R The content to append

SQL Call

EXEC ftp.append_ascii './files/test.txt', 'more data'


Http Call

/bsc/ftp/append_ascii

Output Columns

This call does not return data.

append_binary Appends data at the end of a binary file. details 

Arguments

Name Description Default
fileName R The name of the file
content R The content to append

SQL Call

EXEC ftp.append './files/test.data', 0x01020304


Http Call

/bsc/ftp/append_binary

Output Columns

This call does not return data.

delete Deletes a file. details 

Arguments

dir Lists the content of a directory. details 

Arguments

Name Description Default
name The name of the directory (send null for the root directory)

SQL Call

EXEC ftp.dir
EXEC ftp.dir './files'


Http Call

/bsc/ftp/dir

Output Columns

String FileNameThe name of the file or directory
directories List directories under the path provided. details 

Arguments

Name Description Default
name The path under which to list available directories (leave null for the root directory)

SQL Call

EXEC ftp.directories './files'


Http Call

/bsc/ftp/directories

Output Columns

This call does not return data.

download Downloads a single file from an FTP site to a local drive. details 

Arguments

Name Description Default
fileName The name of the file to download. Leave blank to use the default file name.
newFile R The full path of the file name to create locally

SQL Call

EXEC ftp.download './files/test.data'


Http Call

/bsc/ftp/download

Output Columns

This call does not return data.

get Gets the content of a file using the default connection file type (binary or ascii). details 

Arguments

Name Description Default
fileName R The name of the file

SQL Call

EXEC ftp.get './files/test.zip'


Http Call

/bsc/ftp/get

Output Columns

This call does not return data.

get_ascii Gets the content of an ascii file. details 

Arguments

Name Description Default
fileName R The name of the file

SQL Call

EXEC ftp.get_ascii './files/test.txt'


Http Call

/bsc/ftp/get_ascii

Output Columns

String ContentThe content of the file
get_binary Gets the content of a binary file. details 

Arguments

Name Description Default
fileName R The name of the file

SQL Call

EXEC ftp.get_binary './files/test.zip'


Http Call

/bsc/ftp/get_binary

Output Columns

Object ContentThe content of the file
ls Lists the files in a directory. details 

Arguments

Name Description Default
name The name of the directory (send null for the root directory)

SQL Call

EXEC ftp.ls
EXEC ftp.ls './files'


Http Call

/bsc/ftp/ls

Output Columns

String FileNameThe name of the file
mkdir Creates a new directory from the current working directory. details 

Arguments

Name Description Default
name R The name of the directory

SQL Call

EXEC ftp.mkdir 'test'
EXEC ftp.mkdir './files/test'


Http Call

/bsc/ftp/mkdir

Output Columns

This call does not return data.

put Creates a file using the default connection file type (binary or ascii). details 

Arguments

Name Description Default
fileName R The name of the file
content R The content of the file

SQL Call

EXEC ftp.put './files/test.data', 0x01020304


Http Call

/bsc/ftp/put

Output Columns

This call does not return data.

put_ascii Creates an ascii file. details 

Arguments

Name Description Default
fileName R The name of the file
content R The content of the file

SQL Call

EXEC ftp.put_ascii './files/test.txt', 'test data'


Http Call

/bsc/ftp/put_ascii

Output Columns

This call does not return data.

put_binary Creates a binary file. details 

Arguments

Name Description Default
fileName R The name of the file
content R The content of the file

SQL Call

EXEC ftp.put_binary './files/test.data', 0x01020304


Http Call

/bsc/ftp/put_binary

Output Columns

This call does not return data.

rename Renames a file. details 

Arguments

rmdir Deletes a directory from the current working directory. details 

Arguments

Name Description Default
name R The name of the directory

SQL Call

EXEC ftp.rmdir 'test'
EXEC ftp.rmdir './files/test'


Http Call

/bsc/ftp/rmdir

Output Columns

This call does not return data.

size Gets the size of a file. details 

Arguments

Name Description Default
fileName R The name of the file

SQL Call

EXEC ftp.size 'test.zip'
EXEC ftp.size './files/test.zip'


Http Call

/bsc/ftp/size

Output Columns

String fileNameThe name of the file
String FileSizeThe size of the file in bytes