Use data from Event Hub Trigger to SQL Connector using Logic App

Question

I need to store every incoming Event Hub data(JSON) into an Azure SQL Database using Azure Logic Apps. For this I'm using "Receive Event Hub Message" as trigger and Microsoft SQL Connector as Action.

After entering the details for SQL Connector, I chose "Insert into myTable(JSON)". I tried to assign the data from Event Hub to the table values using @triggers().outputs.body.[my_param] (got from git EventHubAPI-README.md), but the table doesn't get updated. Am I missing something here?

Rami Sarieddine · Accepted Answer · 2016-04-02 11:57:02Z

0

Can you try using the updated SDK for the Logic Apps, now you have new Actions under SQL Azure (Insert Row, Update Row) and more recently "Execute Stored Procedure" was also made available in the logic app preview

answered Apr 2, 2016 at 11:57

Rami Sarieddine

5,44238 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Use data from Event Hub Trigger to SQL Connector using Logic App

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related