Calculate distance from post codes

edo906

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

txeriff

you just forgot to ask "how do I become an astronaut, can anyone tell me what I have to do?".

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);