Power Community

Power Community

How to Use Retrieve Operation in Dataverse using Console Application

image

Implementation Steps:

As I mentioned in my previous Blog you can able to follow how to use Dataverse Connection with Console Application.

In this Blog we will see how to use Retrieve Operation in Dataverse

Copy paste the Below Code

static void Main(string[] args)
        {
            // Connection string to Dynamics 365
            string connectionString = "AuthType=Office365;Url=https://URL.crm8.dynamics.com/;Username=username@environment.onmicrosoft.com;RequireNewInstance=true;Password=PASSWORD;";
            // Create the CrmServiceClient instance using the connection string
            CrmServiceClient service = new CrmServiceClient(connectionString);
            // Check if the connection was successful
            if (!service.IsReady)
            {
                Console.WriteLine("Failed to connect to Dynamics 365.");
                return;
            }
            else
            {
                Entity retrieveAccount = service.Retrieve("account", new Guid("e5c5f9b6-6b2f-ee11-bdf4-002248d5d764"),
                    new Microsoft.Xrm.Sdk.Query.ColumnSet(true));
                string accountName = retrieveAccount.Attributes["name"].ToString();
                EntityReference AccountOwner = (EntityReference)retrieveAccount.Attributes["ownerid"];
            }
        }

In the above snippet you will see 

“account” –> Logical Name of the Table

“e5c5f9b6-6b2f-ee11-bdf4-002248d5d764” –> Guid of the Record

Microsoft.Xrm.Sdk.Query.ColumnSet(true) –> (true) to retrieve all the Records from the table

retrieveAccount.Attributes[“name”].ToString() –> Retrieve Name of the Record from the Account Table

(EntityReference)retrieveAccount.Attributes[“ownerid”] –> Retrieve Owner of the Record from the Account Table

That’s it 🙂

How to Retrieve Records in Dataverse using Console Application 

This post was originally published on this site

- Advertisement -spot_img

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

Refresh Dynamics 365 CRM Subgrid from Embedded Canvas App

In Microsoft Dynamics 365, the ability to embed Canvas Apps brings the power of Canvas Apps to their model-driven forms. Recently,...

More Articles Like This

- Advertisement -spot_img