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?
Answer
Can we get the actual location of a file(such as an attachment) stored in Acumatica?
Best answer by aaghaei
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.
+3In 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.
https://acupowererp.com
+10Join 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.
Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.