Forum Discussion

James Jackson's avatar
James Jackson
Icon for Microsoft rankMicrosoft
Nov 09, 2018

Add Location Details to SharePoint Data and Content

We are excited to announce a new capability for SharePoint lists and libraries. The new location column allows you to add rich location data from Bing Maps or your organization directory to any Share...
Document Library
Lists
SharePoint Online
Ariel Kropp's avatar
Ariel Kropp
Copper Contributor
Nov 16, 2018

How will this look from a REST perspective?

e.g. what will the data look like if pulled into power BI? lat and long?

Koen Zomers's avatar
Koen Zomers
Copper Contributor
Nov 26, 2018

Just use the _api/web/lists/getbytitle('yourlist')/items URL to see the RAW data behind this field. For i.e. a field in which I entered the Microsoft HQ in Redmond, WA, it stores internally:

 

<d:Location>{"EntityType":"LocalBusiness","LocationSource":"Bing","LocationUri":"https://www.bingapis.com/api/v6/localbusinesses/YN873x16209519703153017334","UniqueId":"https://www.bingapis.com/api/v6/localbusinesses/YN873x16209519703153017334","DisplayName":"Microsoft Corporation","Address":{"Street":"1 Microsoft Way","City":"Redmond","State":"WA","CountryOrRegion":"US","PostalCode":"98052"},"Coordinates":{"Latitude":47.6398811340332,"Longitude":-122.12833404541016}}</d:Location>

 

Resources