sqlInsertFeed
Inserts a record into a table or view using data from another RSSBus feed.
Required Parameters
| |
| conn | The connection string or database URL | |
| user | The database username | |
| password | The database password | |
| table | Table (or view) from where to delete the record. | |
| feed | The URL to the source feed. | |
| rec:* | Attributes of the record that will be inserted. Values are the names of the source feed atttibutes. | |
Optional Parameters
| |
| driver | The JDBC driver class name, by default the Microsoft driver class name is used. | |
| timeout | Timeout, in seconds, for the operation to complete. Zero (0) means no timeout. This attribute defaults to 60. | |
| map:* | Optional column mappings. You must use this attribute if column names in the table are different from the ones that you provided. | |
Output Attributes
| |
| sql:rowsinserted | The number of rows inserted. | |
| sql:table | The table affected by the insert. | |