Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Recurring integration. Error during import invoice with 2 attachments via V2 attachment entity.

(1) ShareShare
ReportReport
Posted on by 65
Hello,
Let me explain, please.

In the attached file is my package with V2 attachment that I send to D365 endpoint "<tenant>/api/connector/enqueue/{recurringJobId}?"

Of course, on D365 side there is appropriate job with three entities: headers, lines and attachments V2.
 
 
In that package I send image and file V2 attachments and I see an error in the queue:
Failed to insert record into staging table. The keys of the record are DEFINITIONGROUP, EXECUTIONID, HEADERREFERENCE, PARTITION. Duplicate records must be removed from the file prior to import.
<?xml version="1.0"?><Errors><Error><ErrorCode>-1071636471</ErrorCode><SubComponent>OLE DB Destination [67]</SubComponent><Description>SSIS Error Code DTS_E_OLEDBERROR. 
 An OLE DB error has occurred. Error code: 0x80004005....
 
Seems that D365 thinks that my attachments are the same. But why?
Interesting, that if I use old entity VENDORINVOICEDOCUMENTATTACHMENTENTITY with the same package content, except DOCUMENTID field that should be only in V1 attachments - I don't have any errors and both attachments are imported successfully.
May be I should add some additional field in V2 attachment XML?
 
 
 
Categories:
  • Andrei Profile Picture
    Andrei 65 on at
    Recurring integration. Error during import invoice with 2 attachments via V2 attachment entity.
    Thank you, André.
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,409 Super User 2024 Season 2 on at
    Recurring integration. Error during import invoice with 2 attachments via V2 attachment entity.
    Hi Andrei,
     
    For this moment, I would recommend using the V1 version if this one is working. It is not only about having an additional field but also the contents of the entity key. For the missing option to import multiple attachments, you can contact Microsoft Support. They can tell you if this is considered as regression or part of a new design.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,409 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,483 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans