post json to rest web service

Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
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