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 | Accepts Output Streams | Description |
| CalendarId | String | False | False | The calendar identifier. |
| EventId | String | False | False | The event identifier to download all the attachments from. |
| FileId | String | False | False | The Google Drive file identifier of the attachment to be downloaded. |
| FileFormat | String | False | 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 | 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 | 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 | False | What to do when downloaded file exists. Set true to overwrite.
The default value is false. |
| FileStream | String | False | True | An instance of an output stream where file data is written to. Only used if LocalFile is not set. |
| Encoding | String | False | False | If the LocalFile input is left empty, the data will be output to FileData in the specified encoding.
The allowed values are NONE, BASE64. The default value is 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. |