appmixer.mssql.db.NewRow
1.0.0
Public
| Field | Type | Description |
|---|---|---|
| Storage | select | Select a data store. The data store will be used to store data streamed from mssql so that we can compare them later to detect new rows. If you do not select a data store, one will be automatically created for you when the flow starts and deleted when the flow stops. If you do select a data store manually, you are responsible for clearing/deleting it when you don't need it anymore (note that the data in the data store is populated automatically, so any data left in the store affects the next flow run). |
| Detect new rows while stopped | toggle | If this is set to true, rows that are added while the flow was stopped will be processed next time the flow is started. |
| SQL Query | textarea | Enter an SQL query. If your query contains a ? character placeholder, then the NewRow component replaces the placeholder with the last timestamp (seconds since epoch) the component was triggered to query only data that has been added since the the last time the component was triggered. Note that the replaced timestamp is an integer, so you might need to use a function like UNIX_TIMESTAMP to make date comparisons. Also note that this is only possible if your result set contains an "created_at" type of field. A typical use case is, e.g. select * from mytable where created_at > FROM_UNIXTIME(?). If you do not provide the ? placeholder, then the component will always query all data periodically. |
| ID field in query result | text | A unique field from the query result set that will be used to check for new vs existing rows. |
| Field | Type | Description |
|---|---|---|
| Row | - |