Retrieving Dynamics 365 Data Using SQL in Plugin: TDS Endpoint
The TDS (Tabular Data Stream) endpoint in Dynamics 365 allows developers to query Dataverse data using SQL commands. This article explains how to use the TDS endpoint to retrieve data in C#. It covers the prerequisites, such as enabling the TDS endpoint and installing the required libraries. The article also provides a code example that demonstrates how to execute a SQL query using the TDS endpoint and return the result in JSON format. It includes information on error handling and testing the custom API with XrmToolBox. The article concludes by highlighting the benefits of using the TDS endpoint for data retrieval in Dynamics 365.
Article 3m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time