Import API data to a Google Spreadsheet

I need a professional to perform dynamic import of data from an API.
The data is at the following address:

https://rapidapi.com/api-sports/api/api-football

The import should be done based on the parameters that will be in cells B2:B11.

The content is dynamic and must be updated whenever there is a modification in the parameter (cell) of the endpoint.

The data updates must happen even with the spreadsheet closed, because some time-based triggers will be used.

You can subscribe to the free version of the API to do the tests. I will send you my key after I close the proposal with someone.

It is normal that in some cases the endpoit is empty. This happens on tab 6 when it comes to "Cup" type competitions, for example.

You can create the target spreadsheet as you want.

Here are the points that must be imported, parameters are in the cells indicated:

Tab 1
-> Fixtures > Fixtures by date
https://api-football-v1.p.rapidapi.com/v3/fixtures?date="B2"
https://api-football-v1.p.rapidapi.com/v3/fixtures?date="B3"
https://api-football-v1.p.rapidapi.com/v3/fixtures?date="B4"

Tab 2
-> Fixtures > Fixtures by team id
https://api-football-v1.p.rapidapi.com/v3/fixtures?season="B5"&team="B7
https://api-football-v1.p.rapidapi.com/v3/fixtures?season="B6"&team="B7"

Tab 3
-> Fixtures > Fixtures by team id
https://api-football-v1.p.rapidapi.com/v3/fixtures?season="B5"&team="B8
https://api-football-v1.p.rapidapi.com/v3/fixtures?season="B6"&team="B8

Tab 4
-> Fixtures > Fixtures Head To Head between two teams
https://api-football-v1.p.rapidapi.com/v3/fixtures/headtohead?h2h="B7"-"B8"

Tab 5
-> Odds (Pre-Match) > Odds by fixture id
https://api-football-v1.p.rapidapi.com/v3/odds?fixture="B9"

Tab 6
-> Standings > Standings by league id
https://api-football-v1.p.rapidapi.com/v3/standings?season="B10"&league="B11"