topic Re: URL Parameters to tHTTPRequest from a database in Talend Studio

URL Parameters to tHTTPRequest from a database

Anonymous — Wed, 29 Aug 2012 18:53:06 GMT

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

Re: URL Parameters to tHTTPRequest from a database

Anonymous — Thu, 30 Aug 2012 05:40:19 GMT

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

Re: URL Parameters to tHTTPRequest from a database

Anonymous — Thu, 30 Aug 2012 12:12:52 GMT

Thank you Shong; that worked!