SQL Endpoint Properties

query (string, required)

The SQL query used to write or to subscribe

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

queryValues (string)

The SQL query values used to bulk insert

Example: "($id, $name, $age)"

interval (integer)

The amount of milliseconds between queries. Only required when subscribing

Default: 1000

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"