Hi Everyone
I've spent many an hour in Talend for other things, but can't seem to crack this and was hoping people could help.
I have a CSV file containing a single column of numbers, and these numbers determine the URL of the data I need to download. These numbers will change regularly, so Talend needs to read this CSV. It might look like:
123
345
567
Talend should iterate through this, downloading the relevant data from discrete URL's. The URL's will look something like:
https://www.eventbrite.co.uk/xml/event_list_attendees?id=123
https://www.eventbrite.co.uk/xml/event_list_attendees?id=345
https://www.eventbrite.co.uk/xml/event_list_attendees?id=567
The XML in this is not complex, just an XML representation of a basic spreadsheet, effectively.
Once downloaded, these separate data files (metadata and structure are the same for all of them) should be merged into one flat file, so I can output this as a single large CSV file.
Finally, I should add that when downloaded the data I can specify whether the data is in XML format or JSON. I am happy to use whatever people think will be easier.
Can someone explain how I would do this? Much appreciated
thanks
stony