The first step to activation is often to get real time alert on your data.
In the Peliqan Data App templates you’ll find an example data app that sends alerts to MS Teams on a schedule based on a peliqan query that evaluates if there is the query returns data or if there are new data to alert on.
Data to alert on
The start of your alert flow is defining what data you want to alert on. In the Peliqan platform you can easily use the query module to define the relevant data. You can combine, transform and filter cross data sources.
We advise to limit the amount of columns to include to not overcomplicate your alert message:
! Use a date column if you want to only send alerts on items since the last run.
Data App Flow
We have the following main steps in this data app:
- Start: containing some context variables and state handler. State is used if a date is provided.
- Configuration: add here your alert configuration, the query to look at and if we need to take a data into account. Also the MS Teams connection name and channel name is required.
- Validate Connection : We will verify in this block if the provided MSTeams channel can be found and used.
- Fetch Data: In this block we fetch the data based on the configuration
- If no data is found, the script will stop
- if a data column is provided in the configuration step, the data will be limited to all rows that have a date higher than last run. This logic can be changed based on your use case, for example to only show data with a data of last 24hours.
- Format Message: In this block the message is constructed. This can be altered based on your requirements.
- Send Alert To MS Teams: This block will send the MS Teams message
The result of this template will look like this (dummy data):
