CreateFile
Files
|
Create new file at google drive root
details
Arguments
Name
|
Description
|
Default |
filename R
|
|
|
SQL Call
EXEC GoogleDrive.CreateFile
Http Call
/bsc/googledrive/createfile
Output Columns
|
CreateFileEx
FilesEx
|
Create new file at google drive root
details
Arguments
Name
|
Description
|
Default |
configName
|
|
|
filename R
|
|
|
SQL Call
EXEC GoogleDrive.CreateFileEx
Http Call
/bsc/googledrive/createfileex
Output Columns
|
CreateFolder
Folders
|
Create new folder at google drive root
details
Arguments
Name
|
Description
|
Default |
folderName R
|
|
|
parentFolder
|
|
|
SQL Call
EXEC GoogleDrive.CreateFolder INSERT INTO GoogleDrive.Folders@config1 (folderName) VALUES ('test')
Http Call
/bsc/googledrive/createfolder
Output Columns
String fileId | The fileId of the folder created |
|
CreateFolderEx
FoldersEx
|
Create new folder at google drive root
details
Arguments
Name
|
Description
|
Default |
configName
|
|
|
folderName R
|
|
|
parentFolder
|
|
|
SQL Call
EXEC GoogleDrive.CreateFolderEx INSERT INTO GoogleDrive.FoldersEx@config1 (folderName) VALUES ('test')
Http Call
/bsc/googledrive/createfolderex
Output Columns
String fileId | The fileId of the folder created |
|
DeleteFile
Files
|
Delete particular file by passing file id
details
Arguments
Name
|
Description
|
Default |
fileId R
|
|
|
SQL Call
EXEC GoogleDrive.DeleteFile delete FROM GoogleDrive.files@configName where fileId='1wjDjuiHWB8-mZZNDITWVjbWdgs5UI7Fe' delete FROM GoogleDrive.[files@configName] where fileId='1wjDjuiHWB8-mZZNDITWVjbWdgs5UI7Fe'
Http Call
/bsc/googledrive/deletefile
Output Columns
This call does not return data.
|
DeleteFileEx
FilesEx
|
Delete particular file by passing file id
details
Arguments
Name
|
Description
|
Default |
configName
|
|
|
fileId R
|
|
|
SQL Call
EXEC GoogleDrive.DeleteFileEx delete FROM GoogleDrive.FilesEx@configName where fileId='1wjDjuiHWB8-mZZNDITWVjbWdgs5UI7Fe' delete FROM GoogleDrive.[FilesEx@configName] where fileId='1wjDjuiHWB8-mZZNDITWVjbWdgs5UI7Fe'
Http Call
/bsc/googledrive/deletefileex
Output Columns
This call does not return data.
|
DeleteFolder
Folders
|
Delete particular file or folder by passing file id
details
Arguments
Name
|
Description
|
Default |
fileId R
|
|
|
SQL Call
EXEC GoogleDrive.DeleteFolder DELETE FROM GoogleDrive.Folders@configName where fileId='1wjDjuiHWB8-mZZNDITWVjbWdgs5UI7Fe' DELETE FROM GoogleDrive.[Folders@configName] where fileId='1wjDjuiHWB8-mZZNDITWVjbWdgs5UI7Fe'
Http Call
/bsc/googledrive/deletefolder
Output Columns
This call does not return data.
|
DeleteFolderEx
FoldersEx
|
Delete particular file or folder by passing file id
details
Arguments
Name
|
Description
|
Default |
configName
|
|
|
fileId R
|
|
|
SQL Call
EXEC GoogleDrive.DeleteFolderEx DELETE FROM GoogleDrive.FoldersEx@configName where fileId='1wjDjuiHWB8-mZZNDITWVjbWdgs5UI7Fe' DELETE FROM GoogleDrive.[FoldersEx@configName] where fileId='1wjDjuiHWB8-mZZNDITWVjbWdgs5UI7Fe'
Http Call
/bsc/googledrive/deletefolderex
Output Columns
This call does not return data.
|
DownloadFile
|
upload file at google drive on given path
details
Arguments
Name
|
Description
|
Default |
filename R
|
|
|
downloadPath
|
|
|
override
|
|
False |
timeout
|
|
0 |
retryCount
|
|
3 |
SQL Call
EXEC GoogleDrive.DownloadFile
Http Call
/bsc/googledrive/downloadfile
Output Columns
String fileName | | String tmpFileName | | Int64 byteTx | | Double elapsedTime | |
|
DownloadFileEx
|
upload file at google drive on given path
details
Arguments
Name
|
Description
|
Default |
configName
|
|
|
filename R
|
|
|
downloadPath
|
|
|
override
|
|
False |
timeout
|
|
0 |
retryCount
|
|
3 |
SQL Call
EXEC GoogleDrive.DownloadFileEx
Http Call
/bsc/googledrive/downloadfileex
Output Columns
String fileName | | String tmpFileName | | Int64 byteTx | | Double elapsedTime | |
|
getAuthURL
authURL
|
Get Authentication url
details
Arguments
Name
|
Description
|
Default |
scope
|
|
https://www.googleapis.com/auth/drive |
baseURL
|
|
https://accounts.google.com/o/oauth2/auth |
SQL Call
EXEC GoogleDrive.getAuthURL SELECT * FROM GoogleDrive.authURL WHERE scope='https://www.googleapis.com/auth/drive.file'
Http Call
/bsc/googledrive/getauthurl
Output Columns
|
getAuthURLEx
authURLEx
|
Get Authentication url
details
Arguments
Name
|
Description
|
Default |
configName
|
|
|
scope
|
|
https://www.googleapis.com/auth/drive |
baseURL
|
|
https://accounts.google.com/o/oauth2/auth |
SQL Call
EXEC GoogleDrive.getAuthURLEx SELECT * FROM GoogleDrive.authURLEx WHERE scope='https://www.googleapis.com/auth/drive.file'
Http Call
/bsc/googledrive/getauthurlex
Output Columns
|
getTokens
tokens
|
Get authentication token
details
Arguments
Name
|
Description
|
Default |
codeResponse R
|
|
|
SQL Call
EXEC GoogleDrive.getTokens SELECT * FROM GoogleDrive.tokens
Http Call
/bsc/googledrive/gettokens
Output Columns
String code | | String accessToken | | Int32 expiresIn | | String refreshToken | | String scope | | String token_type | |
|
getTokensEx
tokensEx
|
Get authentication token
details
Arguments
Name
|
Description
|
Default |
configName
|
|
|
codeResponse R
|
|
|
SQL Call
EXEC GoogleDrive.getTokensEx SELECT * FROM GoogleDrive.tokensEx
Http Call
/bsc/googledrive/gettokensex
Output Columns
String code | | String accessToken | | Int32 expiresIn | | String refreshToken | | String scope | | String token_type | |
|
ListFiles
Files
|
Read all the files from google drive root
details
Arguments
Name
|
Description
|
Default |
folder
|
|
|
fileName
|
|
|
createdDate
|
|
|
lastModifiedDate
|
|
|
SQL Call
EXEC GoogleDrive.ListFiles SELECT * FROM GoogleDrive.Files@configName SELECT * FROM GoogleDrive.[Files@configName]
Http Call
/bsc/googledrive/listfiles
Output Columns
String fileName | | String fileId | | DateTime createdDate | | DateTime lastModifiedDate | | Int64 fileSize | | String filePath | | String mimeType | | Boolean isFolder | |
|
ListFilesEx
FilesEx
|
Read all the files from google drive root
details
Arguments
Name
|
Description
|
Default |
configName
|
|
|
folder
|
|
|
fileName
|
|
|
createdDate
|
|
|
lastModifiedDate
|
|
|
SQL Call
EXEC GoogleDrive.ListFilesEx SELECT * FROM GoogleDrive.FilesEx@configName SELECT * FROM GoogleDrive.[FilesEx@configName]
Http Call
/bsc/googledrive/listfilesex
Output Columns
String fileName | | String fileId | | DateTime createdDate | | DateTime lastModifiedDate | | Int64 fileSize | | String filePath | | String mimeType | | Boolean isFolder | |
|
refreshTokens
accesstokens
|
Get access token
details
Arguments
SQL Call
EXEC GoogleDrive.refreshTokens SELECT * FROM GoogleDrive.accesstokens
Http Call
/bsc/googledrive/refreshtokens
Output Columns
String access_token | | Int32 expires_in | | String scope | | String token_type | |
|
refreshTokensEx
accesstokensEx
|
Get access token
details
Arguments
Name
|
Description
|
Default |
configName
|
|
|
SQL Call
EXEC GoogleDrive.refreshTokensEx SELECT * FROM GoogleDrive.accesstokensEx
Http Call
/bsc/googledrive/refreshtokensex
Output Columns
String access_token | | Int32 expires_in | | String scope | | String token_type | |
|
RenameFile
Files
|
Rename specific file by passing fileid
details
Arguments
Name
|
Description
|
Default |
fileId R
|
|
|
filename R
|
|
|
SQL Call
EXEC GoogleDrive.renamefile 'config2',@fileid='1wjDjuiHWB8-mZZNDITWVjbWdgs5UI7Fe',@filename='test' update GoogleDrive.files@config2 set filename = 'test' where fileid='1wjDjuiHWB8-mZZNDITWVjbWdgs5UI7Fe'
Http Call
/bsc/googledrive/renamefile
Output Columns
|
RenameFileEx
FilesEx
|
Rename specific file by passing fileid
details
Arguments
Name
|
Description
|
Default |
configName
|
|
|
fileId R
|
|
|
filename R
|
|
|
SQL Call
EXEC GoogleDrive.renamefileEx 'config2',@fileid='1wjDjuiHWB8-mZZNDITWVjbWdgs5UI7Fe',@filename='test' update GoogleDrive.filesEx@config2 set filename = 'test' where fileid='1wjDjuiHWB8-mZZNDITWVjbWdgs5UI7Fe'
Http Call
/bsc/googledrive/renamefileex
Output Columns
|
RenameFolder
Folders
|
Rename specific folder by passing fileid
details
Arguments
Name
|
Description
|
Default |
fileId R
|
|
|
filename R
|
|
|
SQL Call
EXEC GoogleDrive.renamefolder 'config2',@fileid='1wjDjuiHWB8-mZZNDITWVjbWdgs5UI7Fe',@filename='test' update GoogleDrive.folders@config2 set filename = 'test' where fileid='1wjDjuiHWB8-mZZNDITWVjbWdgs5UI7Fe'
Http Call
/bsc/googledrive/renamefolder
Output Columns
This call does not return data.
|
RenameFolderEx
FoldersEx
|
Rename specific folder by passing fileid
details
Arguments
Name
|
Description
|
Default |
configName
|
|
|
fileId R
|
|
|
filename R
|
|
|
SQL Call
EXEC GoogleDrive.renamefolderEx 'config2',@fileid='1wjDjuiHWB8-mZZNDITWVjbWdgs5UI7Fe',@filename='test' update GoogleDrive.foldersEx@config2 set filename = 'test' where fileid='1wjDjuiHWB8-mZZNDITWVjbWdgs5UI7Fe'
Http Call
/bsc/googledrive/renamefolderex
Output Columns
This call does not return data.
|
UploadFile
File
|
upload file at google drive on given path
details
Arguments
Name
|
Description
|
Default |
sourceFile R
|
|
|
filename R
|
|
|
override
|
|
False |
timeout
|
|
0 |
SQL Call
EXEC GoogleDrive.UploadFile INSERT INTO GoogleDrive.File@config1 (sourceFile,filename) VALUES ('abc.txt','d2.txt')
Http Call
/bsc/googledrive/uploadfile
Output Columns
String fileName | | String fileId | | Int64 byteTx | | Double elapsedTime | |
|
UploadFileEx
FileEx
|
upload file at google drive on given path
details
Arguments
Name
|
Description
|
Default |
configName
|
|
|
sourceFile R
|
|
|
filename R
|
|
|
override
|
|
False |
timeout
|
|
0 |
SQL Call
EXEC GoogleDrive.UploadFileEx INSERT INTO GoogleDrive.FileEx@config1 (sourceFile,filename) VALUES ('abc.txt','d2.txt')
Http Call
/bsc/googledrive/uploadfileex
Output Columns
String fileName | | String fileId | | Int64 byteTx | | Double elapsedTime | |
|