RetrieveMscrmRecords()

Retrieves data from Microsoft Dynamics CRM entities.

Availability

Syntax

RetrieveMscrmRecords(entityName, fieldsToRetrieve,
                     queryFieldName, queryFieldOperator, queryFieldValue)

The RetrieveMscrmRecords() function has five parameters:

• entityName (string): Required. The name of the Microsoft Dynamics CRM entity to retrieve records from.
• fieldsToRetrieve (string): Required. A comma-separated list of fields to retrieve.
• queryFieldName (string): Required. The name of the field to filter on.
• queryFieldOperator (string): Required. The operator to use for the filter.
• queryFieldValue (string): Required. The value to filter on.

Usage

This example retrieves the contact ID, first name, and last name for all contacts where the last name is Santos.

%%[
  Var @records_retrieved, @counter, @firstname, @lastname, @id
  Set @records_retrieved = RetrieveMscrmRecords("contact", "contactid,firstname,lastname",
                                                "lastname", "=", "Santos")
]%%

<p>Contacts:</p>
<br />

%%[
  For @counter = 1 to RowCount(@records_retrieved) do
  Set @firstname = Field(Row(@records_retrieved,@counter),'firstname')
  Set @lastname = Field(Row(@records_retrieved,@counter),'lastname')
  Set @id = Field(Row(@records_retrieved,@counter),'contactid')
]%%

<p>First: %%=v(@firstname)=%%</p>
<p>Last: %%=v(@lastname)=%%</p>
<p>Id: %%=v(@id)=%%</p>
<br />

%%[ Next @counter ]%%