using excel powerquery to talk to CRM odata service (with sso/oauth, etc)


 

 

image

image

one sees a sensible Fiddler trace.

image

image

 

one sees the final phases of the oauth2 handshake with an AS augmented with the ability to do websso with an IDP. One sees several calls to the services of the odata source, each of each of which have an authorization header in the HTTP request, populated with the access token obtained form the oauth2 handshakes.

 

I think Ive also learned the right mental model, for the credentials (and stored tokens) associated with any given data source. One can regenerate the access tokens, per source.

 

image

 

in our trial, we simply signed in as a different Netmagic user – i.e. different CRM netmagic-linked user.

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.