I am new to Cloveretl, Unable to get desired results populated
we are Read data from a csv file (has zip codes listed) --> call web service (Input_mapping defined) --> store the output to a csv file, (both the input Zip and name from the web service should be written to the csv) .
Problem: the output is updating all output records with latest record.Please see the attached screenshot
webservice used: http://api.openweathermap.org/data/2.5/ ... ip=60435us
Thanks in advance
we are Read data from a csv file (has zip codes listed) --> call web service (Input_mapping defined) --> store the output to a csv file, (both the input Zip and name from the web service should be written to the csv) .
Problem: the output is updating all output records with latest record.Please see the attached screenshot
webservice used: http://api.openweathermap.org/data/2.5/ ... ip=60435us
Thanks in advance
-
Attached is the file that we are using.
our use case is to get the ZIP code and Name as output.
Zip code should be taken from the input reader
name should be coming from the webservice.
problem that i observed is HTTP connector takes each zip code and processes it , sends to JSON Extract. all records are then processesd and written to writer at once.
Output is getting all the records updated with latest record. you can observe the same in the output_file -
Hi,
From the graph I understood that the aim of this graph is to gain list of ZIP codes and Cities. Is my understanding correct ?
I suggest to do following :
Add Zip codes field to metadata to avoid later joining.
Reconfigure HTTPConnector to send the page content straight on the edge.
Reconfigure JSONExtract extract city names straight from HTTPConnector outputs.
I am attaching the reworked graph for your reference.
Please sign in to leave a comment.
Comments 4