Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

get attribute(column) name, type, description of Entity

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

i want get attribute(column) name, type, description of Entity from CRM, without use any code. Direct Export from CRM

How to do that

please help me on this

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: get attribute(column) name, type, description of Entity

    I'm using XrmToolBox, and it's excellent.  I'm considering using it to manage descriptions for tables and columns.  Before I get much deeper into this, I would like to understand the architecture better.  I have two questions I'm hoping you can help with:

    1) Where do the descriptions "live", physically?  They must be in a table, an external XML or JSON file, or something similar.  They are not in the Information Schema or Extended Properties, as far as I can tell.  

    2) Can other metadata fields in addition to description be created?  

    Thanks in advance for any light you can shed on these questions.

    -Brent

  • Suggested answer
    gdas Profile Picture
    gdas 50,085 on at
    RE: get attribute(column) name, type, description of Entity

    Hi,

    Here is some screenshot retrieve the entity metadata.

    1. Connect to XRMToolBox

    2. Select Metadata Browser

     metadata2.png

    3. Select Entity which you want to export the attributes details.

    metadata2.png

    4. Go to Attributes tab and click export .

    metadata3.png

    Hope this helps.

  • Suggested answer
    gdas Profile Picture
    gdas 50,085 on at
    RE: get attribute(column) name, type, description of Entity

    Hi ,

    Download the  tool XRMtoolbox where you get everything -

    https://www.xrmtoolbox.com/

    Hope this helps-

  • Suggested answer
    Shahbaaz Ansari Profile Picture
    Shahbaaz Ansari 6,203 on at
    RE: get attribute(column) name, type, description of Entity

    Hi Dmat,

    You can go to Advance find and you can Query on entity, also you can add the fields you want then run the query after that download the excel file,

    Open the excel file when you click the field it will show its data type.

    Thanks,

    Shahbaaz

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans