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

rickc

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?


RickC

Support_Rick

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"
         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="&apos;Set JSON String here&apos;"
			             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
2 posts Page 1 of 1