Endpoint Get Sheet Properties / Tab information

Name

get_sheet_properties

Description

Read read sheet properties (e.g. list of tabs on sheet and its properties) [API reference]

Related Tables

SheetDetails

Parameters

Output Columns

Input Columns

Examples

SSIS

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

API Source

This Endpoint belongs to the SheetDetails table, therefore it is better to use it, instead of accessing the endpoint directly:

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

API Destination

This Endpoint belongs to the SheetDetails table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get sheet properties / tab information:

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, Lookup

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

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];