Looker Studio Integration Swagger Intro

Summary of What I See in the Swagger Docs

From the screenshots, here’s a structured breakdown of your available API endpoints and what matters for our Looker setup:

📌 Auth Headers (Required for all requests)

These must be sent on every request from the Cloud Run proxy (you’re doing this already in your Flask app).

🟢 GET Endpoints (Good for Looker Studio)

These are the endpoints you’re using or planning to use for reporting:

📌 You’re already calling these via Cloud Run + header injection in Flask.

⚠️ POST Endpoints (like /reports)

• These can work in Looker Studio only via your Cloud Run proxy, since Looker can’t make direct POST requests.

• You’ve already handled this in Flask (/reports route uses requests.post())

🧠 Important Field: surgery_code or surgery_id

From Swagger and your app logic:

• You must include surgery_code or surgery_id in every request either as:

  • A query param (e.g. ?surgery_code=DE09) or

  • A header (you’re already doing it in build_headers())

✅ This allows filtering data by clinic/surgery and supports secure, tenant-level dashboards.

✅ Current Approach

• Using Cloud Run to inject secure headers and serve API

• Using Ayvah in LookerStudio for JSON API to consume from Cloud Run

• Passing surgery_code dynamically from app via URL to Looker

• Handling GET and POST logic in Flask