Download all Attachments in a Worksheet

Sharing a utility ( python client ) to download all field attachments in a worksheet. Download link.

Summary:

This utility leverages SSDC Public API to fetch a given worksheet’s data as JSON payload wherein individual field attachments are specified as Amazon S3 url’s.

It then downloads all such attachments into a folder and generates a summary CSV document specifying mappings for each attachment field ( per row ) and the corresponding downloaded file.

Execution:

  • Download project zip file and extract it onto local file system.

  • Follow instructions specified in README.txt in project root directory.

    • Execute from CLI with the root folder of project as current directory:

    ../SSDCAttachments > python attachmentDownloader.py --api_key qSmNFdF.xtN37ddsSXS7Ir9ab1-0BQ --worksheet_id Kz4qSLA1IauUllA-hCwbkJ

    Specify api_key & worksheet_id values as command-line args as shown in above example.