SSIS Components for Microsoft Dynamics 365

Build 24.0.9175

ListAssociations

Lists all associations for a specified table and its related navigation properties. 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 want to list associations. This helps specify the source entity.
UrlId String False An alternative to using FromId, representing the full URL of the resource for which associations are being listed. This is required when the navigation property is abstract or when specifying child types of a base-type navigation property entity.
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'.
NavigationProperty String True The navigation property associated with the entity for which you want to list associations. This can be obtained using the ListNavigationProperties function.

Result Set Columns

Name Type Description
Uri String The URL of the associated resource, providing a direct link to the related entity.

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