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.
- API_KEY - For SSDC Public REST API Access. See: https://support.spreadsheet.com/hc/en-us/articles/6720959924372-API-Keys
- WORKSHEET_ID - Worksheet identifier. See: Spreadsheet.com API Documentation