Sunday, 29 October 2017

Microsoft Email Adapter in Oracle Integration Cloud Service (ICS)

Oracle ICS provided Microsoft Email adapter that allows us to create an integration with a Microsoft Email application.

Microsoft Email Adapter in an Oracle Integration Cloud Service enables us to retrieve messages in Office 365 and Outlook.com. The Microsoft Email Adapter enables us to manage messages, manage folders, create folders, read messages from a folder, sent email etc.

Important Adapters







Pre-requisite for creating a connection
  • Click on Add an app button
  • Enter the Application Name and click Create button
  • Note the Application Id and save it somewhere
  • Click Generate New Password to generate a secret key
  • Note the Password that got generated and save it somewhere. You will not be able to see the password again after clicking on the Ok button
  • Click on the Add Platform button
  • Choose Web
  • Enter https://ICSURL:ICSPORT/icsapis/agent/oauth/callback in the Enter a URL field. 
For example https://icstest-324567.integration.us2.oraclecloud.com/icsapis/agent/oauth/callback
  • Scroll to the bottom of the page and click Save
Now we have completed the pre-requisite and got the application id and secret key that is required to create a connection.

Create a Microsoft Email Adapter Connection
  • Login into the ICS
  • Click on the Connections tile
  • Click on Create button from upper right
  • Search Microsoft Email  and select adapter
  • Enter Name and click Create button
  • Click on Configure Security button
  • Enter below information and click on Provide Consent button
    • Security Policy: Select Microsoft Mail Authorization Code Credentials 
    • Client Id: This would be the Application id that got created during application creation
    • Client Secret: This would be the password that got created after clicking the Generate New Password in the above section
    • Scope: https://outlook.office.com/Mail.ReadWrite offline_access
The scope might be different as per the need but offline_access is required after space


Provide Consent button will allow ICS to interact with the MS account which was used to create an application in https://apps.dev.microsoft.com/ if everything is correct
  • After clicking the Provide Consent it will ask the ICS credentials. Enter the credentials and click Ok button. These would be the same credentials that we use to login into the ICS
  • After that provide the MS account credentials. We will get the below page that will ask the permission to interact with the account. Click Yes
  • Once it is done, will get the Access Allowed! page
  • Go back to the Connection page and click on the Test button
  • The connection will reach the 100%. Click Save and close button

10 comments:

  1. After clicking on the Provide consent Button, When i provide my Microsoft credentials an error occurs 'Microsoft account is experiencing technical problems. Please try again later.'
    Can you help in this. And also i am using OAIC instead of ICS

    ReplyDelete
    Replies
    1. Can you please send the screenshot of the error. Also, make sure the MS credentials has the admin privileges from which you are trying to provide consent.

      Regards,
      Ankur

      Delete
  2. Hi,I am getting following error while testing the integration

    ErrorInvalidRecipients","message":"At least one recipient isn't valid., Recipient \"\"xxxx@gmail.com\"\" isn't resolved. All recipients must be resolved before a message can be submitted."

    Any idea in which scenario do we get this error. Recipient email id is a valid one, tried with couple of other ids but still gets the same error.

    ReplyDelete
  3. Ideally is should not through this error. Can you check some MS documentation for the error.

    Regards,
    Ankur

    ReplyDelete
  4. Hi Ankur,
    Can you pls give me some idea on Oics integration with Financials Cloud-->Service Max-->SCM Cloud.

    ReplyDelete
  5. Hi Ankur,

    Thanks for the detailed steps. I followed it to create a MS email connection in OIC but after clicking on Provide Consent I am getting below error. Can you please suggest on what could be the issue.

    invalid_request: The provided value for the input parameter 'redirect_uri' is not valid. The expected value is a URI which matches a redirect URI registered for this client application.

    ReplyDelete
  6. What callback URL you have given during MS application creation ?

    Regards,
    Ankur

    ReplyDelete
    Replies
    1. This comment has been removed by the author.

      Delete
    2. Hi Ankur,

      I have provided same as mentioned in blog

      https://ICSURL:ICSPORT/icsapis/agent/oauth/callback with my oic url and port.

      like https://integrationtestinstance-dev47india.integration.ocp.oraclecloud.com/icsapis/agent/oauth/callback

      Regards,
      Devang

      Delete