Filter patient records with attachments

  • 2
  • Question
  • Updated 2 years ago
  • Answered
I want to be able to retrieve all attachments for a subset of our patient list based on some criteria.  There may also be other queries I need to make based on patient records and attached files.

Is there a way to do this through the Frontdesk UI?

Alternatively, is there an API I can use?  If so, I would to write a python program to access this info.
Photo of David Fyfe

David Fyfe

  • 1 Post
  • 0 Reply Likes

Posted 2 years ago

  • 2
Photo of Andrew

Andrew, Community Manager

  • 386 Posts
  • 117 Reply Likes
Hi David,

Welcome to the Smartsoft Community. 

We are happy to provide read-only access to the Microsoft SQL database for the purpose of user developed reporting. Please note that the attachment and clinical notes data is encrypted for security reasons, however this can be decrypted by us should you intend to export the data for import into other software.

For further assistance could we please have the business owner open a support case on our website: