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.
If you need a quicker response, please create a support ticket via the customer portal my.goanywhere.com or contact our support team by email at [email protected].
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: 590
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