Small and medium business | Business Central, N...

how to update attachment with new ID

(5) Share

Report

Posted on by Ahsan baig 123

155

Hi,

I’m updating the ID on the custom page header. When the ID is successfully updated, the sub-link remains intact because the "ID" is automatically updated as well. However, this does not happen with attachments. When the ID is changed, the attached files are removed from the page. When I revert the ID to its previous value, the attachment reappears, because the "ID" isn't being updated in the "Document Attached table".

Question: How can I update the ID on the header page without causing the attachments to be removed?

Thanks.

after update

Categories:

Dynamics 365 Business Central

Microsoft Dynamics NAV

Dynamics 365 Business Central migration

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Jainam M. Kothari 15,641 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!
Hello,

To update the ID on the header page without causing the attachments to be removed in Business Central, you need to ensure that the ID is also updated in the "Document Attached" table. Here are the steps you can follow:

Retrieve the current attachments: Before updating the ID, retrieve the current attachments associated with the old ID.

Update the ID in the "Document Attached" table: After updating the ID on the header page, update the ID in the "Document Attached" table to match the new ID.

Reattach the documents: If necessary, reattach the documents to the new ID.

You can use the Business Central API to update the document attachments. Here is an example of how to update the document attachment object:

PATCH https://{businesscentralPrefix}/api/v2.0/companies({companyId})/documentAttachments({attachmentId}) Content-type: application/json { "id": "{newId}", "fileName": "{fileName}", "attachmentContent": "{attachmentContent}" }

Make sure to replace {businesscentralPrefix}, {companyId}, {attachmentId}, {newId}, {fileName}, and {attachmentContent} with the appropriate values.

This approach ensures that the attachments remain linked to the updated ID and are not removed from the page.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,396 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

Dynamics 365 Business Central: How to change attachment name in Document Attachment Details (1173, List) – Rename attachment | Dynamics 365 Lab

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,537 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

You need to update the code to include the new attachment ID and Modify the ID Update Logic:
You can modify the logic where the ID update occurs, so that it first updates the attachment records before updating the header ID

begin
// First, update the Document Attached table
if DocumentAttachedRec.Get(OldID) then begin
DocumentAttachedRec."Header ID" := NewID; // Update the ID in the Document Attached table
DocumentAttachedRec.Modify();
end;

// Then, update the header ID
HeaderRec."ID" := NewID;
HeaderRec.Modify();

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 96,039 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

In short, you need to rename the primary key of table 1173 "Document Attachment" in the rename trigger of your new table.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,251 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

The document attachments are linked based on the record values, so it stores the record primary key values in the table to link it, if you update ID which looks you are renaming the primary key or one of the key values which is specified in the document attachment in that case you need to access Document Attachment and update that.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 21,048 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

If this helps :https://learn.microsoft.com/en-in/answers/questions/1864420/how-do-you-rename-an-attachment-using-workflow-des

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/file/file-rename-method

Was this reply helpful? Yes No
Vahid Ghafarpour 12,204 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

Thanks for being an active part of the Dynamics 365 Community!

Was this reply helpful? Yes No