ADO.NET Provider for Google Calendar

Build 23.0.8839


Downloads Google Calendar event attachments.


If the attachments you want to donwload are located in Google Drive you must include the '' 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 = '', 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 = '', EventId = '4dhb26rtkaegdj8du5b2rgbn25', LocalFile='C:/Users/User/Desktop/example.txt'


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.


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.

使用できる値は次のとおりです。NONE, 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 23.0.8839