Fetch OSTicket Attachments from External System

abrophy

We have a FileMaker database solution that we'd like to pull OS Ticket info into. I have access to the OSTicket database from FileMaker and can easily pull table data, but I am stuck on how I might fetch file system attachments.

I can identify the file_id's for the attachments I'd like to fetch but not sure how I might download those files using an external system like our FileMaker solution. Any ideas on the best method to grab these files using an external system?

abrophy

Answering my own question here...

Now that I understand how the files are stored on the file system, I've decided to CURL them via SFTP.

What I didn't get at first is the the key column in the ost_file is the actual file name as renamed by OSTicket upon upload and storage in the attachments folder. Using the original file name and file type as stored in the database, I'm able to pass my CURL function the calculated attachment file path, the name I want for the file, and the file type.