Passing input to Json webservice and writing to a csv file

CloverDX Platform
1

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

2

Hi,

I am sorry but the information you provided is not enough for us to be able to help you. Could you please upload the whole graph and the input .csv file in order to get a better picture of the issue ?

Thank you!

3

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

4

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.

5

Thanks a lot, your changes helped me to get the right data.