DownloadAttachments
Downloads Google Calendar event attachments.
Execute
If the attachments you want to download 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 (publicly accessible link), you must 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 must 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 | The MIME type the file should be downloaded as. This field can only be set when downloading Google Workspace documents. Leave this blank to download the file in the same format as 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 is saved on disk. Leave empty to keep the file in memory. |
| Overwrite | Boolean | False | What to do when a downloaded file exists. Set to true to overwrite.
The default value is false. |
| Encoding | String | False | If the LocalFile input is left empty, the data is output to FileData in the specified encoding. Allowed values are: BASE64 or NONE. |
Result Set Columns
| Name | Type | Description |
| FileData | String | If the LocalFile input is empty, the file data is output in the format specified by the Encoding input. |
| Success | String | Indicates whether the operation was successful. |