MensaarLecker Development Log 2 -- Web Developing and GitHub Workflow
Repository: MensaarLecker
Fetching Data from Web Development
Continuing from last post, we have already implemented a script that collect the Mensa menu and stored it on Google Sheets. It is time to build our web interface to connect the database.
Fetch Data from Google Sheets using Publish
First, we need to publish our spreadsheet so that it is public to fetch the data.
In the Spreadsheet, click Share → Change access to Anyone with the link.
Click File → Share → Publish to the web.
Select Entire Document → Comma-separated values (.csv) and click Publish.
Copy the public CSV link.
SCRIPT_URL = {PUBLISH_LINK}
# Fetch JSON data
def fetch_menu():
try:
response = requests.get(SCRIPT_URL)
response.raise_for_status() # Raise error if bad response
return response.json()
except requests.exceptions.RequestException as e:
print(f"❌ Error fetching menu: {e}")
return []
However, the script return no data, why?
Access to fetch at 'https://docs.google.com/spreadsheets/...' from origin 'null' has been blocked
by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource.
If an opaque response serves your needs, set the request's mode to 'no-cors' to fetch the resource with CORS disabled.
