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

July 2024 update of Power Automate for desktop

We are happy to announce that the July 2024 update of Power Automate for desktop (version 2.46) has been...

More Articles Like This

- Advertisement -spot_img