我在使用Logic App的Azure Data Factory中遇到了以下问题。
我使用Azure Data Factory管道进行迁移，使用Logic App向技术团队发送“成功和失败”通知。现在成功可以很好地工作，因为消息是硬编码的，但失败并不是因为Logic App web活动无法解析数据工厂管道错误。
以下是逻辑应用程序web活动输入的输入
{
"url": "https://xxxxxxxxxxxxxxxxx",
"method": "POST",
"headers": {},
"body": "{\n \"title\": \"PIPELINE RUN FAILED\",\n \"message\":\"Operation on target Migration Validation failed: Execution fail against sql server. Sql error number: 50000. Error Message: The DELETE statement conflicted with the REFERENCE constraint \"FK_cmclientapprovedproducts_cmlinkclientchannel\". The conflict occurred in database \"Core7\", table \"dbo.cmClientApprovedProducts\", column 'linkclientchannelid'.\",\n \"color\": \"Red\",\n \"dataFactoryName\": \"LFC-TO-MCP-ADF\",\n \"pipelineName\": \"LFC TO MCP MIGRATION\",\n \"pipelineRunId\": \"f4f84365-58f0-4da1-aa00-64c3a4daa9e1\",\n \"time\": \"2020-07-31T22:44:01.6477435Z\"\n}"
}下面是应用程序抛出的错误逻辑
failures
{
"errorCode": "2108",
"message": "{\"error\":{\"code\":\"InvalidRequestContent\",\"message\":\"The request content is not valid and could not be deserialized: 'After parsing a value an unexpected character was encountered: F. Path 'message', line 3, position 202.'.\"}}",
"failureType": "UserError",
"target": "Send Failed Notification",
"details": []
}我尝试过各种方法，比如使用现有的各种方法(string，json，replace等)设置变量和转换，但没有成功，例如@string(activity('LOS migration').Error.Message)几乎整天都在挣扎this...please建议如果有人遇到类似的问题……
下面是数据流活动
?
?
?
转载请注明出处:http://www.jubohx.com/article/20230524/1452493.html