Google Drive & Spreadsheets
The Qlik Google Drive & Spreadsheets connector uses the Google Drive API to access your Google Drive metadata, such as the names of files and subfolders in your Google Drive account.
Ways to access your data
You need to authenticate the connector with your Google Drive account credentials to access your Google Drive metadata. After you create a connection and select Google Drive & Spreadsheets as your data source, you are redirected to a Google Drive login page. Log in with your credentials to retrieve an authentication token, and enter it into the connector.
Creating a data source connection
Loading data from tables
After you authenticate the connector with your account credentials, use the tables to fetch your data. Below are use cases for some of the available tables:
Table | Available in | Description |
---|---|---|
ListFiles | 資料管理員 and 資料載入編輯器 |
Use this to list the files and subfolders of a folder located in your Google Drive account. You can select a drive ID from the drop-down. |
ListFilePermissions | 資料載入編輯器 | Use this to list the file permissions for a specified File ID. |
ListFileRevisions | 資料載入編輯器 | Use this to list the file revision history of a specified File ID. |
ListSharedDrives | 資料載入編輯器 | Use this to list the user's shared drives |
ListSpreadsheets | 資料載入編輯器 | Use this to list the spreadsheet content located in your Google Drive account. You can use a drive ID parameter to specify a shared drive, or leave it blank to indicate the default MyDrive. You can also type* (asterisk) to return data from all drives. This will not return items from the trash bin. |
ListWorksheets | 資料載入編輯器 | Use this to list the spreadsheet content of a specified Spreadsheet Key. |
GetSheetInformation | 資料載入編輯器 | Use this to view the spreadsheet metadata information of a specified Spreadsheet Key. |
GetSheetValues | 資料載入編輯器 | Use this to return a specified range of values, from a specified Spreadsheet Key. |
To select and load data from a table, enter the required table parameters and click Preview data. Required parameters are marked with an asterisk (*) in the dialog. The table fields are displayed under the Data preview tab. You can select fields individually by selecting the box beside each field name. Select Insert script after you have made your selection.
Creating a connection and selecting data
Reference - Google Drive API documentation
You can refer to the Google Drive API documentation to learn more about the requirements and restrictions imposed by the Google Drive API.
Troubleshooting
You receive an error message that you have reached the API rate limit
可能的原因
You have exceeded the API limits that are imposed by the Google Drive API.
建議的行動
To reduce the impact of reaching API rate limits, develop your app with the following in mind:
- Extract only the data you need.
- Reload one Google Drive-based application at a time.
- Ensure that loops in your script that make API calls do not result in infinite loops.