Views:

Scenario Overview

In this scenario we have a company with a HQ office in the USA & regional offices in France. The users of the CRM system in France need to enter their notes about the Case record in French and so this needs to be translated to English which is the global language for the company.



To complete this we are going to use Microsoft Cognitive Service Text Translation API.

First Steps:

To access the Microsoft Translator Text Translation API you will need to sign up for Microsoft Azure. Follow these steps.

  • Sign up for a Microsoft Azure account at http://azure.com
  • After you have an account go to http://portal.azure.com
  • Select the + New option.
  • Search for 'Translator Text' and select it ( should be under the category AI + Machine Learning)
  • Read the text and click on Create
  • In the Pricing Tier section select the pricing tier that fits your needs.
  • Fill out the rest of the form, and select the Create button.
  • You are now subscribed to Microsoft Translator.
  • Go to All Resources and select the Microsoft Translator API you subscribed to.
  • Go to the Keys option and copy your subscription key to access the service.

You will need one of these keys to use the translation service.

North52 Decision Suite Solution

The North52 Decision Suite solution works like this,

  • We create a formula of type 'Save - To Current Record' on the Case entity
  • Set the Source Property to be the Local Language field
  • Add in the API key from Azure into the AzureCognitiveIssueToken() function
  • The web-service returns the text translated to English
  • This result is put into the Global Language field

                      

North52 Decision Suite Steps

The following set of steps will set this formula up for you.

  • Create a new formula of type 'Save - To Current Record'
  • Set the Source Entity to 'Case'
  • Set the Event to 'Create & Update'
  • Set the Source Property field to 'Local Description'
  • Set the Target Property to 'Global Language'
  • Copy and paste the formula below into the formula canvas
  • Copy in your API key
  • Click Save and you are ready to test

Formula

iftrue(Containsdata([incident.new_locallanguage]),  

  CallRestAPI( 
    SetRequestBaseURL('https://api.microsofttranslator.com/v2/http.svc/'),
    SetRequestResource('Translate'),
    SetRequestDetails('Get'),
    SetRequestHeaders(),
    SetRequestParams('appid', 'Bearer ' + AzureCognitiveIssueToken('xxxxxxxxxxxxxxxxxxxxxxxxxxx'), 
      'to', 'en', 
      'text', [incident.new_locallanguage]
    ),
    SetRequestAuthenticationNone(),
    SetRequestFiles(), 
    SetRequestExpected('OK'),  
    SetRequestActionPass(GetVarXPathValue('.')),
    SetRequestActionFail('NoOp')
  )               
)

Wizard - AzureCognitiveIssueToken

Please see below the wizard you can use to create the AzureCognitiveIssueToken() function call used in this formula. 

Note you will need to enter your own token as mentioned above, 
 

Did you know?

North52 helps you automatically test Dynamics 365 projects

North52's TestShield helps you test Dynamics 365 projects:

  • FASTER - Our no code solution delivers automated CRM project testing faster
  • EASIER - Simple to use point-and-click interface to build simple or complex testing plans
  • SMARTER - Lower your project risk and slash ongoing costs with automated process testing

Learn more about TestShield

Keywords: WebFusion, iftrue, ContainsData, GetVar, AzureCognitiveIssueToken, GetVarXPathValue, CallRestAPI, SetRequestBaseURL, SetRequestResource, SetRequestDetails, SetRequestHeaders, SetRequestParams, SetRequestAuthenticationNone, SetRequestFiles, SetRequestExpected, SetRequestActionPass, SetRequestActionFail, Formula Manager