Power BI Connector for Microsoft Dynamics 365

Build 22.0.8462

CreateAssociation

Creates an association between two entities based on a navigation property. Set the IncludeNavigationProperties connection property to true in order to use this stored procedure.

Input

Name Type Required Description
FromId String False The ID of the entity you are creating an associations for.
UrlId String False An alternative to specifying the FromId. This is the complete URL to the resource for which the association is being created. It is required to be specified in the case that the navigation property is an abstract, or to specify more specific child types where the navigation property entity type is used as a basetype.
FromTable String True The table where the entity comes from that you are creating an association for. For example, if the FromId was from a table called Customers, set this parameter to: Customers.
ToNavigationProperty String True The navigation property you are creating an association on. It can be obtained from ListNavigationProperties.
ToId String False The ID of the navigation entity. This will come from the table associated with the navigation property.
ToUrlId String False An alternative to specifying the ToId. This is the complete URL to the resource to be associated. It is required to be specified in the case that the navigation property is an abstract, or to specify more specific child types where the navigation property entity type is used as a basetype.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462