Kusaka here! I often write blogs about system cooperation.
Previously, in the article How to Output Files from Cloud-based Workflow Questetra to OneDrive, the procedure for registering an application with Office 365 when using an API for OAuth was explained. The procedure has been changed due to a specification change in Office 365, so I will summarize the change in this article. In short, it has changed to register with Azure Active Directory (Azure AD).
(That’s the story I heard at the study meeting of the Japan Office 365 Users Group that I attended before the change in the summer of 2019).
※ Please refer to the following articles for the sections unrelated to application registration:
Settings when Calling the REST API of Another Service from Questetra (Questetra to be OAuth2 client)
How to Output Files From Cloud-based Workflow Questetra to OneDrive
1: Office 365 application registration procedure
Organize what you do first.・ Set the Questetra callback URL when registering the application
・ Obtain the client ID and client secret obtained by app registration
Access Azure AD, select “App registrations” from the left menu, and click “New registration” on the screen.
Enter the “Name” (with any name you like) and “Redirect URI” of the application to register and click “Register”.
Set the Redirect URI to the Questetra callback URL. For details on the callback URL, refer to the “2: Preparation on the side of partner service to be invoked” section in Settings when Calling the REST API of Another Service from Questetra (Questetra to be OAuth2 client).
Make a note of the “Application (client) ID” displayed.
Select “Certificates and secrets” from the left menu and click “New client secret”.
Enter the Client Secret “Description” (with a description that the relevant person knows) and “Expiration Date” (for the purpose of this example) and click “Add”.
As the client secret is displayed, make a note of the value.
Now you have what you need (client ID and client secret).
Enter each of them according to the “2.2: OAuth setting on the Questetra side” section in How to Output Files From Cloud-based Workflow Questetra to OneDrive to get a token. If the token can be acquired, it has worked.
Once you get used to it, I think it’s not difficult, but you can become lost if you don’t understand because there are various configurations. I’m glad if you can use this as a reference.
* In the next article we will explain the settings to link up with Excel Online. Stay tuned.
If you have any questions, please feel free to contact us.