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
    ActiveCampaign
    Azure Bus
    Azure IoT Hub
    Azure Key Vault
    Azure Storage
    Bing Search
    ConstantContact
    CouchbaseDB
    CSV
    DB (RDBMS)
    Dropbox
    Files
    Flight Aware
    FreshBooks
    FTP
    Geonames
    GoogleDrive
    GoogleSearch
    GoogleSheet
    GreenMile
    GpsInsight
    HttpEndpoint (REST)
    Intacct
    Insteon
    Loggly
    MailChimp
    Messaging (SMS/SMTP)
    MongoDB
    Motus
    MSAD
    MSMQ
    OneDrive
    OneDrive365 (Business)
    Pipeline
    Pressero
    RabbitMQ
    SalesForce
    Shard
    SharePoint
    Slack
    SQL Server
    SQLX
    Sudoku
    Teams
    Threading
    Twilio
    Twitter
    VellemanDMX
    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/onedrive




OneDrive


Provides access to OneDrive (Personal) drives and files.


Configuration Settings



Name Description Default
Boolean _isDefault Make this the default configuration. Defaults to true if configName is already the default.
String appId appId used for authentication
String clientSecret clientSecret used for authentication
String accessToken The accessToken used for authentication
String refreshToken The refreshToken used for authentication of OneDrive api when expire accessToken

Handlers



createFolder
folders
Create new folder details 

Arguments

Name Description Default
folderName R
parentFolder

SQL Call

EXEC OneDrive.createFolder @folderName='Test Folder'
INSERT INTO OneDrive.folders (folderName) VALUES ('test')


Http Call

/bsc/onedrive/createfolder

Output Columns

This call does not return data.

deleteFile
files
Delete a file details 

Arguments

Name Description Default
fileId R

SQL Call

EXEC OneDrive.deleteFile  @fileId='fileid'
Delete from OneDrive.files where fileId='fileid'


Http Call

/bsc/onedrive/deletefile

Output Columns

This call does not return data.

deleteFolder
folders
Delete a folder details 

Arguments

Name Description Default
fileId R

SQL Call

EXEC OneDrive.deleteFolder @fileId='fileId'
Delete from OneDrive.folders where fileId='fileid'


Http Call

/bsc/onedrive/deletefolder

Output Columns

This call does not return data.

downloadFile
file
Download a file to a local or UNC path details 

Arguments

Name Description Default
id R
downloadPath
override False
timeout 0
retryCount 3

SQL Call

EXEC OneDrive.downloadFile @id='fileId',@downloadPath='D:\download'


Http Call

/bsc/onedrive/downloadfile

Output Columns

String fileName
String tmpFileName
Int64 byteTx
Double elapsedTime
String id
String downloadPath
Boolean override
Int32 timeout
Int32 retryCount
GetAuthUrl
Get Auth Url details 

Arguments


SQL Call

exec OneDrive.GetAuthUrl


Http Call

/bsc/onedrive/getauthurl

Output Columns

String Url
GetToken
Get access token details 

Arguments

Name Description Default
responseCode

SQL Call

exec OneDrive.GetToken 'responsecodeurl'


Http Call

/bsc/onedrive/gettoken

Output Columns

String code
String tokenType
Double expiresIn
String scope
String accessToken
String refreshToken
listFiles
files
Returns the list of files/folders details 

Arguments

Name Description Default
path
fileName
topn

SQL Call

exec OneDrive.listFiles
SELECT * FROM OneDrive.files


Http Call

/bsc/onedrive/listfiles

Output Columns

String id
String name
String webUrl
String size
String createdBy
DateTime createdDateTime
String lastModifiedBy
DateTime lastModifiedDateTime
Boolean isFolder
String path
RefreshToken
Forces the creation of a new access token for the current logged in user details 

Arguments

Name Description Default
refreshToken

SQL Call

exec OneDrive.RefreshToken 


Http Call

/bsc/onedrive/refreshtoken

Output Columns

String tokenType
Double expires_in
String scope
String accessToken
String refreshToken
renameFile
files
Rename an existing file details 

Arguments

Name Description Default
fileName R
id R

SQL Call

EXEC OneDrive.renameFile @fileName='testFile.doc',@id='fileId'
update OneDrive.folders set fileName='testFile.doc' where id='fileid'


Http Call

/bsc/onedrive/renamefile

Output Columns

This call does not return data.

renameFolder
folders
Rename an existing folder details 

Arguments

Name Description Default
fileName R
id R

SQL Call

EXEC OneDrive.renameFolder @fileName='test folder',@id='folderid'
update OneDrive.folders set fileName='test rename' where id='id'


Http Call

/bsc/onedrive/renamefolder

Output Columns

This call does not return data.

uploadFile
file
Upload a file to OneDrive details 

Arguments

Name Description Default
sourceFile R
fileName R
override False
timeout 0

SQL Call

EXEC OneDrive.uploadFile  @id='folderid',@sourceFile='D:\Download\A100.pdf',@fileName='A100.pdf'


Http Call

/bsc/onedrive/uploadfile

Output Columns

This call does not return data.