post json to rest web service

[rickc]

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]

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>