RetrieveMscrmRecords

Overview

Retrieves multiple CRM records. Use fields in the target entity or select fields from related entities by using many-to-one lookup attributes.

Syntax

RetrieveMscrmRecords(1, 2, 3, 4, 5)

Function Properties

OrdinalTypeDescription
1stringRequiredName of Dynamics CRM entity from which to retrieve records
2stringRequiredA comma-separated list of fields to retrieve
3stringRequiredField name to check value
4stringRequiredOperator to check value
5stringRequiredValue to check

Usage

Select the name of the parent account by including parentaccount.id name in the list of fields. You can also filter on Many:1 lookup attributes by using the same nomenclature. To retrieve accounts where the parent account's name is Example.com, include 'parentaccountid.name','=','Example.com' in your filters. All values regularly retrieved in Fetch XML queries are returned. If parentaccount.id is one of the fields to be returned, the results will have columns parentaccountid, parentaccountid.name, and parentaccountid.type.