🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

Google Cloud Translate via Web Enrichment Transform

paul_balas

Hi,

I am attempting to translate spanish and indonesian languages to english via google translate api. I am using the example posted on this board to by using the following url:

*** I split this apart as Raidminer thinks I'm posting a nefarious link... ****

translation . googleapis . com / language / translate / v2 / detect?key=mykey

I have a 'Read Database' query that get's the data I need. I named the field with the text to be translated as 'ActionDesc'.
I have set the following on the 'Enrich Data by Webservice' control:
query type = JasonPath
attribute type = nominal
jsonpath queries with attribute name = ActionDescTrans and query expression as $..translatedText
request method = POST
service method = foo
body =

{

'q': '<%ActionDesc%>',

'target': 'en',

'format': 'text'

}
request properties = property = ActionDesc value = ActionDesc

The process runs and returns my 10 rows I expect, but the ActionDescTrans field just has '?"

Any suggestions would be helpful.

TIA,

Paul

Find more posts tagged with

AI Studio

Accepted answers

paul_balas

Here's what ended up working for me:

You'll need the following process flow at a minimum:

1. A source of data - mine is a database query - this is the data you want to translate
2. An 'Encode URL' operator - to clean up the string you'll pass the the next step
3. A 'Enrich Data by Webservice' operator - this is to call the Google Cloud Translate API
4. Optional - add a target to write your results to (I used excel).

My data set had 3,483 records (most in spanish, some in english, but no way to know in advance given my data). End-to-end, the process took 1.5 hours to run. I ran it locally, I assume it would run faster had I deployed it to a Rapidminer Server in the Google Cloud. I decided to write the intermediate output of translated language to a workbook (excel). My next steps will be to parse the output you get from Google Translate in order to extract entities and do semantic analysis. Here is what the output of a translated title looks like:

