Retrieving Dynamics 365 Data Using SQL in Plugin: TDS Endpoint

In Dynamics 365, the TDS (Tabular Data Stream) endpoint allows developers to query Dataverse data using SQL-like commands. For example, suppose a sales manager wants to find the top three accounts with the highest revenue. Here’s how they can use the TDS endpoint to get that data.

Why Use SQL for Retrieving D365 Data?

Familiar Syntax: If you know SQL, we can easily write queries to fetch data without learning additional APIs or formats.

Efficiency: SQL is optimized for querying large datasets and complex conditions.

Flexibility: SQL queries allow for aggregations, filtering, and joins in a single step.

Note: The TDS endpoint can’t be used with elastic tables.

This guide demonstrates how to achieve this using the TDS endpoint in C#.

Prerequisites

1. Enable TDS Endpoint: Ensure the TDS endpoint is enabled for your Dataverse environment.

1. • Go to Power Platform Admin Center > Environments > Select your environment.
   • Under Settings, enable the TDS endpoint.

2. Install Required…

Source link