Microsoft Flow Integration


About this integration
IntegrationIntroduction

You can integrate third-party systems with Product name - ev itsm.png in many ways. The method you select will depend on business requirements, architectural and security constraints as well as the characteristics specific to each third-party application or service.

This document describes an integration process that has already been implemented in a customer context. 

To find out more about this integration (e.g. scripts to be used), please contact the Logo - EasyVista.png Consulting & Professional Services team, the Logo - EasyVista.png Support team, or your service provider and integrator.
 

Integration Synthesis

Microsoft Flow allows you to easily integrate and connect Web applications and services, data and devices.

  • The tool is based on a broad ecosystem of standard connectors based on Microsoft Azure Logic Apps, which expands regularly -  Open url.png see FAQ - Plans Flow

    Example documentation icon EN.png  Azure (Active Directory, …), Office 365 (Outlook, One Drive, SharePoint, Dynamics…), Skype For Business, Teams, Planner, Jira Software, SAP, Google Suite, Salesforce, Dropbox, Slack, Facebook, Twitter, Plivo, LiveChat, MySQL, SFTP, Service Bus

  • It allows interfacing with any endpoint through HTTP/HTTPS.

    Example documentation icon EN.png  Interfacing through REST API

     

Note : Flow workflows allow any user to perform basic integrations (e.g.: Receive SMS for important emails) without contacting developers or the IT department. By contrast, Logic Apps applications support advanced or strategic integrations (e.g.: B2B processes) that require corporate development and security practices at the corporate level. For this reason, Logic Apps includes more functionalities intended for developers and IT teams - Open url.png see Microsoft Azure Logics Apps Integration



Data Integration Flow (direction) Authentication Type Integration Connector Options

Product name - ev itsm - big.png

Up and Down arrow.png

Logo - Microsoft Flow.png

  • Based on the external service used (authentication is performed by Microsoft Flow)
  • Basic Authentication for the REST API Product name - ev itsm.png

Product name - ev itsm.png SaaS

Product name - ev itsm.png On-premise

Check icon.png

Check icon.png

Version SaaS of third party product

Version On-premise of third party product

Check icon.png

N/A

Step by step integration process

Example documentation icon EN.png  This integration is based on a simple use case: analyze the text entered by a user during the creation of an incident via the portal and notify a manager when this user is dissatisfied.
The exchange flow is represented below.
         Exchange flow diagram - EN.png

Documentation

Open url.png See the wiki
Open url.png see Microsoft Flow Documentation

Requirements

  • You must have a Microsoft Azure account. Otherwise, you can create one for free - Open url.png see Procedure
  • You must have an account to access your platform Product name - ev itsm.png with a profile and enough access and editing rights to create or edit a workflow, access the menu Administration and other menus you need, such as Operation and Transition.

Sentiment analysis subscription creation


Step 1 : Register for a free Azure account

1. Go to the Microsoft Azure site and click on Start free.
         Microsoft Flow - Free account.png

2. Log in to your account in Microsoft professional.
         Microsoft Flow - Login account.png

3. Specify the identification information and then click Next.
         Microsoft Flow - Account creation - Identification 1.png

4. Accept the subscription contract and then click on Registration.
         Microsoft Flow - Account creation - Identification 2.png

Step 2: Sentiment analysis subscription creation

1. Open the Azure portal if it does not open automatically.
         Microsoft Flow - Portal.png

2. In the menu on the left, select All resources, and click on + Add. Click on the option AI + Machine Learning and select the solution Text Analytics API.
         Microsoft Flow - Text Analytics Resource Selection.png

3. Complete the information for the new subscription and then click on Create.
         Microsoft Flow - Text Analytics Resource Creation.png

The deployment process is displayed on the right side of the screen. Once completed, the dashboard will show the subscription to sentiment analysis.
         Microsoft Flow - Analysis sentiment new flow.png

Step 3: Obtain a key

1. Click on the new subscription in the dashboard.

2. Click on the link Keys.
         Microsoft Flow - Key selection.png

3. Save the key 1 or 2; this will be requested at the time of the package import (step 2.5).
         Microsoft Flow - Key generation.png

Microsoft Flow Workflow Import

Step 1 : Import a Sentiment Analyses package

1. Connect to the Microsoft Flow site and click on My flows in the menu bar.
         Microsoft Flow - Menu bar.png

2. Click on the link Import and download the Sentiment Analysis package below.
         Download icon.png  Package

The package detail is displayed.

Step 2: Create a Text Analytics connection

1. Click on the link Select during import.
         Microsoft Flow - Import package.png

2. Click on + Create and then + New connection.
         Microsoft Flow - Import package - Connection creation 1.png
         Microsoft Flow - Import package - Connection creation 2.png

