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].
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
I would like to create a project that will:
What is the best way to accomplish this?
RickC
- 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
What is the best way to accomplish this?
RickC
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
-
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="'Set JSON String here'"
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
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
2 posts
Page 1 of 1