OData Update Operations in D365Ax7

(0) Share

Report

Posted on by Community Member

Hi friends,

How to update the D365 AX7 customer form using Odata service(integration).

I have created the new records in customer form using odata like:

string CustomerNumber = "THMF-000013";
Customer customer = new Customer();
DataServiceCollection<Customer> CustomerCollection = new DataServiceCollection<Customer>(Context);
CustomerCollection.Add(customer);
customer.CustomerAccount = CustomerNumber;
customer.Name = "Antony";
customer.CustomerGroupId = "10";
customer.SalesCurrencyCode = "THB";
customer.DataAreaId = "THMF";
customer.AddressCountryRegionId = "AFG";
Context.SaveChanges(SaveChangesOptions.PostOnlySetProperties | SaveChangesOptions.BatchWithSingleChangeset);

Please give a suggestion.

Thanks & regards,

Ashwini

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Martin Dráb 239,118 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Your code is creating a new customer, not updating an existing one. If you want to update a customer, first find it (e.g. var cust = context.Customers.Where(c => c.CustomerAccount == "THMF-000013")), change its properties and call SaveChanges().

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

Thanks for your response.

when i used this code ,

string Company = customer.DataAreaId;
customer.Name = "kim";
var assetMajorTypeAfterUpdate = Context.Customers.Where(x => x.CustomerAccount == "THMF-000013" && x.DataAreaId == Company).First();
Context.UpdateObject(customer);
Context.SaveChanges();
Console.WriteLine("Asset Major type of ID {0} successfully updated.", assetMajorTypeAfterUpdate.CustomerAccount);

I am getting this type of error,

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

Like (0)

Report
Copy link

Link copied!

No, you didn't get it. You save the customer to assetMajorTypeAfterUpdate variable, but then you're ignoring it and you're still working with the customer variable.

Regarding the exception, test the simpler case without the condition for DataAreaId.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi martin,

I used this piece of code,

" var cust = Context.Customers.Where(c => c.CustomerAccount == "THMF-000013" ).FirstOrDefault();

Context.UpdateObject(cust);

Context.SaveChanges();"

I am getting error like:

"An unhandled exception of type 'System.InvalidOperationException' occurred in System.Core.dll Additional information: Sequence contains no elements"

I am not getting the values from customer account its shown as null.

Thanks & regards,

Ashwini

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

Like (0)

Report
Copy link

Link copied!

If you mean that cust is null, trying to update it obviously can't work. You miss a condition checking whether the customer was successfully found.

Was this reply helpful? Yes No