main.py

import csv
import time
import requests

from dotenv import load_dotenv # Remove if API key is not required
from os import environ # Remove if API key is not required

load_dotenv() # Remove if API key is not required

API_LINK = "https://example.com/api?key={}&api_key={}" # Remove the api_key parameter if API key is not required
API_KEY = environ.get("API_KEY") # Remove if API key is not required
TIME_TO_WAIT = 1 # Time to wait between API calls in seconds (set to 0 for no wait)
FILE_PATH = "resources/temp.csv" # Path to the CSV file

def main():
    process_csv(FILE_PATH)

def process_csv(file_path):
    with open(file_path, mode='r', newline='') as csvfile:
        reader = csv.reader(csvfile)

        for row in reader:
            for item in row:
                if item == "":
                    continue

                url = API_LINK.format(item, API_KEY) # Remove the API_KEY parameter if API key is not required
                response = requests.get(url)

                print(f"Response for {item}: {response.status_code} - {response.text}\n")

                if TIME_TO_WAIT != 0:
                    time.sleep(TIME_TO_WAIT)


if __name__ == "__main__":
    main()