Google Drive Connectors

ZappySys Google Drive Connector provide read / write capability inside your app (see list below), using these drag and drop , high performance connectors you can perform many Google Drive operations without any coding. You can use this connector to integrate Google Drive data inside apps like SSIS, SQL Server or popular ETL Platforms / BI Tools/ Reporting Apps / Programming languages (i.e. Informatica, Power BI, SSRS, Excel, C#, JAVA, Python)

Download for SSIS Download for Other Apps Documentation

Video Tutorial - Google Drive - Connectors REST API Integration

Click on your App below to get started with Google Drive Integration

Choose your App / Scenario for which you like to integrate Google Drive

SSIS

SQL Server

Power BI

SSRS

Informatica

MS Access

MS Excel

SSAS

Python

JAVA

Tableau

SAP Crystal Reports

Azure Data Factory (ADF)

ODBC

Actions supported by Google Drive Connector

Google Drive Connector support following actions for REST API integration. If some actions are not listed below then you can easily edit Connector file and enhance out of the box functionality.

Get drive info

Gets drive information

Search items

Lists items (i.e. files / folders) with search criteria

List folders

Lists folders

Parameter	Description
PageSize
Search Criteria

List files

Lists files

Parameter

Description

PageSize

Search Criteria

Data filter (e.g. somecolumn -eq 'somevalue' ) , User can select multiple filter criteria using 'AND','OR' operator , Note*:- please refer the link for more filter criteria : https://zappysys.com/links?url=https://developers.google.com/drive/api/guides/search-files

Option	Value
none
Allow only shared files and folders	sharedWithMe=true
Skip trashed files	trashed=false
Skip Folders	mimeType!='application/vnd.google-apps.folder'
Skip App Script	mimeType!='application/vnd.google-apps.script'
Search for file name	name='enter the filename here'
Search for full text	fullText contains 'enter the fullText here'
Search for spreadsheet	mimeType = 'application/vnd.google-apps.spreadsheet'
Search for multiple files type	mimeType contains 'application/vnd.google-apps.spreadsheet' OR mimeType contains 'application/vnd.google-apps.document' OR mimeType contains 'application/vnd.google-apps.presentation' OR mimeType contains 'application/vnd.google-apps.drawing'

List deleted files

Lists files

Parameter	Description
PageSize
Search Criteria

Get file info

Gets information of a file

Parameter	Description
Id	Id of a file you want to see information for

Download a file

Downloads a file

Parameter	Description
File Id	Id of a file you want to download

Export a file

Export a document editor files such document, Spreadsheets, Drawings, Presentations, Apps Scripts to common file formats as defined in this link https://developers.google.com/drive/api/guides/ref-export-formats

Parameter

Description

File Id

Id of a file you want to export and file must be editor type (e.g. document, Spreadsheets, Drawings, Presentations, Apps Scripts)

Export As (Mime Type)

The MIME type of the format requested for this export.

Option	Value
None
Export to PDF	application/pdf
Export to HTML	text/html
Export to HTML (zipped)	application/zip
Export to Plain text	text/plain
Export to Rich text	application/rtf
Export to Open Office doc	application/vnd.oasis.opendocument.text
Export to MS Word document	application/vnd.openxmlformats-officedocument.wordprocessingml.document
Export to EPUB	application/epub+zip
Export to MS Excel	application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Export to Open Office sheet	application/x-vnd.oasis.opendocument.spreadsheet
Export to (sheet only)	text/tab-separated-values
Export to JPEG	image/jpeg
Export to PNG	image/png
Export to SVG	image/svg+xml
Export to MS PowerPoint	application/vnd.openxmlformats-officedocument.presentationml.presentation
Export to Open Office presentation	application/vnd.oasis.opendocument.presentation
Export to JSON	application/vnd.google-apps.script+json

fields

Upload a file

Uploads a file

Parameter	Description
FileName	A filename the file will have in Google Drive
DiskFilePath	Specify a disk file path
ParentFolderId	Id of a parent folder you want to upload the file in. Use value 'root' to place the file in the topmost level.
KeepRevisionForever	Defines whether uploaded file has revisions
AddParents	A comma-separated list of parent IDs to add
OcrLanguage	A language hint for OCR processing during image import (ISO 639-1 code).
UseContentAsIndexableText	Whether to use the uploaded content as indexable text.

Create a folder

Creates a folder

Parameter	Description
Name	A folder name the folder will have in Google Drive
ParentFolderId	Id of a parent folder you want to create the folder in. Use value 'root' to create the folder in the topmost level.

Delete an item

Deletes an item

Duplicate a file

Duplicates a file

Parameter	Description
Id	Id of a file you want to duplicate

Update a file

Update file

Parameter	Description
Id	Id of a file you want to update
DiskFilePath	A disk file path you want to update file contents with
KeepRevisionForever	Defines whether uploaded file has revisions
AddParents	A comma-separated list of parent IDs to add
OcrLanguage	A language hint for OCR processing during image import (ISO 639-1 code).
UseContentAsIndexableText	Whether to use the uploaded content as indexable text.

Update metadata in a file

Updates meta-data in a file

Parameter

Description

Id of a file you want to update meta-data to

KeepRevisionForever

Defines whether uploaded file has revisions

Option	Value
True	True
False	False

AddParents

A comma-separated list of parent IDs to add

OcrLanguage

A language hint for OCR processing during image import (ISO 639-1 code).

UseContentAsIndexableText

Whether to use the uploaded content as indexable text.

Empty trash

Empties trash

Delete all items

Deletes all items from the drive

Generic Request

This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameter	Description
Url	API URL goes here. You can enter full URL or Partial URL relative to Base URL. If it is full URL then domain name must be part of ServiceURL or part of TrustedDomains
Body	Request Body content goes here
IsMultiPart	Check this option if you want to upload file(s) (i.e. POST RAW file data) or send data using Multi-Part encoding method (i.e. Content-Type: multipart/form-data). Multi-Part request allows you to mix key/value and upload files in same request. On the other hand raw upload allows only single file upload (without any key/value) ==== Raw Upload (Content-Type: application/octet-stream) ===== To upload single file in raw mode check this option and specify full file path starting with @ sign in the Body (e.g. @c:\data\myfile.zip ) ==== Form-Data / Multipart Upload (Content-Type: multipart/form-data) ===== To treat your Request data as multi part fields you must specify key/value pairs separated by new lines into RequestData field (i.e. Body). Each key value pair is entered on new-line and key/value are separated using equal sign (=). Preceding and trailing spaces are ignored also blank lines are ignored. If field value has some any special character(s) then use escape sequence (e.g. For NewLine: \r\n, For Tab: \t, For at (@): \@). When value of any field starts with at sign (@) its automatically treated as File you want to upload. By default file content type is determined based on extension however you can supply content type manually for any field using this way [ YourFileFieldName.Content-Type=some-content-type ]. By default File Upload Field always includes Content-Type in the request (non file fields do not have content-type by default unless you supply manually). For some reason if you dont want to use Content-Type header in your request then supply blank Content-Type to exclude this header altogather [e.g. SomeFieldName.Content-Type= ]. In below example we have supplied Content-Type for file2 and SomeField1, all other fields are using default content-type. See below Example of uploading multiple files along with additional fields. If some API requires you to pass Content-Type: multipart/form-data rather than multipart/form-data then manually set Request Header => Content-Type: multipart/mixed (it must starts with multipart/ else will be ignored). file1=@c:\data\Myfile1.txt file2=@c:\data\Myfile2.json file2.Content-Type=application/json SomeField1=aaaaaaa SomeField1.Content-Type=text/plain SomeField2=12345 SomeFieldWithNewLineAndTab=This is line1\r\nThis is line2\r\nThis is \ttab \ttab \ttab SomeFieldStartingWithAtSign=\@MyTwitterHandle
Filter	Enter filter to extract array from response. Example: $.rows[] --OR-- $.customers[].orders[*]. Check your response document and find out hierarchy you like to extract
Headers	Headers for Request. To enter multiple headers use double pipe or new line after each {header-name}:{value} pair