excel consuming Microsoft Graph API, with JWT


We were able to use the power query add in to Excel 2013 to interact with the graph API of AAD:

 

http://msdn.microsoft.com/en-us/library/azure/jj126255.aspx

 

image

https://graph.windows.net/netmagic.onmicrosoft.com/Users?api-version=2013-04-05

We had several issues, however, with the organizational id flow. I’m not quite sure how I got around some bugs, but I evidently did:

 

image

image

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.