- Read a record from a database (select statement)
- Assemble a json string in a variable
- Post the json to a rest web service
- Loop and read the next record from the db
I was able to setup a project to post json from a static file(post raw data). I'd like to generate the JSON from the SQL statement and post to the web services one record at a time.
What is the best way to accomplish this?