Reference

Endpoint Read CSV files from folder

Name

read_csv_files_from_folder

Description

Reads the contents of every CSV file in the specified folder directly into a result set without downloading to disk.

Parameters

Parameter Required Options
Name: Path

Label: Folder path or ID
Name: Recursive

Label: Recursively scan subfolders
Option Value
true true
false false
Name: FilterFilesByExtension

Label: Filter files by extensions
Option Value
CSV file csv
Text file txt
DAT file dat
TSV file tsv

Output 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.
If the column you are looking for is missing, consider customizing Dropbox 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 Dropbox Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - Dropbox
Read / write Dropbox data inside your app; perform many Dropbox operations without coding, just use easy to use high performance API Connector for Dropbox
Dropbox
Read CSV files from folder
Optional Parameters
Folder path or ID
Recursively scan subfolders false
Filter files by extensions csv
SSIS API Source - Read from table or endpoint

API Destination

API Destination - Dropbox
Read / write Dropbox data inside your app; perform many Dropbox operations without coding, just use easy to use high performance API Connector for Dropbox
Dropbox
Read CSV files from folder
Optional Parameters
Folder path or ID
Recursively scan subfolders false
Filter files by extensions csv
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Read multiple CSV files from a folder by id 

SELECT * FROM read_csv_files_from_folder
WITH (Path='id:ZirXxxxxxxxAAAAAAAAABw')

Read multiple CSV files from a folder by path 

SELECT * FROM read_csv_files_from_folder
WITH (Path='/myfolder')

Read multiple CSV files by specific extension 

SELECT * FROM read_csv_files_from_folder
WITH (FilterFilesByExtension='txt')

Read multiple CSV files by processing subfolders recursively 

SELECT * FROM read_csv_files_from_folder
WITH (Recursive='true')

SQL Server

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

Read multiple CSV files from a folder by id 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM read_csv_files_from_folder
WITH (Path=''id:ZirXxxxxxxxAAAAAAAAABw'')';

EXEC (@MyQuery) AT [LS_TO_DROPBOX_IN_GATEWAY];

Read multiple CSV files from a folder by path 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM read_csv_files_from_folder
WITH (Path=''/myfolder'')';

EXEC (@MyQuery) AT [LS_TO_DROPBOX_IN_GATEWAY];

Read multiple CSV files by specific extension 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM read_csv_files_from_folder
WITH (FilterFilesByExtension=''txt'')';

EXEC (@MyQuery) AT [LS_TO_DROPBOX_IN_GATEWAY];

Read multiple CSV files by processing subfolders recursively 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM read_csv_files_from_folder
WITH (Recursive=''true'')';

EXEC (@MyQuery) AT [LS_TO_DROPBOX_IN_GATEWAY];