Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Calculate distance from post codes
edo906
Member Posts: 7
Hi,
I need to know how to calculate a distance between two postal codes (location table and sales shipment header-ShiptoCity) and know the distance and put it in a field of a custom table. How can I do? In case if I were to use a webservice, how do I implement it on nav?
For nav 2018
Thanks so much
I need to know how to calculate a distance between two postal codes (location table and sales shipment header-ShiptoCity) and know the distance and put it in a field of a custom table. How can I do? In case if I were to use a webservice, how do I implement it on nav?
For nav 2018
Thanks so much
0
Answers
First, yes you will need to locate a WS for this, google a bit:
https://gis.stackexchange.com/questions/15199/looking-for-free-web-service-that-calculates-driving-distance-between-2-addresse/296403
https://developers.google.com/maps/documentation/distance-matrix/overview
I suggest you download postman:
https://www.postman.com/
you will need it to figure out WS calls and make it work.
Once you have this, you "translate this to NAV".
There are several ways to do WS calls to NAV, depending on the version (winhttps, AL...)
"basic" winhttp example
IF ISCLEAR(WinHTTP) THEN CREATE(WinHTTP,TRUE,TRUE); WinHTTP.Open('POST',T50161."PayPal URL"+'oauth2/token', FALSE); WinHTTP.SetRequestHeader('Accept', 'application/json'); WinHTTP.SetRequestHeader('Accept-Language', 'en_US'); WinHTTP.SetRequestHeader('Content-Type', 'application/x-www-form-urlencoded'); WinHTTP.SetRequestHeader('Authorization', STRSUBSTNO('Basic %1', T50161."Base64 Client and Secret")); WinHTTP.Send('grant_type=client_credentials'); vInStream := WinHTTP.ResponseStream; REPEAT vInStream.READTEXT(vtext); vBigT.ADDTEXT(vtext); UNTIL (vInStream.EOS);