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]

Related Tables

Files

Parameters

Output Columns

Input Columns

Examples

SSIS

Use Google Drive Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - Google Drive

Read / write Google Drive data inside your app; perform many Google Drive operations without coding, just using easy to use high performance API Connector for Google Drive

Google Drive

Upload a file

Required Parameters
Target FileName	Fill-in the parameter...
Local FilePath	Fill-in the parameter...
Optional Parameters
Keep Revision Forever
Parent FolderId	root
Shared DriveId
Drive Type	user
Supports all drives (e.g. My and Shared)	true
RawOutputDataRowTemplate	{Status:'Uploaded'}
EnableRawOutputModeSingleRow	True
AddParents
OcrLanguage
UseContentAsIndexableText	False

API Destination

This Endpoint belongs to the Files table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to upload a file:

API Destination - Google Drive

Read / write Google Drive data inside your app; perform many Google Drive operations without coding, just using easy to use high performance API Connector for Google Drive

Google Drive

Files

Insert

Required Parameters
Target FileName	Fill-in the parameter...
Local FilePath	Fill-in the parameter...
Optional Parameters
Keep Revision Forever
Parent FolderId	root
Shared DriveId
Drive Type	user
Supports all drives (e.g. My and Shared)	true
RawOutputDataRowTemplate	{Status:'Uploaded'}
EnableRawOutputModeSingleRow	True
AddParents
OcrLanguage
UseContentAsIndexableText	False

ODBC application

Use these SQL queries in your ODBC application data source:

Upload a file with INSERT keyword

Upload a file with INSERT keyword. Advantage of INSERT is you can use Bulk option using SOURCE clause. This way you can upload many files

INSERT INTO Files
  WITH (FileName='My filename'
      ,DiskFilePath='C:\MyFolder\Mymyfile.ext'
      ,ParentFolderId='root'
	  )
  --You can get ParentFolderId by selecting from 'list_folders' endpoint or just use 'root'

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Upload a file with INSERT keyword

Upload a file with INSERT keyword. Advantage of INSERT is you can use Bulk option using SOURCE clause. This way you can upload many files

DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO Files
  WITH (FileName=''My filename''
      ,DiskFilePath=''C:\MyFolder\Mymyfile.ext''
      ,ParentFolderId=''root''
	  )
  --You can get ParentFolderId by selecting from ''list_folders'' endpoint or just use ''root''';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];