PLATFORMS SOLUTIONS BLOGS CONTACT ☰

Egnyte Adapter



This adapter allows you to access files stored on the Egnyte service using SQL


Want to try it in Azure? Click here to learn more or click here to create a new Enzo Server RTM 3.1 Azure VM now.
Want to try it in AWS? Click here to learn more or click here to create a new Enzo Server RTM 3.1 AWS VM now.


Configuration Settings



Name Description Default
Boolean _isDefault Make this the default configuration. Defaults to true if configName is already the default.
String domain Domain used for authentication
String clientId ClientId used for authentication
String accessToken The accessToken used for authentication

Handlers



CreateFolder
folder 		Create new folder details 

Arguments

Name Description Default
path R folder path with name to create new folder

SQL Call

EXEC Egnyte.CreateFolder 'folderpath'
insert into Egnyte.folder (path) values ('path')


Http Call

/egnyte/createfolder

Output Columns

This call does not return data.

deleteFile
files 		Delete a file details 

Arguments

Name Description Default
fileName R The fileName to delete that file

SQL Call

EXEC Egnyte.deleteFile @fileName='fileName'
Delete from Egnyte.files where fileName='fileName'


Http Call

/egnyte/deletefile

Output Columns

This call does not return data.

deleteFolder
folders 		Delete a folder details 

Arguments

Name Description Default
folderName R The folderName to delete that folder

SQL Call

EXEC Egnyte.deleteFolder @folderName='folderName'
Delete from Egnyte.folders where fileId='folderName'


Http Call

/egnyte/deletefolder

Output Columns

This call does not return data.

downloadFile
Download a file to a local or UNC path details 

Arguments

Name Description Default
fileName R The relative path of the file (or the full graphPath). Can also be a File ID (start with id:...)
downloadPath The local or UNC path where file will be downloaded (leave blank to download to a Temp directory)
override If true, overrides the file if it already exists (default: 0) False
timeout Timeout operation in minutes - default: 0 (no timeout) 0
retryCount Number of retries (default: 3) 3

SQL Call

EXEC Egnyte.downloadFile @fileName='file path', @downloadPath='D:\download\file.txt'


Http Call

/egnyte/downloadfile

Output Columns

String fileName
String tmpFileName
Int64 byteTx
Double elapsedTime
String id
String downloadPath
Boolean override
Int32 timeout
Int32 retryCount
GetFolderPermissions
get folder permissions details 

Arguments

Name Description Default
folderPath R folder path is used to get the user permission

SQL Call

EXEC Egnyte.GetFolderPermissions '/shared/test001'


Http Call

/egnyte/getfolderpermissions

Output Columns

String folderPath
String username
String permission
GetFolderStatistics
get folder statistics details 

Arguments

Name Description Default
folderId R folder id is used to get the folder statistics

SQL Call

EXEC Egnyte.GetFolderStatistics 'folderid'


Http Call

/egnyte/getfolderstatistics

Output Columns

Int64 allVersionsSize
Int64 allFilesSize
Int64 filesCount
Int64 fileVersionsCount
Int64 foldersCount
Int64 allVersionsSizeInKB
GetToken
Generate access token details 

Arguments

Name Description Default
username R The username is used to generate token
password R The password is used to generate token

SQL Call

exec Egnyte.GetToken 'username','password'


Http Call

/egnyte/gettoken

Output Columns

String tokenType
Double expiresIn
String accessToken
GetUserPermissions
get user permissions details 

Arguments

Name Description Default
username R The username is used to get the permission of the user
folderPath R folder path is used to get the user permission

SQL Call

EXEC Egnyte.GetUserPermissions 'bsc-001','\shared\test001'


Http Call

/egnyte/getuserpermissions

Output Columns

String permission
listFiles
files 		Returns the list of files/folders details 

Arguments

Name Description Default
fileName The file name or path is used to get files
topn TOP N records will be returned (used with EXEC operation)

SQL Call

exec Egnyte.listFiles
SELECT * FROM Egnyte.files


Http Call

/egnyte/listfiles

Output Columns

