Connection
This section provides a complete list of the Connection properties you can configure in the connection settings for this provider.
Property | Description |
Spreadsheet | A comma-separated list of the names or Ids of the spreadsheets to be viewed. |
FolderName | A comma separated list of the folders' names from which to retrieve spreadsheets in the format FolderName='name1,name2'. |
FolderId | A comma separated list of the folders' ids from which to retrieve spreadsheets in the format FolderId='id1,id2,id3'. |
ShowTrashedFiles | Indicates whether or not the trashed files will be listed. |
SkipHiddenSheets | Indicates whether or not the hidden sheets will be listed. |
SupportsAllDrives | Determines whether or not to retrieve Drive items. |
UseIdAsTableName | Indicates whether or not to use Ids as Spreadsheet and Sheet name. |
TeamDrive | A drive's names or ids from which to retrieve spreadsheets in the format TeamDrive='Shared drive 2, Shared drive 3', or TeamDrive='0BKwyFj1j9FOsUk9EVO, 0ANMIP9RIe1LQUk9PVA'. |
DomainSharedFilesOnly | Boolean determining if the exposed sheets are limited to only the sheets shared to the user's domain or not. |
RecurseFolders | Used in case FolderId/FolderName properties are defined. If set to True this makes the driver return all the Spreadsheets inside nested folders, else the driver will return only the files directly to that foder. By default this is set to false. |
IgnoreErrorValues | When enabled, fields where the provider detects error values will be returned as NULL. If disabled, the provider throws an error if an error value is detected in any field. |