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.
- Qlik Sense Business
- Qlik Sense Enterprise SaaS
- Qlik Sense Enterprise on Windows
- Qlik Sense Desktop
If you are using this connector on Qlik Sense Enterprise on Windows or Qlik Sense Desktop, you will need to set an encryption key.
For more information, see Setting an encryption key.
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.
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:
|ListFiles||Data manager and Data load editor||
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||Data load editor||Use this to list the file permissions for a specified File ID.|
|ListFileRevisions||Data load editor||Use this to list the file revision history of a specified File ID.|
|ListSharedDrives||Data load editor||Use this to list the user's shared drives|
|ListSpreadsheets||Data load editor||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||Data load editor||Use this to list the spreadsheet content of a specified Spreadsheet Key.|
|GetSheetInformation||Data load editor||Use this to view the spreadsheet metadata information of a specified Spreadsheet Key.|
|GetSheetValues||Data load editor||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.
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.
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.