steps to have excel talk to Graph API


Here are the steps to talk to the AAD graph API using excel 2013 and power query. The steps are similar to those used when talking to the supported odata feed of the CRM Online service. A workaround is given that makes excel talk to the graphAPI.

 

1. open an excel workbook and activate the power query ribbon. Select an odata feed:

image

 

2. Supply the Graph API URI

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

in my case the value is

https://graph.windows.net/rapmlsqa.com/users?api-version=2013-04-05

image

 

3. Focus on users

you must select the user form of the URI (and the organizational id option)

image

 

4. Sign in and STAY SIGNED IN

image

image

 

4.save the credential set

image

choosing the users option, and “save”.

 

One then sees what feels like a bug – where upon one must save again. Note a specific workaround is required. You MUST save again, now as anonymous.

image

 

the net result is a query resolution:

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.