One Star

read csv, post json to REST API

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.
3 REPLIES
Employee

Re: read csv, post json to REST API

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
One Star

Re: read csv, post json to REST API

Thanks Dietmar.
One Star

Re: read csv, post json to REST API

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.