Last time I proved I could send a proactive message to myself, but I needed my user ID that I could only get after I’d started a conversation with the bot. For my real-life scenario I need to be able to push notifications to users that haven’t interacted with my Continue Reading
Creating a bot pt. 4 – Installing for Users
Last time we managed to get everything we need to push messages to a user by having them install our app in Teams, but to make this really seamless it would be better to push the app out to users automatically.
Creating a bot pt. 2 – Proactive Messages
The key thing I want to do with my bot is to push messages out to users when something happens in D365, not just in response to the user sending a message to the bot. This was the part I was unsure of, but a bit of searching gives me Continue Reading
Creating a bot pt. 1 – Getting Started
Before I make any progress with the real logic of my new bot, I need to get the basics set up. I first need to create a simple bot and be able to interact with it from Teams. This is where the whole Azure Bot Framework really shines – I Continue Reading
My first bot – D365 Notifications
At Data8 we’ve successfully used posts on CRM records for some time to share updates. The problem was that people didn’t know when someone had written a post, so they would resort to email instead.
SQL 4 CDS 2.1.0 – the T-SQL edition
Since I’ve been doing some investigation into the new preview T-SQL endpoint for CDS recently, I’ve decided to integrate it into SQL 4 CDS. Update to 2.1.0 to get:
CDS T-SQL Endpoint pt 8 – Security
The security model is a key advantage of CDS over alternatives such as Sharepoint or SQL. Data is one of any organisation’s most precious assets, and the built-in ability to restrict access to records based on ownership, sharing, teams, hierarchy and even per-field makes this an incredibly powerful feature.
CDS T-SQL Endpoint pt 7 – Extensibility
One of the aspects of the CDS platform I’ve liked since Dynamics CRM 4.0 is the extensibility options – the ability to add plugins into the core of the engine so that your custom code will be executed however someone is using it, whether through the standard UI, portals, external Continue Reading
CDS T-SQL Endpoint pt 6 – Aggregates
One of the things that is very frustrating when trying to do any sort of analysis of data in CDS is the fetch aggregate limit. If you haven’t come across this before, this is a hard limit of 50,000 records that it will process when trying to calculate aggregate values Continue Reading
CDS T-SQL endpoint pt 5 – EntityFramework / ORM
Now I can reliably connect to the CDS T-SQL endpoint and execute queries against it, I want to get the data into some objects for me to use. I currently use EntityFramework and Dapper for this in other projects, so I’ll take a look at those two.