Hi,
I am new to Servoy. I would like to create a service to save the values(from an XML data) to database table.
Given this Sample DATA
<PRODUCTS>
<PRODUCT>
<ID>1</ID>
<NAME>Laptop</NAME>
<PRICE>100</PRICE>
</PRODUCT>
<PRODUCT>
<ID>2</ID>
<NAME>Keyboard</NAME>
<PRICE>20</PRICE>
</PRODUCT>
<PRODUCTS>
I have just deployed a solution with ws_create method as a web service.
1. How can I traverse the Object and pick the keys(e.g. ID, NAME) and values(e.g. 1,Laptop)in order to create the INSERT SQL Statement?
2. Or is should the XML data be formatted in a different manner to make it easier?
Thanks!
-Rogel