If you have a new question you’d like our support staff to post a response to, please visit our customer community, GoAnywhere Insiders, to pose the question in our Discussion Boards. We have a thread “Ask Our Tech Experts” that our support team monitors on a regular basis, or you can start a new discussion where other GoAnywhere users and support staff can weigh in. Log in or create your new account at https://insiders.goanywhere.com
If you need an immediate response, please create a support ticket or contact our support team by email at [email protected]
- Posts: 5
- Joined: Wed Sep 10, 2014 11:33 am
I would like to create a project that will:
- 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?
- Posts: 592
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
It should be something similar to ...
Code: Select all
<project name="DB Loop"
<statement>Select F1, F2, F3 from DB.Table</statement>
<forEachLoop label="Loop through Data"
<setVariable label="setVar: JSON String"
value="'Set JSON String here'"
<https label="Post Raw Data"
Lead Solutions Consultant
Return to “Community Forum”