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].
-
rickc
- 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?
RickC
-
Support_Rick
Support Specialist
- 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"
mainModule="Main"
version="2.0"
logLevel="verbose">
<module name="Main">
<sql resourceId="MyDBServer"
version="1.0">
<query outputVariable="Data">
<statement>Select F1, F2, F3 from DB.Table</statement>
</query>
</sql>
<forEachLoop label="Loop through Data"
itemsVariable="${Data}"
currentItemVariable="Row">
<setVariable label="setVar: JSON String"
name="JSON"
value="'Set JSON String here'"
version="2.0" />
<https label="Post Raw Data"
resourceId="HTTPS Server"
version="1.0" />
</forEachLoop>
</module>
</project>
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696