3. Enter Text Analytics in the search box and press the<Entrée> key.  
         Microsoft Flow - Import package - Connection search 1.png

4. Click on the connection Text Analytics.
         Microsoft Flow - Import package - Connection search 2.png

5. Specify the connection information and then click on Create.

  • Account key: Paste the previously backed up key
  • Website URL : https://westeurope.api.cognitive.microsoft.com/text/analytics/v2.0

         Microsoft Flow - Import package - Connection configuration.png

The new connection Text Analytics is displayed in the list.
         Microsoft Flow - Import package - Connection preview.png

6. Close the tab to return to the previous tab.

The new connection Text Analytics is displayed on the resources list.

7 Click on the resource and then click Save.
         Microsoft Flow - Import package - Connection save.png

8. Click on Import.
         Microsoft Flow - Import package - End creation.png

The import is finalized.

Step 3: Verify and configure the imported flow

1. Click on the link Open flow.
         Microsoft Flow - Open flow.png

A list of steps is displayed.
         Microsoft Flow - Open flow - Steps list.png

2. Configure the first step after receiving an HTTP request:

  • Click on the step’s label.
  • Save the URL displayed by clicking Copy icon.png: this will be requested during configuration in Product name - ev itsm.png (step 3.2).

    Example documentation icon EN.png  https://prod-35.westeurope.logic.azure.com:443/workflows/?????/triggers/manual/paths/invoke
    ?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=?????

         Microsoft Flow - Open flow - URL.png

3. Configure step HTTP2 :

  • Click on the step’s label.
  • Click on the variable concat(…).
             Microsoft Flow - Portal - Concat variable 1.png
  • Verify the name of the server and the account. Make corrections, if necessary. 

concat('https://{your_server}/api/v1/{your_account}/requests/',triggerBody()?['id'])

         Microsoft Flow - Portal - Concat variable 2.png

  • Click on the link Show Advanced Options.
             Microsoft Flow - Portal - Concat variable 3.png

4. Save your flow by clicking on Save at the bottom of the list of steps.

Configuration in Product name - ev itsm - big.pngev Service Manager

Step 1: Rights management for using REST API

1.. Go to the screen Management of user profiles

2. Tick the box REST API for the profile authorized to execute the REST API.

Step 2: Create a Microsoft Flow REST action or a business rule

         Open url.png  see procedure How to set up a REST action type for a new service

1. Create a new Microsoft Flow service.
         Service Manager - Service REST.png

  • Service URL: Must correspond to the red parts of the URL saved in Microsoft Flow (Import the package > step 3.3). Replace prod-35.westeurope with {subdomain}.

Example documentation icon EN.png  https://prod-35.westeurope.logic.azure.com:443/workflows/?????/triggers/manual/paths/invoke?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=??????

2. Create a new connection to the service.
         Service Manager - Connection REST.png

  • Service URL: Must match the new REST service created in the previous step.
  • subdomain : The value must correspond to the part in red in the URL saved in Microsoft Flow (Import the package > step 3.3)

Example documentation icon EN.png  https://prod-35.westeurope.logic.azure.com:443/workflows/?????/triggers/manual/paths/invoke?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=??????

3. Create a new resource for the service.
         Service Manager - Resource REST.png

  • Label: Specify the label that you want.
  • URL of the resource: must correspond to the part in red of the  URL saved in Microsoft Flow (Import the package > step 3.3)

Example documentation icon EN.png  https://prod-35.westeurope.logic.azure.com:443/workflows/?????/triggers/manual/paths/invoke?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=??????

  • Content : Perform a copy/paste of the text below.
{"Description": "{Description}","id":"{id}"}

Step 3: Workflow change

1. Open the desired questionnaire. 

2. Add a REST stepActions of the type Microsoft Cognitive Services.
         Service Manager - Workflow - REST action.png

3. Double-click on the step and enter the information below.
         Service Manager - Workflow - REST action editor.png

Integration Test

Step 1: Creation of a new incident by clicking Product name - ev sas.png

1. Log in to Product name - ev sas.png.

2. Create a new incident

Step 2: Flow execution

1. Log in to the Microsoft Flow.

2. Select the new flow Cognitive Services/Sentiment analysis.

The execution of the flow appears in the history.
         Microsoft Flow - Integration test.png

A notification appears according to the note received.

3. (Optional) Add the filed Free field 6 in the incident form to display the note.

Tags:
Last modified by Unknown User on 2018/07/23 15:18
Created by Administrator XWiki on 2018/07/23 15:15

Shortcuts

Recent Updates

Haven't been here in a while? Here's what changed recently:

-   Product name - ev itsm.png
-   Product name - ev sas.png

Interesting Content

How to Automate Integration
Add a Shortcut to an App
History
Quick Dashboard
Full text search - Stop Words

Powered by XWiki ©, EasyVista 2018