Mssql Endpoint Properties

query (string, required)

The SQL query used to write or to subscribe

Example: "INSERT INTO test (some_column) VALUES (@some_column)"

interval (integer)

The amount of milliseconds between queries

cronExpression (string)

The Cron expression used to poll the endpoint. (For examples, see: https://github.com/node-cron/node-cron)

Examples: "1,2,4,5 * * * *", "1-5 * * * *", "*/2 * * * *", "* * * January,September Sunday"

validateQuery (boolean)

Deprecated: This property has no effect anymore, please remove it from your files (Previous description: Validate the syntax of the SQL query)