Tableau Connector for Google Calendar

Build 24.0.9062

DownloadAttachments

Downloads Google Calendar event attachments.

Execute

If the attachments you want to donwload are located in Google Drive you must include the 'https://www.googleapis.com/auth/drive' scope in the Scope connection property when authenticating.

To download a custom attachment (pubicly accessible link) you will need to specify the FileURL parameter.

EXEC DownloadAttachments FileURL = 'https://example.s3.eu-north-1.amazonaws.com/example.txt', LocalFile='C:/Users/User/Desktop/example.txt'

To download an attachment from your GoogleDrive you will need to specify the FileId parameter.

EXEC DownloadAttachments FileId = '1Zp70PuS5hu14wq07w7ZQhe_PHc-xxxxx', LocalFile='C:/Users/User/Desktop/example.txt'

To download all attachments of a specific event in a certain calendar, you must specify the CalendarId and EventId parameters.

EXEC DownloadAttachments CalendarId = 'fe47dca2f24f0b6d17085664dc9907049e038747a6f79339b893c49f56226c1e@group.calendar.google.com', EventId = '4dhb26rtkaegdj8du5b2rgbn25', LocalFile='C:/Users/User/Desktop/example.txt'

Input

Name Type Required Description
CalendarId String False The calendar identifier.
EventId String False The event identifier to download all the attachments from.
FileId String False The Google Drive file identifier of the attachment to be downloaded.
FileFormat String False Used for converting the downloaded file to a different file type. Files may only be converted up to 10MB. Leave this blank to download the file in the same format it is stored in Google. The possible values are application/vnd.openxmlformats-officedocument.wordprocessingml.document, application/vnd.oasis.opendocument.text, application/rtf, text/html, text/plain, and application/pdf.
FileURL String False The URL link to the attachment. Applicable only if the attachment is stored in another storage service different from Google Drive.
LocalFile String False The local file path including the file name for the location where the file will be saved on disk. Leave empty to keep the file in memory.
Overwrite Boolean False What to do when downloaded file exists. Set true to overwrite.

デフォルト値はfalseです。

Encoding String False If the LocalFile input is left empty, the data will be output to FileData in the specified encoding.

使用できる値は次のとおりです。NONE, BASE64

デフォルト値はBASE64です。

Result Set Columns

Name Type Description
FileData String If the LocalFile input is empty, file data will be output in the format specified by the Encoding input.
Success String This value shows a boolean indication of whether the operation was successful or not.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062