Skip to main content

apps

Creates, updates, deletes, gets or lists an apps resource.

Overview

Nameapps
TypeResource
Idgoogleworkspace.drivev3.apps

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringThe ID of the app.
namestringThe name of the app.
authorizedbooleanWhether the app is authorized to access data on the user's Drive.
createInFolderTemplatestringThe template URL to create a file with this app in a given folder. The template contains the {folderId} to be replaced by the folder ID house the new file.
createUrlstringThe URL to create a file with this app.
hasDriveWideScopebooleanWhether the app has Drive-wide scope. An app with Drive-wide scope can access all files in the user's Drive.
iconsarrayThe various icons for the app.
installedbooleanWhether the app is installed.
kindstringOutput only. Identifies what kind of resource this is. Value: the fixed string "drive#app". (default: drive#app)
longDescriptionstringA long description of the app.
objectTypestringThe type of object this app creates such as a Chart. If empty, the app name should be used instead.
openUrlTemplatestringThe template URL for opening files with this app. The template contains {ids} or {exportIds} to be replaced by the actual file IDs. For more information, see Open Files for the full documentation.
primaryFileExtensionsarrayThe list of primary file extensions.
primaryMimeTypesarrayThe list of primary MIME types.
productIdstringThe ID of the product listing for this app.
productUrlstringA link to the product listing for this app.
secondaryFileExtensionsarrayThe list of secondary file extensions.
secondaryMimeTypesarrayThe list of secondary MIME types.
shortDescriptionstringA short description of the app.
supportsCreatebooleanWhether this app supports creating objects.
supportsImportbooleanWhether this app supports importing from Google Docs.
supportsMultiOpenbooleanWhether this app supports opening more than one file.
supportsOfflineCreatebooleanWhether this app supports creating files when offline.
useByDefaultbooleanWhether the app is selected as the default handler for the types it supports.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectappIdGets a specific app. For more information, see Return user info.
listselectappFilterExtensions, appFilterMimeTypes, languageCodeLists a user's installed apps. For more information, see Return user info.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
appIdstring
appFilterExtensionsstring
appFilterMimeTypesstring
languageCodestring

SELECT examples

Gets a specific app. For more information, see Return user info.

SELECT
id,
name,
authorized,
createInFolderTemplate,
createUrl,
hasDriveWideScope,
icons,
installed,
kind,
longDescription,
objectType,
openUrlTemplate,
primaryFileExtensions,
primaryMimeTypes,
productId,
productUrl,
secondaryFileExtensions,
secondaryMimeTypes,
shortDescription,
supportsCreate,
supportsImport,
supportsMultiOpen,
supportsOfflineCreate,
useByDefault
FROM googleworkspace.drivev3.apps
WHERE appId = '{{ appId }}' -- required
;