EndPoint Upload a file

Name

upload_file

Description

Uploads a file. If file exits it does not overwrite. If you like to overwrite existing file then use [Replace file data] endpoint. It requires FileId you like to replace. Get file id by calling list_parent_items or list_files endpoint (Search for file name and get id). Google API does not allow to perform create or replace in one operation. [API reference]

Parameters

Parameter

Label

Required

Options

Description

FileName

Target FileName

YES

A filename the file will have in Google Drive

DiskFilePath

Local FilePath

YES

Specify a disk file path

KeepRevisionForever

Keep Revision Forever

Option	Value
true	true
false	false

Defines whether uploaded file has revisions

ParentFolderId

Parent FolderId

Id of a parent folder you want to upload the file in. Use value 'root' to place the file in the topmost level.

DriveId

Shared DriveId

By default file lists from MyDrive but if you like to search other Shared drive then set this parameter.

DriveType

Drive Type

Option	Value
My Drive	user
Shared Drive	drive

Default search context is User's drive. Bodies of items (files/documents) to which the query applies. Supported bodies are 'user', 'domain', 'drive', and 'allDrives'. Prefer 'user' or 'drive' to 'allDrives' for efficiency. By default, corpora is set to 'user'. However, this can change depending on the filter set through the 'Query' parameter.

SupportsAllDrives

Supports all drives (e.g. My and Shared)

Option	Value
true	true
false	false

Whether the requesting application supports both My Drives and shared drives.

AddParents

A comma-separated list of parent IDs to add

ocrLanguage

OcrLanguage

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

useContentAsIndexableText

UseContentAsIndexableText

Whether to use the uploaded content as indexable text.

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(440)`	440	`False`
Kind	`DT_WSTR`	`nvarchar(200)`	200	`False`
Name	`DT_WSTR`	`nvarchar(780)`	780	`False`
MimeType	`DT_WSTR`	`nvarchar(650)`	650	`False`
FileSize	`DT_I8`	`bigint`		`False`
DriveId	`DT_WSTR`	`nvarchar(4000)`	4000	`False`

If the column you are looking for is missing, consider customizing Google Drive Connector.

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Google Drive Connector in API Source component to read data or in API Destination component to read/write data:

Insert into Files table using API Destination

This EndPoint belongs to Files table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Google Drive

Files

Insert