Now what if I told you there was a way to bypass your carefully constructed plugin logic?
Continue reading “Bypassing CDS Plugins”
Since Dynamics CRM 2013 we’ve been able to create our own APIs within the XRM framework using the Custom Action process type. Recently a new option appeared in the maker portal called Custom APIs which sounded very similar, so I thought I’d take a look.
Continue reading “CDS Custom APIs”
The latest addition to FetchXML is Late Materialize. Turning this on or off doesn’t change the results of your query, but it does change how it’s executed behind the scenes, which could lead to some performance improvements.
Continue reading “FetchXML Late Materialize”
I’ve looked at different ways of accessing CDS metadata recently, but there’s another way I’d overlooked – using FetchXML.
CDS exposes a limited amount of metadata as special virtual entities that lets you query it using standard FetchXML syntax:
Continue reading “Querying Metadata with FetchXML”
I received a notification today that the preview TDS endpoint had been disabled on my environment because of a security vulnerability.
Continue reading “CDS T-SQL Endpoint Vulnerability”
I’ve been studying lately for the Azure Data Engineer Associate certification, and the main point of one of the exams (DP-201 – Designing an Azure Data Solution) is all about picking the data platform(s) that best meet the requirements.
Having used SQL Server for many years it’s a simple trap to fall into to just use it for everything. It’s a very powerful tool for running complex queries and can cope with just about anything you want to throw at it, but it’s not always the best choice.
Continue reading “Picking the right data technology”
One of the things that really attracts me to the D365 platform is its metadata capabilities. As an ISV we make a lot of use of this at Data8, making sure our solutions automatically adapt to the customizations that each customer has made in their own system.
There are a few different ways to access the metadata, from both the SDK and Web API. I’m going to look at the SDK options in this post – this is what you’d use in a plugin or external app.
Continue reading “Retrieving Metadata in D365 / CDS”
I’m pleased to release the latest update for SQL 4 CDS today! For this update I’ve focused on common problems I’ve seen people encounter with their queries from my telemetry. These updates should either mean that more queries can be executed immediately, or the error message is more descriptive to help solve common errors.
Continue reading “SQL 4 CDS 2.3.0 Released!”
I’ve been doing some work today on filtering multi-select optionset fields in SQL 4 CDS and using the T-SQL endpoint, and I came across a few interesting quirks.
Continue reading “Multi-select Picklist Filtering”
One great option in FetchXML is to filter dates using a relative filter such as “this week”, “older than 2 years” etc. This is particularly helpful when you build a view, as it will automatically build the date criteria each time so your view is always up to date.
Continue reading “FetchXML Date Filtering”