URL Parameters to tHTTPRequest from a database

One Star

URL Parameters to tHTTPRequest from a database

Hi; I have the following flow to reverse geocode lat/long data in an oracle table...
tOracleInput --> tJavaRow (trying to get the parameters) --> tHTTPRequest --> tLog (testing)
I cannot find a way to dynamically use the row data as the URL parameters for lat & long as shown below:
output_row.latitude & output_row.longitude
Would appreciate some help. Thanks
Community Manager

Re: URL Parameters to tHTTPRequest from a database

Hi
Using tFlowToIterate to iterate each row. For example:
tOracleInput --row1--> tFlowToIterate--iterate--> tHTTPRequest --> tLog (testing)
Set the URL path with a dynamic value like: "http://......?parameter_name="+row1.name
//name is a column name in tOracleInput
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: URL Parameters to tHTTPRequest from a database

Thank you Shong; that worked!