Introduction:
It is possible to integrate Office 365 with HACP EE. Microsoft Graph APIs allow HACP EE to connect with the files across Microsoft 365.
Initially, the user must register the application in Azure Active Directory (Azure AD). After successful registration, users must sign-in with their Microsoft 365 account in HACP EE. Then, using OAuth, the user retrieves an access token for the application. With this access token, Microsoft Graph APIs can be called and retrieve data from Microsoft 365 for the user.
Steps to Register the Application in Azure Active Directory:
- Open the web browser, go to the Azure portal.
- In the menu, select Azure Active Directory
3. Click
App registrations.
4. Click
New registration to create a new app registration.
5. Provide the application name in the
Name field.
6. Under
Supported account types, select
Accounts in any organizational directory (Any Azure AD directory - Multitenant) and personal Microsoft accounts (e.g., Skype, Xbox).
Note: Both admin and their clients can access it.
7. Under Redirect URI (optional), select Single-page application (SPA) from the drop-down list and enter http://localhost:9080 in the value field.
8. Click
Register.
9. After the application is successfully registered, Copy the
Application (client) ID.
10. Now, save the values (client ID & Redirect URI) in
web.xml under web-content in the HACP EE application.
<context-param>
<param-name>clientid</param-name>
<param-value> xxxx-xxxx-xxxxx </param-value>
</context-param>
<context-param>
<param-name>officeredirecturi</param-name>
<param-value> http://localhost:9080 </param-value>
</context-param>
11. After placing the ID, the user can send green screen data as a whole or as some part of the screen (by providing row and column values) to Office365 apps like Excel, OneNote, and mail.
12. A Microsoft authentication popup will open when the user clicks the office 365 icon in the ribbon, where the user must enter their outlook mail ID. Parallelly, the office 365 panel opens in the background.
13. The office 365 panel loads the username with a greeting if the user is successfully authenticated. Else it will be blank. When the user enters the mail ID, another popup grants permission for the app that has been created to access the logged-in users' data, such as the drive, name of the user, and mail.
Excel:
- The user must give a unique file name to create a file and save it to get listed in the filename table. Click Folder icon in the filename table to view the selected file.
- User can add a new sheet to the existing file by selecting the file and clicking Add+.
- Additionally, the users can provide the coordinates of the green screen and the excel sheet to where the user wants to add the data. The user must give the sheet name and click Add + to add the sheet to the file, and a success popup comes up.
- The Users can create a chart by clicking +Add Chart after selecting respective file and sheet name.
- The Users can delete the sheet of respective file by Clicking Delete.
OneNote:
- The user must give a unique Notebook name for each document. The Section name and Page name are optional. A success popup comes up, post the file is created. After creating a file in OneNote, the file will be listed in the filename table. The user can view the respective file with the data (full-screen data or the selected part of the green screen) by clicking the open icon in the table.
Mail:
- The user must give the recipient address (multiple addresses are allowed). The Subject line and comment are optional for this application. The user can send the green screen data (full-screen data or the selected part of the green screen) by clicking the send button. After clicking on send button, a success popup comes up.
Contact
For further information on Automation, Services offerings, or Technical details in IBM HATS/HACP, please write to: ZIO@hcl.com.
Author
Gayathri M
SENIOR SOFTWARE ENGINEER - HACP EE
Gayathrim.g@hcl.com