post json to rest web service

If you have a new question you’d like our support staff to post a response to, please visit our customer community, Data Security 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

If you need an immediate response, please create a support ticket or contact our support team by email at [email protected].
2 posts Page 1 of 1


Posts: 5
Joined: Wed Sep 10, 2014 11:33 am

Post by rickc » Fri Sep 23, 2016 7:15 pm
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?



Support Specialist
Posts: 592
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Mon Sep 26, 2016 10:16 am
It should be something similar to ...
Code: Select all
<project name="DB Loop"

	<module name="Main">

		<sql resourceId="MyDBServer"
			<query outputVariable="Data">
				<statement>Select F1, F2, F3 from DB.Table</statement>

		<forEachLoop label="Loop through Data"

			<setVariable label="setVar:  JSON String"
			             value="&apos;Set JSON String here&apos;"
			             version="2.0" />

			<https label="Post Raw Data"
			       resourceId="HTTPS Server"
			       version="1.0" />


Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
2 posts Page 1 of 1