🎉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

Cannot retrieve data with "Enrich Data by Webservice"

User: "robin"
New Altair Community Member
Updated by Jocelyn

Hi

 

I am connecting to the Google API to reverse geo code locations into addresses. When I run the process below I am not getting the address back from Google. When I put the URL into the web browser, I do get the correc response back. What am I doing wrong?

 

 

<?xml version="1.0" encoding="UTF-8"?><process version="7.5.003">
<operator activated="true" class="read_csv" compatibility="7.5.003" expanded="true" height="68" name="Read CSV" width="90" x="179" y="85">
<parameter key="csv_file" value="/Users/Robin/Desktop/robin.csv"/>
<parameter key="column_separators" value=";"/>
<parameter key="trim_lines" value="false"/>
<parameter key="use_quotes" value="true"/>
<parameter key="quotes_character" value="&quot;"/>
<parameter key="escape_character" value="\"/>
<parameter key="skip_comments" value="false"/>
<parameter key="comment_characters" value="#"/>
<parameter key="parse_numbers" value="true"/>
<parameter key="decimal_character" value="."/>
<parameter key="grouped_digits" value="false"/>
<parameter key="grouping_character" value=","/>
<parameter key="date_format" value=""/>
<parameter key="first_row_as_names" value="false"/>
<list key="annotations">
<parameter key="0" value="Name"/>
</list>
<parameter key="time_zone" value="SYSTEM"/>
<parameter key="locale" value="English (United States)"/>
<parameter key="encoding" value="UTF-8"/>
<list key="data_set_meta_data_information">
<parameter key="0" value="twitter.true.polynominal.attribute"/>
<parameter key="1" value="tDate.true.polynominal.attribute"/>
<parameter key="2" value="tLat.true.real.attribute"/>
<parameter key="3" value="tLong.true.real.attribute"/>
</list>
<parameter key="read_not_matching_values_as_missings" value="true"/>
<parameter key="datamanagement" value="double_array"/>
<parameter key="data_management" value="auto"/>
</operator>
</process>
<?xml version="1.0" encoding="UTF-8"?><process version="7.5.003">
<operator activated="true" class="rename" compatibility="7.5.003" expanded="true" height="82" name="Rename" width="90" x="313" y="85">
<parameter key="old_name" value="tLat"/>
<parameter key="new_name" value="lat"/>
<list key="rename_additional_attributes">
<parameter key="tLong" value="lng"/>
</list>
</operator>
</process>
<?xml version="1.0" encoding="UTF-8"?><process version="7.5.003">
<operator activated="true" class="web:enrich_data_by_webservice" compatibility="7.3.000" expanded="true" height="68" name="Enrich Data by Webservice" width="90" x="447" y="85">
<parameter key="query_type" value="XPath"/>
<list key="string_machting_queries"/>
<parameter key="attribute_type" value="Nominal"/>
<list key="regular_expression_queries"/>
<list key="regular_region_queries"/>
<list key="xpath_queries"/>
<list key="namespaces">
<parameter key="&quot;formatted_address&quot;" value="&quot;formatted_address&quot;"/>
</list>
<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="GET"/>
<parameter key="url" value="https://maps.googleapis.com/maps/api/geocode/json?latlng=&lt;%lat%&gt;,&lt;%lng%&gt;&amp;key=<MY KEY>"/>
<parameter key="separator" value=","/>
<parameter key="delay" value="0"/>
<list key="request_properties">
<parameter key="Country" value="formatted_address"/>
</list>
<parameter key="encoding" value="SYSTEM"/>
</operator>
</process>

Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "robin"
    New Altair Community Member
    OP
    Accepted Answer

    Remove the comma as a seperator, it kills the field at that point. 

     

    Secondly I used regex to pull the fields I wanted. It seemed to be far friendlier than the Json or XML.