如何在 Synapse 活动中映射 Dynamics 多选选项集

发布于 2025-01-12 22:54:26 字数 900 浏览 1 评论 0原文

我正在尝试将 Datalake 表中的值映射到 Synapse Pipeline Activity 中的 Dynamics 多选选项集字段

我有 2 个字段，1 是一个可用的选项集：vel_Frequency，

 "source": {"name": "vel_frequency","type": "String"},
 "sink": {"name": "vel_frequency","type": "Int32"

另一个是多选选项集：vel_program

 "source": {"name": "vel_program","type": "String"},
 "sink": {"name": "vel_program","type": "String"

我尝试过各种映射类型值：Int32、String... 这是错误消息，尽管类型设置为 String：错误：错误消息：属性值类型不正确 System.Int32

这是显示源数据和 Dynamics 列数据类型的数据预览

有一个页面指出 Dynamics 多选选项集存在已知限制：您可以将多选字段值导入到现有记录，但无法将其导入新记录。

有什么解决方法可以在 Synapse 中实现此映射吗？

原文

I'm trying to map a value from a Datalake table to a Dynamics Multi Select Option Set field in a Synapse Pipeline Activity

I have 2 fields, 1 is an Option Set which works: vel_frequency,

 "source": {"name": "vel_frequency","type": "String"},
 "sink": {"name": "vel_frequency","type": "Int32"

the other is a Multi Select Option Set: vel_program

 "source": {"name": "vel_program","type": "String"},
 "sink": {"name": "vel_program","type": "String"

I've tried various mapping type values: Int32, String...
This is the error message, despite the type set to String: error: error message: Incorrect attribute value type System.Int32

This is the data preview to show the source data and the Dynamics column data types

There is a page that states there are known limitations with Dynamics Multi Select Option Sets: You can import multi-select field values to existing records, but you can’t import them for new records.

Any ideas of any work arounds to achieve this mapping in Synapse?

分享到QQ

分享到微博