DescribeMscrmEntityAttributes()

Retrieves information about the attributes of a Microsoft Dynamics CRM entity. This information includes the logical name, display name, and type of the attribute.

If an attribute contains a Boolean, status, picklist, or state value, the function returns a comma-separated list of option and display values.

Availability

Marketing Cloud Engagement	✅ Yes
Marketing Cloud Next	❌ No

Syntax

1DescribeMscrmEntityAttributes(entityName)

The DescribeMscrmEntityAttributes() function has one parameter:

entityName (string): Required. The name of the Microsoft Dynamics CRM entity to retrieve attributes from.

Usage

This example retrieves information about the attributes of the Lead entity in Microsoft Dynamics CRM.

1%%[ Var @fields_rs Set @fields_rs = DescribeMscrmEntityAttributes('Lead') ]%%
2
3<table>
4  <tr>
5    <th>Field Name</th>
6    <th>Display Name</th>
7    <th>Type</th>
8    <th>Required</th>
9    <th>Options</th>
10  </tr>
11  %%[
12    Var @field_name, @field_displayname, @counter, @field_type, @field_required, @field_options
13    For @counter = 1 to rowcount(@fields_rs) do
14      Set @field_name = Field(row(@fields_rs,@counter), 'Name')
15      Set @field_displayname = Field(row(@fields_rs,@counter), 'DisplayName')
16      Set @field_type = Field(row(@fields_rs,@counter), 'Type')
17      Set @field_required = Field(row(@fields_rs,@counter), 'Required')
18      Set @field_options = Field(row(@fields_rs,@counter), 'Options')
19  ]%%
20  <tr>
21    <td>%%=v(@field_name)=%%</td>
22    <td>%%=v(@field_displayname)=%%</td>
23    <td>%%=v(@field_type)=%%</td>
24    <td>%%=v(@field_required)=%%</td>
25    <td>%%=v(@field_options)=%%</td>
26  </tr>
27  %%[ Next @counter ]%%
28</table>

The example outputs a table that provides the field name, display name, field type, required status, and field options for each attribute in the Lead entity.

DID THIS ARTICLE SOLVE YOUR ISSUE?
Let us know so we can improve!