Export-GSDriveFile
SYNOPSIS
Exports a Drive file as if you chose "Export" from the File menu when viewing the file
SYNTAX
Depth (Default)
Export-GSDriveFile [-FileID] <String> [-User <String>] -Type <String> [-OutFilePath <String>]
[-Projection <String>] [-Force] [<CommonParameters>]
Fields
Export-GSDriveFile [-FileID] <String> [-User <String>] -Type <String> [-OutFilePath <String>]
[-Fields <String[]>] [-Force] [<CommonParameters>]
DESCRIPTION
Exports a Drive file as if you chose "Export" from the File menu when viewing the file
EXAMPLES
EXAMPLE 1
Export-GSDriveFile -FileId '1rhsAYTOB_vrpvfwImPmWy0TcVa2sgmQa_9u976' -Type CSV -OutFilePath .\SheetExport.csv
Exports the Drive file as a CSV to the current working directory
PARAMETERS
-FileID
The unique Id of the file to export
Type: System.String
Parameter Sets: (All)
Aliases:
Required: True
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-User
The email or unique Id of the owner of the Drive file
Defaults to the AdminEmail user
Type: System.String
Parameter Sets: (All)
Aliases: Owner, PrimaryEmail, UserKey, Mail
Required: False
Position: Named
Default value: $Script:PSGSuite.AdminEmail
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False
-Type
The type of local file you would like to export the Drive file as
Available values are: * "CSV" * "HTML" * "JPEG" * "JSON" * "MSExcel" * "MSPowerPoint" * "MSWordDoc" * "OpenOfficeDoc" * "OpenOfficeSheet" * "PDF" * "PlainText" * "PNG" * "RichText" * "SVG"
Type: System.String
Parameter Sets: (All)
Aliases:
Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-OutFilePath
The directory path that you would like to export the Drive file to
Defaults to the current working directory
Type: System.String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-Projection
The defined subset of fields to be returned
Available values are: * "Minimal" * "Standard" * "Full" * "Access"
Type: System.String
Parameter Sets: Depth
Aliases: Depth
Required: False
Position: Named
Default value: Full
Accept pipeline input: False
Accept wildcard characters: False
-Fields
The specific fields to returned
Type: System.String[]
Parameter Sets: Fields
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-Force
If $true, overwrites any existing files at the same path.
Type: System.Management.Automation.SwitchParameter
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.