String name
String path
Double size
String locked
String entryId
String groupId
String parentId
String uploadedBy
listFolders
folders 		Returns the list of folders details 

Arguments

Name Description Default
folderName The folder name or path is used to get folders
topn TOP N records will be returned (used with EXEC operation)

SQL Call

exec Egnyte.listFolders
SELECT * FROM Egnyte.folders


Http Call

/egnyte/listfolders

Output Columns

String id
String name
String path
String parentId
DateTime lastModified
DateTime uploaded
LockFile
file 		To lock file details 

Arguments

Name Description Default
fileName R file name with path to lock file

SQL Call

EXEC Egnyte.LockFile 'fileName'
insert into Egnyte.file (fileName) values ('D:	est.txt')


Http Call

/egnyte/lockfile

Output Columns

String action
String lockToken
String lockTimeout
MoveFile
move file from source to destination details 

Arguments

Name Description Default
sourcePath R source path is the file/folder to move
destinationPath R destination path is used to copy file or folder on given path

SQL Call

EXEC Egnyte.MoveFile 'sourcePath','destinationPath'


Http Call

/egnyte/movefile

Output Columns

This call does not return data.

MoveFolder
move folder from source to destination details 

Arguments

Name Description Default
sourcePath R source path is the file/folder to move
destinationPath R destination path is used to copy file or folder on given path

SQL Call

EXEC Egnyte.MoveFolder 'sourcePath','destinationPath'


Http Call

/egnyte/movefolder

Output Columns

This call does not return data.

SearchV1
search 		get folder permissions details 

Arguments

Name Description Default
searchText R The searchText is used to search filecontent,metadata and filename
topn TOP N records will be returned (used with EXEC operation)

SQL Call

EXEC Egnyte.SearchV1 '/shared/test001'
select * from Egnyte.search where searchText='/shared/test001'


Http Call

/egnyte/searchv1

Output Columns

String name
String path
String type
Double size
String snippet
String entryId
String groupId
DateTime lastModified
String uploadedBy
String uploadedByUsername
Int32 numVersions
String snippetHtml
Boolean isFolder
SetFolderPermissions
permissions 		Set folder permissions details 

Arguments

Name Description Default
path R folder path with name to set folder permissions
username R The username is used to set folder permissions
permission R The permission is used to set folder permissions (None, Viewer, Editor, Full, Owner)
groupname The groupname is used to set folder permissions

SQL Call

EXEC Egnyte.SetFolderPermissions 'folderpath'
insert into Egnyte.permissions (path) values ('path')


Http Call

/egnyte/setfolderpermissions

Output Columns

This call does not return data.

UnlockFile
To Unlock file details 

Arguments

Name Description Default
fileName R file name with path to unlock file
lockToken R lock token is used to unlock file

SQL Call

EXEC Egnyte.UnlockFile 'fileName','token'


Http Call

/egnyte/unlockfile

Output Columns

This call does not return data.

uploadFile
file 		Upload a file to OneDrive details 

Arguments

Name Description Default
sourceFile R The full path and name of the source file
fileName R The full path and name of the destination
override If true, overrides the file if it already exists (default: 0) False
timeout Timeout operation in minutes - default: 0 (no timeout) 0

SQL Call

EXEC Egnyte.uploadFile  @sourceFile='D:\Download\A100.pdf', @fileName='A100.pdf'


Http Call

/egnyte/uploadfile

Output Columns

This call does not return data.








601 21st St Suite 300
Vero Beach, FL 32960
United States

(561) 921-8669
info@enzounified.com
terms of service
privacy policy

PLATFORM

ENZO SERVER
ENZO DATAZEN

SOLUTIONS

SOLUTIONS OVERVIEW
INTEGRATION
SaaS
CLOUD ANALYTICS

RESOURCES

DOWNLOAD
BLOGS & VIDEOS
IN THE NEWS
ENZO ADAPTERS
ONLINE DOCUMENTATION
TCO CALCULATOR

COMPANY

LEADERSHIP TEAM
PARTNERS


© 2023 - Enzo Unified