
Announcements
Hi,
We are developing a canvas app where a user will upload one or more files as attachments. As part of the organization security policy, these documents cannot be saved in any cloud platform like Dataverse, SP Online, OneDrive, Azure Blob storage etc.
Considering an on-premise platform to store the documents, we have few options available:
1) One internal system which exposes Rest APIs to upload and download document. This option is the recommended by the organization. The upload API requires base64 of the document along with other attributes. The download API will return the base64 of the same document.
2) Store documents in SQL Server where the file content is stored in a varbinary column.
3) Store documents in local File Share.
We are not able to figure out how to display the documents in the canvas app using any of the above options in a way that user can view/download these files.
Kindly note that we use can upload different type of files; Excel, PDF, images, Docx, etc.
Furthermore, we will try to avoid Azure Function or any other Azure service due to few security & operational related matters. However, if it is inevitable then we discuss it.
Let me know in case any further clarification/information is required. An urgent response will be highly appreciated.
Thanks