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.
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
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.
