Add a location field in Sales Order Entity (NAV 2018 API)

(0) Share

Report

Posted on by Community Member

Hi Expert,

currently we are looking to integrate an e-commerce platform with Dynamics NAV 2018 via API and now we found an issue.

In my case, there are a requirement that Location Code in Sales order (NAV) can be defined by end consument from E-commerce website.

somehow, in default API for sales order (TAB 5495 - Sales Order Entity Buffer) dont have field Location Code.

I already tried to explore and add manually Location Code field, but somehow when we test it using POSTMAN, the GET function can retrieve the Location Code Value from sales header, but when we try the POST function, the value are not copied to NAV.

is there anyway to find a workaround/solution for this case?

*This post is locked for comments

All responses (7)

Answers (1)

Sort by

Suggested answer

Andrey Baludin 3,943 on at

Like (0)

Report
Copy link

Link copied!

Hi!
NAV takes location code for Sales orders from Customer card. So you can pass different customer numbers which has different location values on NAV side.
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Andrey,

in my case, there are a flexibility for end consumer to choose if they want to pick their own order to offline store. thats why we can't set the location code in customer card because there is a possibility that in the next order, the location can be different from the first order.

have you done something similar? modify the existing API buffer entity table?
Suggested answer

Andrey Baludin 3,943 on at

Like (0)

Report
Copy link

Link copied!

As I see - Sales Order Entity page based not on Sales Header table:

And on Graph Management it transfers fields to Sales Header.

Problem is that Sales Order Entity Buffer doesn't contain Location code field.

So If I were you - i'll try to add to Sales Order Entity Buffer table Location code field with the same number (28) as in the Sales header table. And after that add it to Sales Order Entity page (5495). It should works. (You can easily do it even with extensions).

Yes, i've made some jobs with NAV2018 API's:

https://community.dynamics.com/nav/b/andreysnavblog/archive/2018/03/19/how-to-get-picture-from-mediaset-through-standard-apis

community.dynamics.com/.../how-to-obtain-data-from-nav-standard-apis
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Andrey,

already tried in our local server before.

it working well when i try to get data using postman

however it doesnt work when i try to POST via postman

is there something i miss?
Verified answer

Andrey Baludin 3,943 on at

Like (0)

Report
Copy link

Link copied!

Looks like Location from Customer rewrite your Location code. Try to clear location code in customer card and post again.
Community Member on at

Like (1)

Report
Copy link

Link copied!

its working.

Thanks for the idea.
Ghetz 3,029 on at

Like (0)

Report
Copy link

Link copied!

@StevenL ,I'm working on a similar project. May I ask, how you are planning to call the web services after you finish testing with postman? Any .NET library, JS? have you been able to practically work with this OData services?