How to send the contents of a newly created row in an SQL Azure Database to a Service Bus Queue using Logic Apps?

Question

I am trying to implement a very basic functionality, as follows: when a row is added in an Azure SQL Database the contents of that row are sent to a Service Bus Queue.

(1)How do I send the 'row' as parameter to the 'send message content'? (2)What kind of object does 'get row' create, and what kind of formatting does it need to be sent over to the Service Bus Queue? (3)Can't this whole operation be done with an Azure Function, rather than logic apps ? (I couldn't find an SQL trigger for Azure Functions).

Thank you in advance.

Answer 1

1. We have created logic app as shown below:

2. Created a compose action to get newly added row content as shown below:

3. Assigned value of compose to a variable as shown below:

4. In send message action, giving value of variable in content.

5. Logic app ran successfully.

6. Message received in service bus queue.

7. You can get primary column by writing expression as “triggerBody()?[primarycolumnname]”