Using the Google Distance Matrix API within a SharePoint List to calculate distances?

%3CLINGO-SUB%20id%3D%22lingo-sub-2676292%22%20slang%3D%22en-US%22%3EUsing%20the%20Google%20Distance%20Matrix%20API%20within%20a%20SharePoint%20List%20to%20calculate%20distances%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2676292%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20anyone%20know%20if%20it%20is%20possible%20to%20use%20the%20Google%20Distance%20Matrix%20API%26nbsp%3Bwithin%20a%20SharePoint%20(Online)%20List%20to%20calculate%20distances%3F%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3CU%3E%3CSTRONG%3EScenario%20I%20would%20like%20to%20build%20out%3A%3C%2FSTRONG%3E%3C%2FU%3E%3CBR%20%2F%3EI%20have%20a%20large%20list%20(2000%2B)%20of%20individuals%20that%20can%20reside%20literally%20anywhere%20in%20the%20US%2C%20and%20I%20often%20need%20to%20reference%20their%20distance%20in%20relation%20to%20specific%20areas%20(Note%3A%20These%20areas%20are%20always%20changing%20so%20it's%20not%20as%20simple%20as%20creating%20a%20database.).%20I%20would%20like%20to%20be%20able%20to%20input%20a%20destination%20that%20would%20then%20reference%20a%20column%20in%20a%20SharePoint%20list%20and%20calculate%20those%20distances%20in%20another%20column.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EUsing%20Javascript%2C%20I%20am%20familiar%20with%20how%20to%20implement%20this%20on%20a%20case-by-case%20basis%2C%20or%20even%20as%20a%20batch%20method%20inside%20of%20Excel%20using%20VBA%2C%20however%2C%20I'm%20looking%20to%20simplify%20the%20process%20further.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3CU%3E%3CSTRONG%3EMy%20Ideal%20Solution%3A%3C%2FSTRONG%3E%3C%2FU%3E%3CBR%20%2F%3EA%20SharePoint%20WebPart%20based%20on%20Javascript%20that%20I%20could%20input%20a%20destination%2C%20perhaps%20other%20criteria%20to%20narrow%20results%20of%20those%20in%20this%20list%2C%20which%20would%20when%20submitted%2C%20open%20the%20list%20with%20results%20pertaining%20to%20the%20search%20criteria.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20insights%20are%20greatly%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2676292%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

Does anyone know if it is possible to use the Google Distance Matrix API within a SharePoint (Online) List to calculate distances? 

Scenario I would like to build out:
I have a large list (2000+) of individuals that can reside literally anywhere in the US, and I often need to reference their distance in relation to specific areas (Note: These areas are always changing so it's not as simple as creating a database.). I would like to be able to input a destination that would then reference a column in a SharePoint list and calculate those distances in another column. 

Using Javascript, I am familiar with how to implement this on a case-by-case basis, or even as a batch method inside of Excel using VBA, however, I'm looking to simplify the process further. 

My Ideal Solution:
A SharePoint WebPart based on Javascript that I could input a destination, perhaps other criteria to narrow results of those in this list, which would when submitted, open the list with results pertaining to the search criteria.

Any insights are greatly appreciated!

0 Replies