Microsoft Dynamics NAV (Archived)

Odata Post with composite key (Vendor Bank Account)

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (3)

Answers (0)

sami khan 45 on at

Like (0)

Report

RE: Odata Post with composite key (Vendor Bank Account)

did you solved this issue?
Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: Odata Post with composite key (Vendor Bank Account)

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

Rabin 2,976 on at

Like (0)

Report

RE: Odata Post with composite key (Vendor Bank Account)

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.