...
Writing rules with http.post and http.put requests eliminates the need to use a Stored stored procedure to update/insert records into your database tables and then call that Stored Procedure from a business rule.
...
- Create a stored procedure to update/insert the values into the database table
- Call this stored procedure in the <retrieve> tag of your configuration.xml query
- Use an http.get statement in your business rule to call this query. The stored procedure will execute and update/insert data to into your table
Here is an example of a mySql stored procedure.
...