I want to load a file in Acumatica into Nuget package object(It expects file location). If we consider a file such as attachment in SOLine, how can I get actual location of that file?
Best answer by aaghaei
View originalCan we get the actual location of a file(such as an attachment) stored in Acumatica?
Userlevel 5
+3
In Acumatica out of the box there are four possible locations:
- Within Acumatica database. Table UploadFile, columns FileName and NoteID
- Local file folder.
- Azure Blog Storage
- Amazon S3 Storage
As of 2, 3, 4 I don’t know on the top of my head, connection between SOLine, and location in Local file folder or in Azure, Amazon, but can try to find out.
Userlevel 7
+9
Join the SOLine.NoteID with NoteDoc and NoteDoc FileID with UploadFile and as Yuriy pointed out the name stores the file name. UploadFileRevision table stores the files data/content.
Acumatica in UploadFileInq has a GetFile() method that can retrieve any given single file for you by their guid.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.