Input - SQL Poll
SQL Poll Input module periodically connects to the given MySQL database and runs the given SQL query. If there was a result, depending on the As Array setting it will generate one payload per line or on payload with all the resulting lines as an array.
The Frequency parameter is in seconds, as best practice the Connection parameter should be templated , for example
=<.main_db>= and main_db setting should be defined in the app's Environment Variables section. This way the same interface declaration can be copied into several apps (live, uat, staging systems) without the need of modifying the interface.This is also a good way securing sensitive information while working on the interface declaration, and the recipes we create from the interface will not contain any secure information.
