Entity & attribute metadata using c#

-

 Below example to get Attribute Metadata using C# for a specific entity.

/*Connection establishing using ClientID & Client Secret*/

public static void GetConnection()

        {

            try

            {

                string connectionString = "AuthType=ClientSecret; url=REPLACE WITH ORANIZATION URL; ClientId=REPLACE WITH YOUR CLIENT ID; ClientSecret=REPLACE WITH YOUR CLIENT SECRET";

                crmServiceClient = new CrmServiceClient(connectionString); //Connecting to the D-365 CDS instance


                if (crmServiceClient != null && crmServiceClient.IsReady)

                {

                    Console.WriteLine("\nConnection successful.");

                }

                else

                {

                    Console.WriteLine("\nPlease make sure the Connection String is correct.");

                }

            }

            catch (Exception ex)

            {

                throw new Exception(ex.Message);

            }

        }


private static void GetEntityMetadata(string entityName)

        {

            RetrieveEntityRequest req = new RetrieveEntityRequest()

            {

                EntityFilters = EntityFilters.Attributes,

                LogicalName = entityName,

                RetrieveAsIfPublished = true

            };


            RetrieveEntityResponse res = (RetrieveEntityResponse)organizationService.Execute(req);

            foreach (var item in res.Results)

            {

                var attributeCollection = (item.Value as EntityMetadata).Attributes;

                foreach (var attribute in attributeCollection)

                {

                    var displayName = (attribute.DisplayName != null && attribute.DisplayName.UserLocalizedLabel != null) ? attribute.DisplayName.UserLocalizedLabel.Label : string.Empty;

                    string lookupAttributeInfo = string.Empty;

                    if (displayName == string.Empty)

                    {

                        displayName = "*********";

                    }

                    if (attribute.AttributeType.ToString() == "Lookup")

                    {

                        lookupAttributeInfo = (attribute as LookupAttributeMetadata).Targets[0];

                    }

                    if (lookupAttributeInfo != string.Empty)

                    {

                        Console.WriteLine($"Display Name:{displayName} -->LogicalName:{attribute.LogicalName} -->Target Entity Name:{lookupAttributeInfo}-->IsPrimaryName:{attribute.IsPrimaryName}");

                    }

                    else

                    {

                        Console.WriteLine($"Display Name:{displayName} -->LogicalName:{attribute.LogicalName} -->IsPrimaryName:{attribute.IsPrimaryName}");

                    }

                }

            }


        }

static void Main(string[] args)

        {

            GetConnection();

            GetEntityMetadata("account");

        }

Comments

Post a Comment

Popular posts from this blog

Connecting Dynamics 365 Web api using external HTML page

-
Image
Here we are discussing on how we can connect Dynamics 365 Web Api using external application. Below are the steps we need to follow in order to achieve our goal. Note: if the HTML page is not giving any result or not able to load browser cache (CRM user token) then your need to clear Brower cache and try to load HTML again .   1.        Login in to https://portal.azure.com 2.        Provide your CRM username and password to log in into azure. Once you login create an application as below screen shot Azure Active Directory à App Registration à Click on New application registration 3.        Provide Name, select Application Type as “Web App / API” and provide Sing –on URL as CRM URL as below. 4.        Open the newly created application and click on Settings. 5.        Click on Keys and provide “Description” as key name and “Expires” as Never expires. Once you click on Save it generates a key. make sure you copy the key otherwise it will be hidde
Read more

Get azure blob files inside Sub Directories

-
In Microsoft doc's we can find code to get blob files inside a container using c#. What if Container has some Sub Directories with blob data/files. How we can replicate the folder structure in our local machine.        There might a change Container contains empty folder or a file. Below code snippet will help to create the same Azure Container structure. here i have used ASPX pages as per my requirement. we can use other applications as well. To get Azure connection string use below URL:  https://docs.microsoft.com/en-us/azure/storage/common/storage-configure-connection-string         public string storageAccountName = "azure storage account name";         public string accessKey = "your azure accesskey";         public string containerName = "myfirstblobcontainer";         public string connectiongString = "Azure connection string";         public string rootPath = @"C:\Users\Home\Downloads\your folder Name";  
Read more

Interview questions on MS CRM

-
Image
What is PrinciplalObjectAccess table why is it used?   The POA table is used to provide access to specific records for CRM users, and each record in the POA table represents one CRM object that is    related to one CRM user.  Records created in the POA table come from one of four ways:   ·           Share reassigned records with original owner:  CRM System Settings o      If this is set to Yes, then records would be added to the POA table whenever an assign takes place.  These records will have a value in the AccessRightsMask colum of the POA table. ·           Direct sharing:  Actions – Sharing  o      When users explicitly share a record to another user, a record would be created in the POA table.  These records will have a value in the AccessRightsMask colum of the POA table. ·           Reparent Setting:  Relationship Behavior o      Each entity has relationships with other entities (ex. Account to Case).  By default, the Reparent option is set to Cascade All.  With t
Read more