Document Attachment

(0) Share

Report

Posted on by Nick Webb

891

I'm trying to add a Document Attachment record via an OData Connected Service to a Microsoft Dynamics NAV database in C# (Visual Studio Professional 2017), (see code below):-

string lstrFileName = @"C:\Users\user.name\Documents\PDF\BCTest\Test Attachment 3.pdf";
System.IO.FileInfo lfi = new System.IO.FileInfo(lstrFileName);
NAV.API_Document_Attachment lobjDA = NAV.API_Document_Attachment.CreateAPI_Document_Attachment(5900, "SO000006", "Order", 0, 1);
lobjDA.AttachedDate = DateTime.Now;
lobjDA.FileName = lfi.Name;
lobjDA.FileExtension = lfi.Extension.Replace(".", string.Empty);
lobjDA.FileType = "2";
objContext.AddToAPI_Document_Attachment(lobjDA);
objContext.SaveChanges();
… but when it gets to SaveChanges, I get: "{"error":{"code":"Application_DialogException","message":"Please attach a document first."}}"

How do I programmatically attach a document?

I have the same question (0)

All responses (6)

Answers (0)

Community Member on at

Like (0)

Report

Do you know which NAV object you called ?

Was this reply helpful? Yes No
Nick Webb 891 on at

Like (0)

Report

So, I created an API Page in an AL Extension with SourceTable = "Document Attachment". I then deployed the extension, wrapped a Web Service round it, downloaded the metadata into a Connected Service in Visual Studio and tried to run the code above. Is that enough info?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

There is a field Document Reference ID in table Document Attachment. You need to stream the file to that field first before you can insert record to document attachment

Was this reply helpful? Yes No
Nick Webb 891 on at

Like (0)

Report

Interesting. Thanks for the tip. So I've included the Document Reference ID column in the API Page and re-ingested the metadata and it sees this column as a Media type property / field in C#. So, do you have any sample code of streaming the file to a field of this type?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I don't have in C#. I use Power Automate to attached the document to BC API.

You should convert it into base64 then assign the value to the field

Was this reply helpful? Yes No
Nick Webb 891 on at

Like (0)

Report

My code now is:-

string lstrFileName = @"C:\somefolder\filetoattach.pdf";

System.IO.FileInfo lfi = new System.IO.FileInfo(lstrFileName);

NAV.API_Document_Attachment lobjDA = NAV.API_Document_Attachment.CreateAPI_Document_Attachment(5900, "SO000006", "Order", 0, 1);

lobjDA.AttachedDate = DateTime.Now;

lobjDA.FileName = lfi.Name;

lobjDA.FileExtension = lfi.Extension.Replace(".", string.Empty);

lobjDA.FileType = "2";

FileStream lobjFS = new FileStream(lstrFileName, FileMode.Open);

byte[] larrFileBytes = null;

using (var ms = new MemoryStream())

{

lobjFS.CopyTo(ms);

larrFileBytes = ms.ToArray();

System.Guid lobjGuid = System.Guid.NewGuid();

lobjDA.DocumentReferenceID = NAV.Media.CreateMedia(lobjGuid);

// lobjDA.DocumentReferenceID.Content = ms;

}

gobjDSC_Bell.AddToAPI_Document_Attachment(lobjDA);

gobjDSC_Bell.SaveChanges();

The bit I think I'm now missing is, how to populate the Content property (type: Microsoft.OData.Client.DataServiceStreamLink) of the DocumentReferenceID (type: NAV.Media)

I'm still getting error: 'Please attach a document first.' at SaveChanges.

Any help / sample source code would be appreciated?

Was this reply helpful? Yes No

Join the conversation

Community site session details

Document Attachment

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Document Attachment

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates