Microsoft Dynamics 365 for Operations Connector > Mappings and mapping tasks with Microsoft Dynamics 365 for Operations Connector > Microsoft Dynamics 365 for Operations lookups in mappings

Microsoft Dynamics 365 for Operations lookups in mappings

You can create lookups for objects in Microsoft Dynamics 365 for Operations connection. You can retrieve data from a Microsoft Dynamics 365 for Operations lookup object based on the specified lookup condition.

When you configure a lookup in Microsoft Dynamics 365 for Operations, you select the lookup connection and lookup object. You also define the behavior when a lookup condition returns more than one match.

The following table describes the Microsoft Dynamics 365 for Operations lookup object properties that you can configure in a Lookup transformation:

Property	Description
Connection	Name of the lookup connection.
Source Type	Type of the source object. Select Single Object.
Lookup Object	Name of the lookup object for the mapping.
Multiple Matches	Behavior when the lookup condition returns multiple matches. Select Return any row, Return all rows, or Report error.
Filter	Not applicable.
Sort	Not applicable.

The following table describes the Microsoft Dynamics 365 for Operations lookup object advanced properties that you can configure in a Lookup transformation in mappings:

Advanced Property	Description
Number of rows to read	Fetches the number of rows specified. Default value is 0.
Number of rows to skip	Sets the number of rows you can skip. Default value is 0.
Page Size	Size of the page set to retrieve the maximum number of entries for each page. Default value is 100.
Tracing Level	Sets the amount of detail that appears in the log file. You can choose terse, normal, verbose initialization or verbose data. Default is normal.