I have been asked to get data from a RESR API into a SQL Server database
I have tried using Power Transformation but have been stuck when I have finished parsing the JSON data.

I don’t know which action to add so that the JSON data will be loaded into the desired table in the SQL Server database

Your assistance would be greatly appreciated

Below is the current flow:

enter image description here

When I try SQL Server action Insert row (v2)

This is shown:

enter image description here

I am trying to connect to my local’s database via SSMS.

Table for the data has been prepared.