topic Re: read csv, post json to REST API in Talend Studio

read csv, post json to REST API

Anonymous — Fri, 09 Aug 2013 09:08:53 GMT

newbie to TOS (5.3) familiar with json and REST
big picture... i'm trying to read a csv, convert each record to json and call a rest api to insert.
if someone had an example
1. authenticate and get access token
2. read/process a CSV record (don't need help here, got this working well)
3. POST the JSON
4. Read response, if FATAL end, else read next
http://sberyozkin.blogspot.com/ very helpful, but couldn't extrapolate from a single request into a job to process n rows and POST 1 at a time.
thanks for reading.

Re: read csv, post json to REST API

Anonymous — Tue, 20 Aug 2013 11:46:34 GMT

Hi rquinn,
the tFlowToIterate (behind the reading of the CSV file and before your tRESTClient component) might be the component of choice for you to get a request for each individual CSV record.
HTH,
Dietmar

Re: read csv, post json to REST API

Anonymous — Tue, 20 Aug 2013 12:37:11 GMT

Thanks Dietmar.

Re: read csv, post json to REST API

Anonymous — Tue, 12 Nov 2013 04:23:13 GMT

Tags:
newbie to TOS
big picture... i'm trying to call a rest service that returns a csv like response and than process the response and put it in a MongoDB .
What is the best way so I can read the response as a stream and walk through the lines , map to the a document to put in a MONGO DB ?
if someone had an example of the first part ( reading and parsing the CSV stream ) it would be great
thanks for reading.