Reference

Table SheetDetails

Description

Read sheet information (i.e. tabs on a sheet) for a specified SpreadSheetId

Supported Operations

Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.

Method	Supported	Reference EndPoint
SELECT		get_sheet_properties
INSERT
UPDATE
UPSERT
DELETE
LOOKUP		get_sheet_properties

Examples

SSIS

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

Read from SheetDetails table using API Source

API Source - Google Sheets

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

Google Sheets

SheetDetails

Required Parameters
SpreadSheetId	Fill-in the parameter...
Optional Parameters
IncludeParentColumns	False

SSIS API Source - Read from table or endpoint

Read/write to SheetDetails table using API Destination

API Destination - Google Sheets

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

Google Sheets

SheetDetails

Select

Required Parameters
SpreadSheetId	Fill-in the parameter...
Optional Parameters
IncludeParentColumns	False

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get SheetDetails

SELECT * FROM SheetDetails

SQL Server

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

Get SheetDetails

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM SheetDetails';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_SHEETS_IN_GATEWAY];