Google Drive Sanitized Data

The following table(s) contains detailed examples of the metadata fields available from the Google Drive API endpoints Worklytics leverages. In order to pseudonymize and sanitize PII and other potentially sensitive data, Worklytics provides access to a Data Loss Prevention (DLP) Proxy, which allows customers to pre-filter metadata, within customer infrastructure, before it is sent to Worklytics for processing.

These are the fields Worklytics recommends but the Worklytics DLP Proxy provides full field-level control and therefore any field may be removed or sanitized.

Field descriptions are taken from third party API documentation, these are maintained on a best effort basis and Worklytics can not guarantee their indefinite accuracy. Please refer to the source API site for the most up-to-date documentation.

How to read the "DLP Proxy" column in the table(s):

⭕ This field is transformed, usually partially redacted

🟡 This field is "pseudonymized" by the DLP Proxy: only a SHA256 hash of its value is sent to Worklytics; never the value itself

To see the full (unsanitized) version of this document, click here.

Worklytics requires access to the following API primary endpoints:

Model	Description	API docs
File	Used to retrieve a collection of files Endpoints: /drive/v3/files	🔗↗️
PermissionList	Used to retrieve a collection of permissions Endpoints: /drive/v3/files/{fileId}/permissions	🔗↗️
RevisionList	Used to retrieve a collection of file revisions Endpoints: /drive/v3/files/{fileId}/revisions	🔗↗️

File

API docs: https://developers.google.com/drive/api/v3/reference/files#resource

DLP Proxy docs: Google Drive

DLP Proxy	Property Name	Type	Description
🟢 Allowed	alternateLink	String
🟢 Allowed	appDataContents	Boolean
🟢 Allowed	canComment	Boolean
🟢 Allowed	canReadRevisions	Boolean
🟢 Allowed	capabilities	Capabilities
🟢 Allowed	capabilities.canAddChildren	Boolean
🟢 Allowed	capabilities.canAddFolderFromAnotherDrive	Boolean
🟢 Allowed	capabilities.canAddMyDriveParent	Boolean
🟢 Allowed	capabilities.canChangeCopyRequiresWriterPermission	Boolean
🟢 Allowed	capabilities.canChangeRestrictedDownload	Boolean
🟢 Allowed	capabilities.canChangeSecurityUpdateEnabled	Boolean
🟢 Allowed	capabilities.canComment	Boolean
🟢 Allowed	capabilities.canCopy	Boolean
🟢 Allowed	capabilities.canDelete	Boolean
🟢 Allowed	capabilities.canDeleteChildren	Boolean
🟢 Allowed	capabilities.canDownload	Boolean
🟢 Allowed	capabilities.canEdit	Boolean
🟢 Allowed	capabilities.canListChildren	Boolean
🟢 Allowed	capabilities.canModifyContent	Boolean
🟢 Allowed	capabilities.canModifyContentRestriction	Boolean
🟢 Allowed	capabilities.canMoveChildrenOutOfDrive	Boolean
🟢 Allowed	capabilities.canMoveChildrenOutOfTeamDrive	Boolean
🟢 Allowed	capabilities.canMoveChildrenWithinDrive	Boolean
🟢 Allowed	capabilities.canMoveChildrenWithinTeamDrive	Boolean
🟢 Allowed	capabilities.canMoveItemIntoTeamDrive	Boolean
🟢 Allowed	capabilities.canMoveItemOutOfDrive	Boolean
🟢 Allowed	capabilities.canMoveItemOutOfTeamDrive	Boolean
🟢 Allowed	capabilities.canMoveItemWithinDrive	Boolean
🟢 Allowed	capabilities.canMoveItemWithinTeamDrive	Boolean
🟢 Allowed	capabilities.canMoveTeamDriveItem	Boolean
🟢 Allowed	capabilities.canReadDrive	Boolean
🟢 Allowed	capabilities.canReadRevisions	Boolean
🟢 Allowed	capabilities.canReadTeamDrive	Boolean
🟢 Allowed	capabilities.canRemoveChildren	Boolean
🟢 Allowed	capabilities.canRemoveMyDriveParent	Boolean
🟢 Allowed	capabilities.canRename	Boolean
🟢 Allowed	capabilities.canShare	Boolean
🟢 Allowed	capabilities.canTrash	Boolean
🟢 Allowed	capabilities.canTrashChildren	Boolean
🟢 Allowed	capabilities.canUntrash	Boolean
🟢 Allowed	contentRestrictions[]	List of ContentRestriction
🟢 Allowed	contentRestrictions[].readOnly	Boolean
🟢 Allowed	contentRestrictions[].reason	String
🟢 Allowed	contentRestrictions[].restrictingUser	User
🟢 Allowed	contentRestrictions[].restrictingUser.emailAddress	String	Email address of the user Raw example: [e-mail] Sanitized example: { "scope":"email", "domain":"acme.com", "hash":"aT3usZghgyWmDoXRncq5qhmQJQMjY49xDJylpM4TyYI" }
🟢 Allowed	contentRestrictions[].restrictingUser.kind	String
🟢 Allowed	contentRestrictions[].restrictingUser.me	Boolean
🟢 Allowed	contentRestrictions[].restrictingUser.permissionId	String
🟢 Allowed	contentRestrictions[].restrictionDate	DateTime
🟢 Allowed	contentRestrictions[].restrictionDate.value	long
🟢 Allowed	copyRequiresWriterPermission	Boolean
🟢 Allowed	copyable	Boolean
🟢 Allowed	createdDate	DateTime
🟢 Allowed	createdDate.value	long
🟢 Allowed	defaultOpenWithLink	String
🟢 Allowed	downloadUrl	String
🟢 Allowed	driveId	String
🟢 Allowed	editable	Boolean
🟢 Allowed	embedLink	String
🟢 Allowed	etag	String
🟢 Allowed	explicitlyTrashed	Boolean
🟢 Allowed	exportLinks	Map of String
🟢 Allowed	fileExtension	String
🟢 Allowed	fileSize	Long
🟢 Allowed	folderColorRgb	String
🟢 Allowed	fullFileExtension	String
🟢 Allowed	hasAugmentedPermissions	Boolean
🟢 Allowed	hasThumbnail	Boolean
🟢 Allowed	headRevisionId	String
🟢 Allowed	iconLink	String
🟢 Allowed	id	String
🟢 Allowed	imageMediaMetadata	ImageMediaMetadata
🟢 Allowed	imageMediaMetadata.aperture	Float
🟢 Allowed	imageMediaMetadata.cameraMake	String
🟢 Allowed	imageMediaMetadata.cameraModel	String
🟢 Allowed	imageMediaMetadata.colorSpace	String
🟢 Allowed	imageMediaMetadata.date	String
🟢 Allowed	imageMediaMetadata.exposureBias	Float
🟢 Allowed	imageMediaMetadata.exposureMode	String
🟢 Allowed	imageMediaMetadata.exposureTime	Float
🟢 Allowed	imageMediaMetadata.flashUsed	Boolean
🟢 Allowed	imageMediaMetadata.focalLength	Float
🟢 Allowed	imageMediaMetadata.height	Integer
🟢 Allowed	imageMediaMetadata.isoSpeed	Integer
🟢 Allowed	imageMediaMetadata.lens	String
🟢 Allowed	imageMediaMetadata.location	Location
🟢 Allowed	imageMediaMetadata.location.altitude	Double
🟢 Allowed	imageMediaMetadata.location.latitude	Double
🟢 Allowed	imageMediaMetadata.location.longitude	Double
🟢 Allowed	imageMediaMetadata.maxApertureValue	Float
🟢 Allowed	imageMediaMetadata.meteringMode	String
🟢 Allowed	imageMediaMetadata.rotation	Integer
🟢 Allowed	imageMediaMetadata.sensor	String
🟢 Allowed	imageMediaMetadata.subjectDistance	Integer
🟢 Allowed	imageMediaMetadata.whiteBalance	String
🟢 Allowed	imageMediaMetadata.width	Integer
🟢 Allowed	indexableText	IndexableText
🟢 Allowed	indexableText.text	String
🟢 Allowed	isAppAuthorized	Boolean
🟢 Allowed	kind	String
🟢 Allowed	labels	Labels
🟢 Allowed	labels.hidden	Boolean
🟢 Allowed	labels.modified	Boolean
🟢 Allowed	labels.restricted	Boolean
🟢 Allowed	labels.starred	Boolean
🟢 Allowed	labels.trashed	Boolean
🟢 Allowed	labels.viewed	Boolean
🟢 Allowed	lastModifyingUser	User
🟢 Allowed	lastModifyingUserName	String
🟢 Allowed	lastViewedByMeDate	DateTime
🟢 Allowed	lastViewedByMeDate.value	long
🟢 Allowed	linkShareMetadata	LinkShareMetadata
🟢 Allowed	linkShareMetadata.securityUpdateEligible	Boolean
🟢 Allowed	linkShareMetadata.securityUpdateEnabled	Boolean
🟢 Allowed	markedViewedByMeDate	DateTime
🟢 Allowed	markedViewedByMeDate.value	long
🟢 Allowed	md5Checksum	String
🟢 Allowed	mimeType	String
🟢 Allowed	modifiedByMeDate	DateTime
🟢 Allowed	modifiedByMeDate.value	long
🟢 Allowed	modifiedDate	DateTime
🟢 Allowed	modifiedDate.value	long
🟢 Allowed	openWithLinks	Map of String
🟢 Allowed	ownedByMe	Boolean
🟢 Allowed	owners[]	List of User
🟢 Allowed	parents[]	List of ParentReference
🟢 Allowed	parents[].id	String
🟢 Allowed	parents[].kind	String
🟢 Allowed	permissionIds	List of String
🟢 Allowed	permissions[]	List of Permission
🟢 Allowed	permissions[].additionalRoles	List of String
🟢 Allowed	permissions[].authKey	String
🟢 Allowed	permissions[].deleted	Boolean
🟢 Allowed	permissions[].domain	String
🟢 Allowed	permissions[].emailAddress	String	Raw example: [e-mail] Sanitized example: { "scope":"email", "domain":"acme.com", "hash":"aT3usZghgyWmDoXRncq5qhmQJQMjY49xDJylpM4TyYI" }
🟢 Allowed	permissions[].etag	String
🟢 Allowed	permissions[].expirationDate	DateTime
🟢 Allowed	permissions[].expirationDate.value	long
🟢 Allowed	permissions[].id	String
🟢 Allowed	permissions[].kind	String
🟢 Allowed	permissions[].name	String
🟢 Allowed	permissions[].permissionDetails[]	List of PermissionDetails
🟢 Allowed	permissions[].permissionDetails[].additionalRoles	List of String
🟢 Allowed	permissions[].permissionDetails[].inherited	Boolean
🟢 Allowed	permissions[].permissionDetails[].inheritedFrom	String
🟢 Allowed	permissions[].permissionDetails[].permissionType	String
🟢 Allowed	permissions[].permissionDetails[].role	String
🟢 Allowed	permissions[].role	String
🟢 Allowed	permissions[].selfLink	String
🟢 Allowed	permissions[].teamDrivePermissionDetails[]	List of TeamDrivePermissionDetails
🟢 Allowed	permissions[].teamDrivePermissionDetails[].additionalRoles	List of String
🟢 Allowed	permissions[].teamDrivePermissionDetails[].inherited	Boolean
🟢 Allowed	permissions[].teamDrivePermissionDetails[].inheritedFrom	String
🟢 Allowed	permissions[].teamDrivePermissionDetails[].role	String
🟢 Allowed	permissions[].teamDrivePermissionDetails[].teamDrivePermissionType	String
🟢 Allowed	permissions[].type	String
🟢 Allowed	permissions[].value	String
🟢 Allowed	permissions[].view	String
🟢 Allowed	permissions[].withLink	Boolean
🟢 Allowed	properties[]	List of Property
🟢 Allowed	properties[].key	String
🟢 Allowed	properties[].value	String
🟢 Allowed	properties[].visibility	String
🟢 Allowed	quotaBytesUsed	Long
🟢 Allowed	resourceKey	String
🟢 Allowed	selfLink	String
🟢 Allowed	shareable	Boolean
🟢 Allowed	shared	Boolean
🟢 Allowed	sharedWithMeDate	DateTime
🟢 Allowed	sharedWithMeDate.value	long
🟢 Allowed	sharingUser	User
🟢 Allowed	shortcutDetails	ShortcutDetails
🟢 Allowed	shortcutDetails.targetId	String
🟢 Allowed	shortcutDetails.targetMimeType	String
🟢 Allowed	shortcutDetails.targetResourceKey	String
🟢 Allowed	spaces	List of String
🟢 Allowed	teamDriveId	String
🟢 Allowed	thumbnail	Thumbnail
🟢 Allowed	thumbnail.image	String
🟢 Allowed	thumbnail.mimeType	String
🟢 Allowed	thumbnailLink	String
🟢 Allowed	thumbnailVersion	Long
🟢 Allowed	trashedDate	DateTime
🟢 Allowed	trashedDate.value	long
🟢 Allowed	trashingUser	User
🟢 Allowed	userPermission	Permission
🟢 Allowed	userPermission.additionalRoles	List of String
🟢 Allowed	userPermission.authKey	String
🟢 Allowed	userPermission.deleted	Boolean
🟢 Allowed	userPermission.domain	String
🟢 Allowed	userPermission.emailAddress	String	Raw example: [e-mail] Sanitized example: { "scope":"email", "domain":"acme.com", "hash":"aT3usZghgyWmDoXRncq5qhmQJQMjY49xDJylpM4TyYI" }
🟢 Allowed	userPermission.etag	String
🟢 Allowed	userPermission.expirationDate	DateTime
🟢 Allowed	userPermission.expirationDate.value	long
🟢 Allowed	userPermission.id	String
🟢 Allowed	userPermission.kind	String
🟢 Allowed	userPermission.name	String
🟢 Allowed	userPermission.permissionDetails[]	List of PermissionDetails
🟢 Allowed	userPermission.permissionDetails[].additionalRoles	List of String
🟢 Allowed	userPermission.permissionDetails[].inherited	Boolean
🟢 Allowed	userPermission.permissionDetails[].inheritedFrom	String
🟢 Allowed	userPermission.permissionDetails[].permissionType	String
🟢 Allowed	userPermission.permissionDetails[].role	String
🟢 Allowed	userPermission.role	String
🟢 Allowed	userPermission.selfLink	String
🟢 Allowed	userPermission.teamDrivePermissionDetails[]	List of TeamDrivePermissionDetails
🟢 Allowed	userPermission.teamDrivePermissionDetails[].additionalRoles	List of String
🟢 Allowed	userPermission.teamDrivePermissionDetails[].inherited	Boolean
🟢 Allowed	userPermission.teamDrivePermissionDetails[].inheritedFrom	String
🟢 Allowed	userPermission.teamDrivePermissionDetails[].role	String
🟢 Allowed	userPermission.teamDrivePermissionDetails[].teamDrivePermissionType	String
🟢 Allowed	userPermission.type	String
🟢 Allowed	userPermission.value	String
🟢 Allowed	userPermission.view	String
🟢 Allowed	userPermission.withLink	Boolean
🟢 Allowed	version	Long
🟢 Allowed	videoMediaMetadata	VideoMediaMetadata
🟢 Allowed	videoMediaMetadata.durationMillis	Long
🟢 Allowed	videoMediaMetadata.height	Integer
🟢 Allowed	videoMediaMetadata.width	Integer
🟢 Allowed	webContentLink	String
🟢 Allowed	webViewLink	String
🟢 Allowed	writersCanShare	Boolean