{

"data": {

"translations": [

{

"translatedText": "ENVIRONMENTAL EVENT LEVEL1 - DUST GENERATION",

"detectedSourceLanguage": "es"

}

]

}

My Example Workflow

Image: https://us.v-cdn.net/6030995/uploads/editor/2o/njngub9hfnwd.png

Setup your data source (in my case a query to only pull the fields I needed to translate. Please remember that calling the Google Translate API costs $$$ or credits, so while you are testing this out, you need to limit the number of rows you process to 10 or so so you can fix your bugs faster and reduce your cost to develop.

Image: https://us.v-cdn.net/6030995/uploads/editor/zo/cle4y7bw65cm.png

Image: https://us.v-cdn.net/6030995/uploads/editor/nl/dmeeau4klx2h.png

Next you have to encode the URL. If you don't know what that does, here you go: "Since URLs often contain characters outside the ASCII set, the URL has to be converted into a valid ASCII format. URL encoding replaces unsafe ASCII characters with a "%" followed by two hexadecimal digits.URLs cannot contain spaces."

Image: https://us.v-cdn.net/6030995/uploads/editor/1i/bl2tjdv8xaaf.png

This is the field from my query that I wanted to translate. This next part is pretty important, you need to choose the right 'encoding' method. If you choose 'UTF-8' that will work fine on short text fields, but if you have a paragraph, you'll need to setup encoding as 'UTF-16'. I'm no UTF-expert, but I found this to solve my issue when encoding a larger field. *** UPDATE *** Choose 'SYSTEM' encoding instead of UTF-8 or UTF-16. I discovered that things like accent marks ended up being decoded into '% 00' text results. With SYSTEM encoding, your results should be fine and you wont' get strange decoded texrt.

Image: https://us.v-cdn.net/6030995/uploads/editor/xr/sdzka73skmct.png

Next, you use the 'Enrich Data by Webservice" control. Before you do this, you need to setup your Google Cloud Project (below)

<--- this is the Enrich Data by Webservice' control

This part was a bit of trial and error with help from YY at Rapidminer. One thing you need to do here is to update a few dialogues and set the 'url' field. You'll need to have ready your Google API Security Token (explained later). Here is my example to set up the 'url':

https://translation.googleapis.com/language/translate/v2?q=<%Event_Title%>&target=en&key=YOURKEY

Notice that I put the 'Event_Title' in the URL to correspond with the parameter I encoded in the 'encode url' control. You wrap your parameter with the <%YOUR PARAMETER%>

The 'target=en' is to translate the incoming text to English. The api will auto detect the incoming language you send it, so no need to define that.

The 'regular expression queries' section needed an attribute to hold your translated text, which is returned via the 'query expression '.*' In my
case I call it 'TranslatedTitle' which will show up as an extra attribute on the result set and contain the translated text for the Event_Title field.

Next, update the 'request properties' 'Edit List' section. Here you are going to replace the value with your Google API Security Token (yes, explained below...). You'll need to put this on the URL as well (no clue why, but it didn't work without it).

GOOGLE CLOUD PROJECT SETUP
1. You'll need an account on GCP  https://console.cloud.google.com
2. Setup a project and then go to the api library:  https://console.cloud.google.com/apis/library
3. Then click on the 'Cloud Translation API' (you need a valid billing method... so first, set up the billing method)
4. Then enable the 'Cloud Translation API
5. Go to your projects 'credentials' page:  https://console.cloud.google.com/apis/credentials?
6. Add a credential for an API, call it RM_Translate (anything you like really). A key is generated that you can use in the above examples which provide the security token necessary for you to make the call to GCP.

I hope this saves you hours of trouble.

Paul

All comments

kayman

Could you share your process, but ensure to comment out your key?
That would make it easier to troubleshoot

YYH

Hi @paul_balas,
Please refer to the process and remember to insert your own key.
Hope it helps.

<?xml version="1.0" encoding="UTF-8"?><process version="9.2.000">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="9.2.000" expanded="true" name="Process">
    <parameter key="logverbosity" value="init"/>
    <parameter key="random_seed" value="2001"/>
    <parameter key="send_mail" value="never"/>
    <parameter key="notification_email" value=""/>
    <parameter key="process_duration_for_mail" value="30"/>
    <parameter key="encoding" value="SYSTEM"/>
    <process expanded="true">
      <operator activated="false" class="google_cloud_platform:cloud_speech" compatibility="1.1.000" expanded="true" height="68" name="Google Cloud Speech API" width="90" x="112" y="34">
        <parameter key="API key" value="AIzaSyAWEYsJpAcNzGlPBKRokpstKXaD"/>
        <parameter key="request type" value="local"/>
        <parameter key="audio file" value="d:\Documents\CSM\BenjaminM\shwazil_hoful.flac"/>
        <parameter key="Cloud Storage Bucket URI" value="gs://gcs-test-data/gettysburg.flac"/>
        <parameter key="encoding" value="FLAC"/>
        <parameter key="sample rate (Hz)" value="16000"/>
        <parameter key="language code" value="en-US"/>
        <parameter key="profanity filter" value="false"/>
      </operator>
      <operator activated="true" class="utility:create_exampleset" compatibility="9.2.000" expanded="true" height="68" name="Create ExampleSet" width="90" x="112" y="187">
        <parameter key="generator_type" value="comma separated text"/>
        <parameter key="number_of_examples" value="100"/>
        <parameter key="use_stepsize" value="false"/>
        <list key="function_descriptions"/>
        <parameter key="add_id_attribute" value="false"/>
        <list key="numeric_series_configuration"/>
        <list key="date_series_configuration"/>
        <list key="date_series_configuration (interval)"/>
        <parameter key="date_format" value="yyyy-MM-dd HH:mm:ss"/>
        <parameter key="time_zone" value="SYSTEM"/>
        <parameter key="input_csv_text" value="text, target&#10;hello world, fr&#10;hello unicorns, fr"/>
        <parameter key="column_separator" value=","/>
        <parameter key="parse_all_as_nominal" value="false"/>
        <parameter key="decimal_point_character" value="."/>
        <parameter key="trim_attribute_names" value="true"/>
      </operator>
      <operator activated="true" class="web:encode_urls" compatibility="9.0.000" expanded="true" height="82" name="Encode URLs" origin="GENERATED_COMMUNITY" width="90" x="246" y="187">
        <parameter key="url_attribute" value="text"/>
        <parameter key="encoding" value="UTF-8"/>
      </operator>
      <operator activated="true" class="web:enrich_data_by_webservice" compatibility="9.0.000" expanded="true" height="68" name="Enrich Data by Webservice" width="90" x="447" y="187">
        <parameter key="query_type" value="Regular Expression"/>
        <list key="string_machting_queries"/>
        <parameter key="attribute_type" value="Nominal"/>
        <list key="regular_expression_queries">
          <parameter key="foo" value=".*"/>
        </list>
        <list key="regular_region_queries"/>
        <list key="xpath_queries"/>
        <list key="namespaces"/>
        <parameter key="ignore_CDATA" value="true"/>
        <parameter key="assume_html" value="true"/>
        <list key="index_queries"/>
        <list key="jsonpath_queries"/>
        <parameter key="request_method" value="POST"/>
        <parameter key="url" value="https://translation.googleapis.com/language/translate/v2?q=&amp;lt;%text%&amp;gt;&amp;amp;target=fr&amp;amp;key=Ao5mnxFa3cJsILDxiRw9WFjUNLcYUGo"/>
        <parameter key="delay" value="0"/>
        <list key="request_properties">
          <parameter key="key" value="Ao5mnxFa3cJsILDxiRw9WFjUNLcYUGo"/>
        </list>
        <parameter key="encoding" value="SYSTEM"/>
      </operator>
      <operator activated="true" class="web:get_webpage" compatibility="9.0.000" expanded="true" height="68" name="Get Page" width="90" x="246" y="340">
        <parameter key="url" value="https://translation.googleapis.com/language/translate/v2?key=Ao5mnxFa3cJsILDxiRw9WFjUNLcYUGo"/>
        <parameter key="random_user_agent" value="false"/>
        <parameter key="connection_timeout" value="10000"/>
        <parameter key="read_timeout" value="10000"/>
        <parameter key="follow_redirects" value="true"/>
        <parameter key="accept_cookies" value="none"/>
        <parameter key="cookie_scope" value="global"/>
        <parameter key="request_method" value="POST"/>
        <list key="query_parameters">
          <parameter key="q" value="test this line of english"/>
          <parameter key="target" value="zh-CN"/>
        </list>
        <list key="request_properties">
          <parameter key="key" value="Ao5mnxFa3cJsILDxiRw9WFjUNLcYUGo"/>
        </list>
        <parameter key="override_encoding" value="false"/>
        <parameter key="encoding" value="SYSTEM"/>
      </operator>
      <connect from_op="Create ExampleSet" from_port="output" to_op="Encode URLs" to_port="example set input"/>
      <connect from_op="Encode URLs" from_port="example set output" to_op="Enrich Data by Webservice" to_port="Example Set"/>
      <connect from_op="Enrich Data by Webservice" from_port="ExampleSet" to_port="result 1"/>
      <connect from_op="Get Page" from_port="output" to_port="result 2"/>
      <portSpacing port="source_input 1" spacing="0"/>
      <portSpacing port="sink_result 1" spacing="0"/>
      <portSpacing port="sink_result 2" spacing="0"/>
      <portSpacing port="sink_result 3" spacing="0"/>
    </process>
  </operator>
</process>

paul_balas

{

"data": {

"translations": [

{

"translatedText": "ENVIRONMENTAL EVENT LEVEL1 - DUST GENERATION",

"detectedSourceLanguage": "es"

}

]

}

My Example Workflow

Next, you use the 'Enrich Data by Webservice" control. Before you do this, you need to setup your Google Cloud Project (below)