This bundle contains functions to help generate OAuth tokens for your application's users.
To use these Choreos with Power BI, follow the instructions found here to register your Power BI application and retrieve your Client ID and Client Secret.
To use these Choreos with Excel, follow the instructions found here to register your Office 365 application and retrieve your Client ID and Client Secret.
Run the Microsoft > OAuth > InitializeOAuth Choreo, specifying the Client ID from the app you registered at Microsoft. When using the PowerBI Choreos, you'll want to specify the following value for the Resource input:
When using the Excel Choreos, you can leave the Resource input empty, but you'll need to specify the following Scope:
Open a new browser tab and visit the Authorization URL returned by the InitializeOAuth Choreo. When prompted, log in to your Microsoft account and grant access. You will redirect to the Redirect URI specified during the registration process.
At this point, you'll be able to use your Client ID, Client Secret, Username, and Password to access a Microsoft account via the API.
Note: if you are building an application that needs to access Microsoft accounts for multiple users, you'll need to pass the Access Token returned by the FinalizeOAuth Choreo to authenticate your application's users. You can use the Refresh Token with the Microsoft > OAuth > RefreshToken Choreo when an Access Token expires.