Hi all, The PUT feature of REST in Data Services requires enhancement due to drawback in current implementation.
The current implementation requires the user to enter all the parameters defined in a SQL update query to be executed, even to update the value of a single column in the table of the database. If an update query is to be defined to update a single column then there will be a resource paths for each update query which wouldn't be practical eg; when the user has 100 columns in the table and requires to update different column from time to time. *Current Implementation* eg : update query Generated Input Mappings Payload required: According to the current implementation the user can not update only the Salary column in the table. A payload as given below cannot be executed. In order to support such a feature the query should be dynamically generated with the parameters passed along in the payload by checking with the defined update query. There should be a way to identify optional and mandatory parameters to be passed in the payload. The user should be able to include optional parameters as well in the payload, the parameters in the payload should be validated accordingly before execution. -- *Sangeeth Karunaratne* Software Engineering Intern | WSO2 Inc. Email: [email protected] Mobile: +94767031534 Web: http://wso2.com
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
