I’m really pleased to announce this major update to SQL 4 CDS! This is a complete overhaul of the engine that converts your SQL into something that Dataverse/CRM can understand, and means you can now run a much broader set of queries than ever before.
Querying Virtual Entities
Virtual entities are a great way of exposing external data sources in Dataverse, and with the recent release of create/update/delete support I’m sure they’re about to become much more widely adopted. Your data immediately becomes available for your apps and appears no differently to your users than any other entity. Continue Reading
Custom Action to Custom API Converter Tool Released!
I’ve just released my latest XrmToolBox tool – Custom Action to Custom API Converter!
Create/Update/Delete Virtual Entities
It’s finally here! We can now use standard Create/Update/Delete operations with virtual entities! There’s a great example to get started over at the Microsoft docs site.
SQL 4 CDS 4.1.0 Released
I’ve quietly been releasing minor updates to SQL 4 CDS over the past few weeks, so I thought it was time to do a blog post for an “update roll up”
Security Debugger 1.0.2 Released
Thanks to the feedback from Arjun Musuvathy I’ve just released version 1.0.2 of my Security Debugger tool for XrmToolBox. Install it free from the XrmToolBox tool store!
OptionSet Labels in Power BI Reports
If you’ve tried reporting on your Dataverse / Dynamics 365 data using Power BI, you’ll probably have noticed you don’t get the labels associated with any optionset (now “Choice”) fields in your data. There are ways around this such as using the PowerBI OptionSet Assistant solution. In this post I’ll Continue Reading
TDS Endpoint Time Zone Change
A change has been rolling out recently to the Dataverse TDS Endpoint that affects how date/time values are returned, which should give your queries better performance but may mean you’ve got to do a bit more work to ensure the values are shown as your users expect.
MSDyn365 Internals: Paging Gotchas
I’ve recently been looking at a few cases where I’ve got seemingly incorrect results from my FetchXML queries. This can manifest itself as the results limited to 50,000 records or records being skipped. I’ve narrowed these down to some behaviour I wasn’t aware of when you retrieve multiple pages of Continue Reading
Security Debugger Tool Released!
Have you ever been confronted with a permissions error message full of detailed but incomprehensible codes? Something like: Check out my latest XrmToolBox tool, Security Debugger! Install it now so it’s ready next time you hit a security error. Simply paste in the error message and it will: highlight the Continue Reading