Dataverse - Dataverse Resource Types

Dataverse Resource Types define the types of Dataverse resources that CCS can give to Dataverse users. There are three kinds of Resource Types:

  • Connect Related Entity Single
    Used when the property/field is set on the Dataverse user and that property/field is an entity.

    Dynamics365 calls them Lookup-fields and allows a maximum of 15 expand properties when calling/fetching multiple records.

  • Connect Related Entity Multi
    Used when the Dataverse user can be associated with an entity and the relationship type is many-to-many.

  • Field Value
    Used when the property/field is set on the Dataverse user and that property/field is not an entity. Examples would be text and numbers.

10812695862300
For Resource Type Field Technical name Allowed value Description

Connect Related Entity Single and Connect Related Entity Multi

Name

idm_name

Text

Method

idm_method

OptionSet

User System

idm_usersystem

Lookup (User System)

Table Name

idm_tablename

Text

This is the plural name of the table in the Dataverse.

It has to exist in the Dataverse API.

Table Id Column Name

idm_tableidcolumnname

Text

This is the primary key of the table.

In Dataverse it is always a GUID. Its name has to be the same as in the Dataverse API.

Display Name Column Name

idm_displaynamecolumn

Text

This is the display name of the Dataverse Resource in CCS. It needs to be a property/field the table has and should exist in the Dataverse API.

Navigation Property Name

idm_navigationpropertyname

Text

This is the property name when a Dataverse user needs to be associated with the resource via the Dataverse API call.

It can be found in the Dataverse API metadata or in the solution.

Connect Related Entity Multi

Junction Table Name

idm_junctiontablename

Text

This is the plural name of the table which contains the Dataverse user Id and the Id of the associated resource.

Junction Table Id Column

idm_junctiontableidcolumn

Text

This is the Id of the row that contains the association between the Dataverse user and the associated resource.

Field Value

Field name to set

idm_fieldnametoset

Text

This is the property/field name of the Dataverse resource which CCS wants to give the Dataverse user.

The property/field has to exist in the Dataverse API.

Dataverse Resource Type Id

idm_customid

Text