a DB monitor that sends slack notifications on new activity "user added" and creates Asana task if failed
This application monitors a specified database table for the addition of new tasks. Upon detection of a new task, it sends a detailed Slack message derived from the table's data to a designated channel. In the event of any failures or hitches in the notification process, the application automatically craetes an Asana task to alert and assist the responsible team.
- DB Monitor: This specific setup monitors a table for new entries in the form of new users.
- Asana Integration: Automatically creates tasks in Asana with relevant error details if any occur.
- Slack Integration: Sends an instant notification to a Slack channel with details of a new user that was added to the DB table.
- Clone the repository to your project directory.
- Navigate to the cloned directory and include the files in your project.
- Add the credentials of the database that will be monitored in the config file
- Creates a sample DB and relevant tables (edit as needed)
- Adds a triger to the member table that listens for new members added and sends the data to the pending tasks table,script listning for changes and triggers a slack message on new member
- Set up an Asana Access Token and create an ENV variable to host it.
- Provide the Asana workspace ID where tasks should be created.
- Add a task name.
- Add the assignee ID.
- Add the project ID.
- Set a custom due date.
- Download the latest cacerts and store as
cacert.pem. See cURL CA Extract for more details.
- Set up a custom slack webhook and create a slack app.
- Edit the webhook details.
- Download the latest cacerts and store as
cacert.pem. See cURL CA Extract.
Contributions are welcome!
This project is licensed under the MIT License. See the LICENSE file for details.