在DataFactory中，使用Dynamics Web API将数据迁移到Dynamics365的好策略是什么? [英] In DataFactory, what is a good strategy to migrate data into Dynamics365 using Dynamics Web API?

问题描述

我需要使用DataFactory将数据迁移到Dynamics365. Dynamics365连接器对我来说还不够，因为其中一项要求是仅更新自上次迁移以来已修改的那些属性，而不是整个寄存器.另一个要求是有时我们必须将目标中的值空".

I need to migrate data using DataFactory to Dynamics365. The Dynamics365 connector is not enough for me since one of the requirements is to only update those attributes that have been modified since last migration - not the whole register. The other requirement is that sometimes we have to 'null' values in destination.

我相信我可以通过生成不同的JSON进行注册并使用Web API进行迁移来做到这一点.

I believe that I can do that by generating a different JSON for register and migrate them using the Web API.

我曾考虑过将这些调用放入Azure Functions中，但我相信它们并不是要像这样使用-即使采用正确的定价计划，它们也可以不受时间限制地运行.

I thought in putting these calls in an Azure Functions, but I believe that they are not meant to be used like this - even though with the right pricing plan they can run with no limit of time.

我认为我做错了，我找不到正确的方法.

I think I'm doing it wrong and I can't figure out the right way.

您能分享您的经验或观点吗?

Could you share your experience or point of view?

推荐答案

从其他应用程序与Dynamics 365交互的正确方法是直接使用WebAPI或使用C#的SDK(在两种情况下)来创建或更新多个记录，最好的方法(据我所知)是使用

The correct way to interact with Dynamics 365 from other application is either directly with the WebAPI or using C#'s SDK, in both scenarios, for create or update multiple records the best way to do it (as far as i know) is using ExecuteMultipleRequest Message, this allow you to set it with updates, creates, deletes and execute then in one request.

这篇关于在DataFactory中，使用Dynamics Web API将数据迁移到Dynamics365的好策略是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！