Azure HTTP trigger

Power BI Admin Ciel 0 Reputation points
2024-04-16T12:06:17.88+00:00

I have http endpoint where i need to get the data and insert into the SQL table.
This is pipeline i am trying to build but i am not able to map the columns in the SQL table with the previous step.
User's image

I have given only the link and select the method as get.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,851 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. VenkateshDodda-MSFT 18,281 Reputation points Microsoft Employee
    2024-04-18T12:08:39.0766667+00:00

    @Power BI Admin Ciel Thank you for posting your question in Microsoft Q&A, apologize for any inconvenience caused on this.

    Based on the share information, I understand that HTTP action will return a Json object which contains different properties, and you want to insert those properties into SQL database in their respective columns.

    I would suggest you add Parse Json action after the Http action in the above workflow to pull the specific property values and thereby by calling the Insert row action you can insert the data to db.

    Hope this helps, let me know if you have any questions on this.