“不良请求”来自Azure数据工厂（ADF）中复制活动导入架构的消息
我必须将数据从CRM Business Central迁移到Azure SQL数据库。源数据来自REST API。我创建了一个与之相关的链接服务。然后，我使用以下内容创建了一个复制活动：
预览工作。我以JSON格式获得数据。对于“映射”选项卡，我尝试导入架构并将字段“值”设置为数组。我得到以下结果：
但是，在映射的右侧，我只能看到“@odata.context”提出的“水槽映射”。我通过编写正确的字段来掩盖它。当我使用“调试模式”运行管道时，没有触发管道，我收到了一个“不良请求”：
错误来自映射。我的问题是：在JSON数据的情况下，“导入架构”如何工作？我必须手动导入模式吗？
I have to migrate data from CRM Business Central into an Azure SQL database. The source data comes from REST API. I created a linked service related to it. Then I created a copy activity with the following:
The preview works. I get data in a JSON format. For the mapping tab, I tried to import the schema and set the field "value" as an array. I got the following result:
However, on the right side of the mapping, I can only see "@odata.context" proposed as a "sink mapping". I overwrote it by writing the right fields. When I run the pipeline with "debug mode", the pipeline is not triggered and I received a "Bad Request":
The error comes from the mapping. My question is: how does the "Import schema" work in case of JSON data? Do I have to import manually the schema?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
通过排除特殊字符，将接收器列
@odata.context更改为其他名称。当我在接收器列中使用特殊字符（@，。）时，我已经使用示例REST API进行了回复，并遇到了相同的错误。
我更改了接收列名称
ex：data_id以排除特殊字符，管道成功运行。Change the sink column
@odata.contextto other name by excluding the special characters.I have reproed with a sample rest API and got the same error when I used the special characters (@, .) in the sink column
ex :@data.id.I have changed the sink column name
ex: data_idto exclude special characters and the pipeline ran successfully.