API calling in SQL Server and save the data in table

Here is a sample code, I need to call 3 endpoints of APIs to save data to 6 tables. It must be done by the Store Proc in the MS Database.

The deliverable is Store Proc.

Example as below for reference.
https://zealousweb.medium.com/calling-rest-api-from-sql-server-stored-procedure-85ec1ab73504