Azure Logic App: SQL trigger on When Row Is Update - Content is Null

codenpanda 0 Reputation points
2024-02-01T23:35:17.69+00:00

I have created a workflow that is triggered by an update to a table in SQL server. It fires but the content is null.

User's image

The message appears in the service bus but content length is zero.

{
	"headers": {
		"Accept-Encoding": "gzip,deflate",
		"Accept-Language": "en",
		"Host": "ava-enrollment-360-wu-dev.azurewebsites.net",
		"Max-Forwards": "10",
		... etc ...
		"Content-Length": "0"
	}
}
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,692 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Mike Urnun 8,996 Reputation points Microsoft Employee
    2024-02-07T21:56:07.5466667+00:00

    Hi @codenpanda - Thanks for reaching out. Are you using the LA Consumption or LA Standard with a built-in SQL connector? I suspect the issue may be with the trigger.

    • Verify if the output from the trigger has the row data.
    • Check if SQL change tracking is enabled. It needs to be enabled on both DB and table level
    0 comments No comments