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

Unanswered

c# Business Central How to Attach Documents Oauth. Error : The record in table Unlinked Attachment already exists. Identification fields and values: Id='{00000000-0000-0000-0000-000000000000}

(0) Share

Report

Posted on by Dynamics Questions

130

Hi,

For creating sales orders attachment I used following request

https://api.businesscentral.dynamics.com/v2.0/<tenantID>/uat/api/v1.0/companies(companyID)/attachments

Body:

{ “parentId”: “5a086bc7-195f-eb11-89f9-0022481ab2d5”, “fileName”: “Example.pdf”}

At first time it worked and generated Id for attachment, but my PATCH request was failed

PATCH businesscentralPrefix/companies({companyId})/attachments(parentId={parentId},id={attachmentId})/content

I tried to do first request again as I did not saved parentId and now it throws such error : "{\"error\":{\"code\":\"Internal_EntityWithSameKeyExists\",\"message\":\"The record in table Unlinked Attachment already exists. Identification fields and values: Id='{00000000-0000-0000-0000-000000000000}' CorrelationId: e6964edd-e341-4da2-804d-534c1ea681e3.\"}}"

How can I fix it ? As I understand parentId that was generated previously must be utilized but how ?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Sort by

s.sheikh 20 on at

Like
a
(1)

Report
Copy link

Link copied!
[quote user="Dynamics Questions"]
Hi,

For creating sales orders attachment I used following request

https://api.businesscentral.dynamics.com/v2.0/<tenantID>/uat/api/v1.0/companies(companyID)/attachments

Body:

{ “parentId”: “5a086bc7-195f-eb11-89f9-0022481ab2d5”, “fileName”: “Example.pdf”}

At first time it worked and generated Id for attachment, but my PATCH request was failed

PATCH businesscentralPrefix/companies({companyId})/attachments(parentId={parentId},id={attachmentId})/content

I tried to do first request again as I did not saved parentId and now it throws such error : "{\"error\":{\"code\":\"Internal_EntityWithSameKeyExists\",\"message\":\"The record in table Unlinked Attachment already exists. Identification fields and values: Id='{00000000-0000-0000-0000-000000000000}' CorrelationId: e6964edd-e341-4da2-804d-534c1ea681e3.\"}}"

How can I fix it ? As I understand parentId that was generated previously must be utilized but how ?
[/quote]

From what I know,

To fix this issue, you must utilize the parent Id that was generated previously.

To do this, follow these steps:

Retrieve the parent Id from the first successful attachment creation.

Use that parent Id in the PATCH request instead of creating a new one.

Ensure that the parent Id, company Id, and attachment Id values in the PATCH request are correct and correspond to the existing attachment.

check if there is any issue with the request header or body you are sending for patch request.

Verify that the user has the necessary permissions to update the attachment.

By following these steps, you should be able to update the attachment successfully without encountering the same error message.

Was this reply helpful? Yes No
Dynamics Questions 130 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Thank you for the quick response

How to perform the first step - Retrieve the parent Id from the first successful attachment creation. ?

What request should be used for this ?

Was this reply helpful? Yes No
Dynamics Questions 130 on at

Like
a
(0)

Report
Copy link

Link copied!

s.sheikh

Please provide a reference for guide or code samples

How to form request for the first step ?

Was this reply helpful? Yes No

Join the conversation

Community site session details

c# Business Central How to Attach Documents Oauth. Error : The record in table Unlinked Attachment already exists. Identification fields and values: Id='{00000000-0000-0000-0000-000000000000}

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

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

Featured topics

Product updates

Community site session details

c# Business Central How to Attach Documents Oauth. Error : The record in table Unlinked Attachment already exists. Identification fields and values: Id='{00000000-0000-0000-0000-000000000000}

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

Subscribe to this forum!

Select categories

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

Featured topics

Product updates