PermissionList

API docs: https://developers.google.com/drive/api/v3/reference/permissions#resource

DLP Proxy docs: Google Drive

DLP Proxy	Property Name	Type	Description
🟢 Allowed	etag	String
🟢 Allowed	items[]	List of Permission
🟢 Allowed	items[].additionalRoles	List of String
🟢 Allowed	items[].authKey	String
🟢 Allowed	items[].deleted	Boolean
🟢 Allowed	items[].domain	String
🟢 Allowed	items[].emailAddress	String	Raw example: [e-mail] Sanitized example: { "scope":"email", "domain":"acme.com", "hash":"aT3usZghgyWmDoXRncq5qhmQJQMjY49xDJylpM4TyYI" }
🟢 Allowed	items[].etag	String
🟢 Allowed	items[].expirationDate	DateTime
🟢 Allowed	items[].expirationDate.value	long
🟢 Allowed	items[].id	String
🟢 Allowed	items[].kind	String
🟢 Allowed	items[].name	String
🟢 Allowed	items[].permissionDetails[]	List of PermissionDetails
🟢 Allowed	items[].permissionDetails[].additionalRoles	List of String
🟢 Allowed	items[].permissionDetails[].inherited	Boolean
🟢 Allowed	items[].permissionDetails[].inheritedFrom	String
🟢 Allowed	items[].permissionDetails[].permissionType	String
🟢 Allowed	items[].permissionDetails[].role	String
🟢 Allowed	items[].role	String
🟢 Allowed	items[].selfLink	String
🟢 Allowed	items[].teamDrivePermissionDetails[]	List of TeamDrivePermissionDetails
🟢 Allowed	items[].teamDrivePermissionDetails[].additionalRoles	List of String
🟢 Allowed	items[].teamDrivePermissionDetails[].inherited	Boolean
🟢 Allowed	items[].teamDrivePermissionDetails[].inheritedFrom	String
🟢 Allowed	items[].teamDrivePermissionDetails[].role	String
🟢 Allowed	items[].teamDrivePermissionDetails[].teamDrivePermissionType	String
🟢 Allowed	items[].type	String
🟢 Allowed	items[].value	String
🟢 Allowed	items[].view	String
🟢 Allowed	items[].withLink	Boolean
🟢 Allowed	kind	String
🟢 Allowed	nextPageToken	String

RevisionList

API docs: https://developers.google.com/drive/api/v3/reference/revisions#resource

DLP Proxy docs: Google Drive

DLP Proxy	Property Name	Type	Description
🟢 Allowed	etag	String
🟢 Allowed	items[]	List of Revision
🟢 Allowed	items[].downloadUrl	String
🟢 Allowed	items[].etag	String
🟢 Allowed	items[].exportLinks	Map of String
🟢 Allowed	items[].fileSize	Long
🟢 Allowed	items[].id	String
🟢 Allowed	items[].kind	String
🟢 Allowed	items[].lastModifyingUser	User
🟢 Allowed	items[].lastModifyingUser.emailAddress	String	Email address of the user Raw example: [e-mail] Sanitized example: { "scope":"email", "domain":"acme.com", "hash":"aT3usZghgyWmDoXRncq5qhmQJQMjY49xDJylpM4TyYI" }
🟢 Allowed	items[].lastModifyingUser.kind	String
🟢 Allowed	items[].lastModifyingUser.me	Boolean
🟢 Allowed	items[].lastModifyingUser.permissionId	String
🟢 Allowed	items[].lastModifyingUserName	String
🟢 Allowed	items[].md5Checksum	String
🟢 Allowed	items[].mimeType	String
🟢 Allowed	items[].modifiedDate	DateTime
🟢 Allowed	items[].modifiedDate.value	long
🟢 Allowed	items[].pinned	Boolean
🟢 Allowed	items[].publishAuto	Boolean
🟢 Allowed	items[].published	Boolean
🟢 Allowed	items[].publishedLink	String
🟢 Allowed	items[].publishedOutsideDomain	Boolean
🟢 Allowed	items[].selfLink	String
🟢 Allowed	kind	String
🟢 Allowed	nextPageToken	String
🟢 Allowed	selfLink	String