{"action":"opened","issue":{"url":"https://api.github.com/repos/MicrosoftDocs/azure-docs/issues/18481","repository_url":"https://api.github.com/repos/MicrosoftDocs/azure-docs","labels_url":"https://api.github.com/repos/MicrosoftDocs/azure-docs/issues/18481/labels{/name}","comments_url":"https://api.github.com/repos/MicrosoftDocs/azure-docs/issues/18481/comments","events_url":"https://api.github.com/repos/MicrosoftDocs/azure-docs/issues/18481/events","html_url":"https://github.com/MicrosoftDocs/azure-docs/issues/18481","id":378823432,"node_id":"MDU6SXNzdWUzNzg4MjM0MzI=","number":18481,"title":"How to get stored procedure error in the output","user":{"login":"rangeranger","id":40862037,"node_id":"MDQ6VXNlcjQwODYyMDM3","avatar_url":"https://avatars2.githubusercontent.com/u/40862037?v=4","gravatar_id":"","url":"https://api.github.com/users/rangeranger","html_url":"https://github.com/rangeranger","followers_url":"https://api.github.com/users/rangeranger/followers","following_url":"https://api.github.com/users/rangeranger/following{/other_user}","gists_url":"https://api.github.com/users/rangeranger/gists{/gist_id}","starred_url":"https://api.github.com/users/rangeranger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rangeranger/subscriptions","organizations_url":"https://api.github.com/users/rangeranger/orgs","repos_url":"https://api.github.com/users/rangeranger/repos","events_url":"https://api.github.com/users/rangeranger/events{/privacy}","received_events_url":"https://api.github.com/users/rangeranger/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-11-08T16:50:22Z","updated_at":"2018-11-08T16:50:22Z","closed_at":null,"author_association":"NONE","body":"**Scenario:** When a Stored Procedure failed then if it returns the error details, How to capture this in the output?\r\n\r\n**Why?** I'm using Azure Logic App to trigger an email when Stored Procedure failed. I want to send the error details in the email. Currently in the body of the POST request, ADF only allows to add System Variables like Trigger Name, Data Factory Name and Output of the stored procedure activity. It doesn't allow to add error details.\r\n\r\n**Below is the error it returned. It is in JSON format.** \r\n![image](https://user-images.githubusercontent.com/40862037/48213556-1db1a080-e34c-11e8-81cc-2bea3e4b26b6.png)\r\n\r\n**And below is the output it currently allows to add in Web HTTP request body.**\r\n![image](https://user-images.githubusercontent.com/40862037/48213670-59e50100-e34c-11e8-8d50-176f1c0fb2f4.png)\r\n\r\n"}}
{"actor":{"display_login":"rangeranger"}}