SSIS Components for Microsoft Dynamics 365

Build 24.0.9175

CreateAssociation

Creates an association between two entities using the specified navigation property. This procedure is essential for linking related entities dynamically and requires the IncludeNavigationProperties connection property to be enabled.

Input

Name Type Required Description
FromId String False The unique identifier of the entity for which you are creating an association. This is essential to link the source entity to the target.
UrlId String False The full URL of the source resource for creating the association. This is required when the navigation property is abstract or when specifying a child type in cases where the navigation property entity type serves as a base type.
FromTable String True The name of the table containing the source entity. For example, if the FromId corresponds to an entity in the Customers table, set this parameter to 'Customers'.
ToNavigationProperty String True The name of the navigation property on which the association is being created. This value can be retrieved from the ListNavigationProperties function.
ToId String False The unique identifier of the target navigation entity. This ID should come from the table associated with the specified navigation property.
ToUrlId String False The full URL of the target resource to be associated. This is required when the navigation property is abstract or when specifying a child type in cases where the navigation property entity type serves as a base type.

Result Set Columns

Name Type Description
Success Boolean Indicates whether the operation was successful. Returns true if the association was created successfully; otherwise, returns false.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175