excel visualization of odata source, supported by AAD websso


Using our sharepoint license associated with an office 365 plan, we created a site (bi, for business intelligence) and on that site a list (a business intelligence list of 3 text records):

 

image

https://netmagic.sharepoint.com/bi/_layouts/15/start.aspx#/Lists/bilist/AllItems.aspx

https://netmagic.sharepoint.com/bi/

https://netmagic.sharepoint.com/bi/_vti_bin/ListData.svc

we want to now talk to this list of records using odata. So we launch excel and powerquery:

 

image

image

we note the opportunity to use the websso login:

 

image

image

Selecting the odata service URI ,we get an enumeration of entity sets, including our bilist

image

image

 

We get back a record set, after querying:

image

image

 

lets refresh the query, having activated fiddler to spy on the  wire:

image

image

image

 

in terms of authentication, we see that the odata queries are supported by cookies. That is one does signin using the powerquery tool (using oauth, and ws-federation), in order to get a pretty classical WIF session cookie (fedauth):

image

image

Above, we see the sharepoint users (linked up to AAD managed users)

Advertisements

About home_pw@msn.com

Computer Programmer who often does network administration with focus on security servers. Very strong in Microsoft Azure cloud!
This entry was posted in odata. Bookmark the permalink.