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

Question

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

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"
	}
}

Answer 1

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