With the Power of Query, send an email or Microsoft Teams alert whenever a sales order meets specific criteria. Did a ticket email bounce? Send an alert. Is a gift membership missing contact info? Send an email.

In this session, the basics of automating Altru ®including how to:

• Call the Altru® Query API to obtain order details
• Filter the returned ODATA
• Convert the query results into an HTML table (with clickable links!)
• Send an email and/or Teams message

End point used: Altru® Analysis > "List adhoc query entries"

Connectors Used: BB SKY Add-ins (Required), Mail/Outlook (Optional), Microsoft Teams (Optional), Office 365 Users (Optional), Power Automate Management (Optional)

Coding Level: Light function use for building the HTML table and advanced filtering of results