Import data from JSON (HTTP GET) into PostgreSQL

Implement the import of data from the JSON response received via HTTP GET with subsequent loading into PostgreSQL tables (in accordance with the description of the fields in Excel files).
In the answer, indicate what you plan to implement.
Optimization suggestions in the ERD part are accepted.
Please indicate what you plan to implement (python, php, etc.).