Can we map the program and customer (relate) using ADF pipeline?

Question

Can we map the program and customer (relate) using ADF pipeline?

Sharifuinnisa H (INFOSYS LIMITED) 0 Microsoft External Staff

Can we map the program to customer using ADF pipeline? like how we used to create customer, contacts in ADF.
when I tried to map the customer with program using ADF got the below error

"
Operation on target Dynammics customer program map failed: ErrorCode=DynamicsOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Dynamics operation failed with error code: -2147219456, error message: The 'Create' method does not support entities of type 'gea_gea_programs_account'. MessageProcessorCache returned MessageProcessor.Empty. .,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,''Type=System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]],Message=The creator of this fault did not specify a Reason.,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,' "

Thank you!

Smaran Thoomu 29,500 Reputation points Microsoft External Staff Moderator

2025-08-28T13:15:20.74+00:00
Hi Sharifuinnisa H (INFOSYS LIMITED)

Thanks for the question. From the error details, the issue isn’t with ADF itself but with how the Dynamics 365 connector handles entities. The entity gea_gea_programs_account looks like a custom relationship entity (likely a many-to-many mapping table between Programs and Accounts/Customers).

Currently, the Dynamics connector in ADF supports standard operations (Create/Update/Delete) only on entities that expose those actions in the Dynamics API. For custom intersect entities (like your program-customer relationship), the API doesn’t expose Create, which is why ADF throws:

The 'Create' method does not support entities of type 'gea_gea_programs_account'

Options you can consider:

Use the Dynamics Web API directly (via an HTTP activity in ADF or Logic App/Power Automate) to call the correct association endpoints and link a program to a customer.

If your scenario requires heavy data movement, stage the mapping data in ADLS/SQL first, then call a custom connector or API pipeline to apply the associations in Dynamics.

Alternatively, explore whether the entity can be updated indirectly by writing to one of the parent entities (sometimes relationships are exposed as navigation properties).

So, in short: you can create customers/contacts via ADF, but relationship mapping like Program ↔ Customer isn’t supported through the native Dynamics connector. You’ll need to call the Web API or use Power Automate for that piece.

Hope this clarifies why you’re seeing the error.
Smaran Thoomu 29,500 Reputation points Microsoft External Staff Moderator

2025-08-29T20:30:01.87+00:00

Sharifuinnisa H (INFOSYS LIMITED) We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Your answer

Smaran Thoomu 29,500 Reputation points Microsoft External Staff Moderator

2025-08-28T13:15:20.74+00:00

Hi Sharifuinnisa H (INFOSYS LIMITED)

Thanks for the question. From the error details, the issue isn’t with ADF itself but with how the Dynamics 365 connector handles entities. The entity gea_gea_programs_account looks like a custom relationship entity (likely a many-to-many mapping table between Programs and Accounts/Customers).

Currently, the Dynamics connector in ADF supports standard operations (Create/Update/Delete) only on entities that expose those actions in the Dynamics API. For custom intersect entities (like your program-customer relationship), the API doesn’t expose Create, which is why ADF throws:

The 'Create' method does not support entities of type 'gea_gea_programs_account'

Options you can consider:

Use the Dynamics Web API directly (via an HTTP activity in ADF or Logic App/Power Automate) to call the correct association endpoints and link a program to a customer.

If your scenario requires heavy data movement, stage the mapping data in ADLS/SQL first, then call a custom connector or API pipeline to apply the associations in Dynamics.

Alternatively, explore whether the entity can be updated indirectly by writing to one of the parent entities (sometimes relationships are exposed as navigation properties).

So, in short: you can create customers/contacts via ADF, but relationship mapping like Program ↔ Customer isn’t supported through the native Dynamics connector. You’ll need to call the Web API or use Power Automate for that piece.

Hope this clarifies why you’re seeing the error.
Smaran Thoomu 29,500 Reputation points Microsoft External Staff Moderator

2025-08-29T20:30:01.87+00:00

Sharifuinnisa H (INFOSYS LIMITED) We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

Can we map the program and customer (relate) using ADF pipeline?

Your answer