import requests
import csv

# API request
#url = 'https://data.gov.gr/api/v1/query/minedu_dep'
url='https://data.gov.gr/api/v1/query/diavgeia-organization'

headers = {'Authorization': 'Token 74664d11b28d4a45346d61f47596ff7521f62f9b'}
response = requests.get(url, headers=headers)
data = response.json()

# Assuming 'data' is a list of dictionaries
if data and isinstance(data, list):
    # Create a CSV file
    with open('c:\\tmp\\Diaygeia.csv', 'w', newline='', encoding='utf-8-sig') as file:
        # Assuming all dictionaries have the same keys.
        fieldnames = data[0].keys()

        # Create a CSV writer object and write the headers
        writer = csv.DictWriter(file, fieldnames=fieldnames)
        writer.writeheader()

        # Write the data rows
        for row in data:
            writer.writerow(row)
    print("Data written to minedu_dep_data.csv")
else:
    print("No data to write")