StiGoogleSheetsConnector Class
Namespace: Stimulsoft.Base.Data.Connectors.Google
Inheritance
Inherits from: StiDataConnector
Constructors
| Constructor | Description |
|---|---|
| StiGoogleSheetsConnector() |
StiGoogleSheetsConnector()
Properties
| Property | Type | Description |
|---|---|---|
| ApiKey | string | |
| ClientId | string | |
| ClientSecret | string | |
| FirstRowIsHeader | bool | |
| SpreadsheetId | string |
Methods
| Method | Returns | Description |
|---|---|---|
Get static |
StiGoogleSheetsConnector | |
| GetColumns | List<StiDataColumnSchema> | |
| GetDataTable | DataTable | |
| RetrieveSchema | StiDataSchema |
Method Details
Get static
Get(clientId: string, clientSecret: string, spreadsheetId: string, firstRowIsHeader: bool, apiKey: string): StiGoogleSheetsConnector
Parameters
- clientId (string)
- clientSecret (string)
- spreadsheetId (string)
- firstRowIsHeader (bool)
- apiKey (string)
Returns StiGoogleSheetsConnector
GetColumns
GetColumns(collectionName: string): List<StiDataColumnSchema>
Parameters
- collectionName (string)
Returns List<StiDataColumnSchema>
GetDataTable
GetDataTable(collectionName: string, query: string, index: int?, count: int?): DataTable
Parameters
- collectionName (string)
- query (string)
- index (int?)
- count (int?)
Returns DataTable
RetrieveSchema
RetrieveSchema(allowException: bool): StiDataSchema
Parameters
- allowException (bool)
Returns StiDataSchema