@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.