Finance | Project Operations, Human Resources, ...

Unanswered

"An error has occurred. Write failed for table row of type 'XXEntity'. Infolog: Warning: The value '10646' in field 'Vendor account' is not found in the related table 'Vendors'.; Warning: validateField failed on field

(0) Share

Report

Posted on by VidyaS

Hello Team ,

I have created a Logic App to send data from a Excel file in SharePoint Online to D365FO Custom Entity.

3513.pastedimage1609162520856v1.png

6683.pastedimage1609162580274v2.png

4401.pastedimage1609162704957v3.png

when I run the LogicApp I observe that the values from SharePoint Online Excel is retrieved and as per mapping values are not being stored into D365FO instead it errors out as BadRequest.

{
"status": 400,
"message": "An error has occurred. Write failed for table row of type 'XX'. Infolog: Warning: The value '10646' in field 'Vendor account' is not found in the related table 'Vendors'.; Warning: validateField failed on field 'XX.VendorAccount'.\r\nclientRequestId: aa122e58-621b-477d-85a8-6c46fd9afa19",
"error": {
"message": "An error has occurred. Write failed for table row of type 'XX'. Infolog: Warning: The value '10646' in field 'Vendor account' is not found in the related table 'Vendors'.; Warning: validateField failed on field 'XX.VendorAccount'."
},
"source": "XXXXXXX.sandbox.operations.dynamics.com",
"errors": []
}

Could someone let me know what could be the reason .

I have the same question (0)

All responses (3)

Answers (0)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Vidya,

This means that the value '10646' is not present in the table for Vendors. What data is being written using this custom entity?

Was this reply helpful? Yes No
Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report
Also, make sure you're writing data to the right company.

By the way, let me repost your JSON code, to make it easier to read. Next time, please use Insert > Insert Code to paste code.

{ "status": 400, "message": "An error has occurred. Write failed for table row of type 'XX'. Infolog: Warning: The value '10646' in field 'Vendor account' is not found in the related table 'Vendors'.; Warning: validateField failed on field 'XX.VendorAccount'.\r\nclientRequestId: aa122e58-621b-477d-85a8-6c46fd9afa19", "error": { "message": "An error has occurred. Write failed for table row of type 'XX'. Infolog: Warning: The value '10646' in field 'Vendor account' is not found in the related table 'Vendors'.; Warning: validateField failed on field 'XX.VendorAccount'." }, "source": "XXXXXXX.sandbox.operations.dynamics.com", "errors": [] }

I also moved your question from the AX forum to the Dynamics 365 Finance forum.

Was this reply helpful? Yes No
zhifeng on at

Like (0)

Report

Validation failed because vendor '10646' doesn't exist.

Was this reply helpful? Yes No

Join the conversation

Community site session details

"An error has occurred. Write failed for table row of type 'XXEntity'. Infolog: Warning: The value '10646' in field 'Vendor account' is not found in the related table 'Vendors'.; Warning: validateField failed on field

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

"An error has occurred. Write failed for table row of type 'XXEntity'. Infolog: Warning: The value '10646' in field 'Vendor account' is not found in the related table 'Vendors'.; Warning: validateField failed on field

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 > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates