bel-download-file-from-crm-db

Download files from a CRM database by connecting via PostgreSQL credentials, retrieving base64-encoded file data by file_id, decoding it, and saving to the local filesystem with sanitized filenames and collision handling.

Yes, you can retrieve attachments and documents linked to CRM records through file junctions (company_site_file, person_file, event_file, sales_opportunity_file), then export them as individual files with metadata like name, MIME type, size, and hash.

You need PostgreSQL credentials configured via environment variables, psycopg2-binary installed, access to the CRM database schema including the file table and junction tables, and write permissions to the output directory.

The Skill automatically handles name collisions by generating unique filenames during export to _RESULTS_FROM_AGENT/, ensuring no files are overwritten and all exported files remain accessible.

File metadata including name, MIME type, file size, hash, and timestamps are exposed and can be passed to downstream agents like bel-open-file or bel-show-crm-file for preview or further analysis.

The Skill is designed to retrieve individual files by file_id; for batch operations, you would iterate over multiple file IDs or use junction tables to identify all files linked to a record type before exporting each.