Power Community

Power Community

How to Use Retrieve Operation in Dataverse using Console Application


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.");
                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


Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

Create analytical presentations with Integrated Maps within Microsoft Dynamics 365!

30Sep September 30, 2023 General “Okay Jen, calm down, take a deep breath, and look at me. I am here to help...

More Articles Like This

- Advertisement -spot_img