Microsoft Dynamics NAV (Archived)

Odata Post with composite key (Vendor Bank Account)

(0) Share

Report

Posted on by Community Member

I'm trying to create a Vendor Bank Account record with Odata (Nav 2017).

GET and PATCH methods work on the endpoint but POST always fails.

The json payload to the server is

{
'Vendor_No': 'V1000',
'Code': '1',
'Name': 'Test Bank',

}

The response I get from the server is:

"The Vendor Bank Account already exists. Identification fields and values: Vendor No.='',Code='1'"

Either there's a bug that drops the valid Vendor No. or because it's a foreign key and part of the composite key I need to do something different to get POST to work.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Rabin 2,976 on at

Like (0)

Report
Copy link

Link copied!

Hi Brett,

I think the data with the information you have mentioned got created the first time and then after that you are trying to run the same code which is trying to insert the same data which is generating the error.

I would change the Key values and try again. Since you are inserting hard code values, you might have to change the value everytime you run the code.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,280 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Check the label value for the Vendor No in your Json Request. Try to retrieve and compare it with the request you are sending

Was this reply helpful? Yes No
sami khan 45 on at

Like (0)

Report
Copy link

Link copied!

did you solved this issue?

Was this reply helpful? Yes No