# Sync Ofsted Reports Data with Supabase (`alkausari_mujahid/sync-ofsted-reports-data-with-supabase`) Actor Pulls Ofsted children's home inspection data from PDF reports, deduplicates by URN, and upserts directly into your Supabase table. Filter by date range, schedule daily runs, and feed dashboards or compliance workflows โ€” no Make, no Zapier, no glue code needed. - **URL**: https://apify.com/alkausari\_mujahid/sync-ofsted-reports-data-with-supabase.md - **Developed by:** [Alkausari M](https://apify.com/alkausari_mujahid) (community) - **Categories:** Automation, Integrations, Other - **Stats:** 1 total users, 1 monthly users, 0.0% runs succeeded, NaN bookmarks - **User rating**: No ratings yet ## Pricing from $5.00 / 1,000 results This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events. Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-event ## What's an Apify Actor? Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases. In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours, and optionally produces a well-defined JSON output, datasets with results, or files in key-value store. In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server. Actors are written with capital "A". ## How to integrate an Actor? If asked about integration, you help developers integrate Actors into their projects. You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready. The best way to integrate Actors is as follows. In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js.md): ```bash npm install apify-client ``` In Python projects, use official [Python client library](https://docs.apify.com/api/client/python.md): ```bash pip install apify-client ``` In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md): ````bash # MacOS / Linux curl -fsSL https://apify.com/install-cli.sh | bash # Windows irm https://apify.com/install-cli.ps1 | iex ```bash In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/platform/integrations/mcp.md). If your project is in a different language, use the [REST API](https://docs.apify.com/api/v2.md). For usage examples, see the [API](#api) section below. For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt). # README **Sync Ofsted inspection reports directly into your Supabase table โ€” no Make, no Zapier, no glue code.** Powered by the [Ofsted Reports Data Scraper](https://apify.com/alkausari_mujahid/ofsted-reports-data-scraper), which extracts full inspection data from PDF files on the Ofsted website. This Actor takes those results and upserts them straight into your Supabase database on every run. > Built and maintained by **Alkausari M**. --- ### โœฆ Highlights - ๐Ÿ  **Full PDF extraction** โ€” powered by [Ofsted Reports Data Scraper](https://apify.com/alkausari_mujahid/ofsted-reports-data-scraper), which pulls structured data directly from Ofsted PDF files - ๐Ÿ“… **Date-range filtering** โ€” fetch only inspections published in a specific window - ๐Ÿ”„ **Upsert, not overwrite** โ€” new records are inserted; existing ones are updated by URN, no duplicates - ๐Ÿงน **Auto-deduplication** โ€” multiple results for the same provider are collapsed to one row before sync - ๐Ÿ“Š **Dual output** โ€” data lands in both your Supabase table and the Apify dataset simultaneously - ๐Ÿ–ฑ **Zero code** โ€” fill in credentials, paste a search URL, click Start --- ### โš™ How it works 1. **Paste an Ofsted search URL** โ€” apply your filters on [reports.ofsted.gov.uk](https://reports.ofsted.gov.uk/search) first (provision type, status, region), then copy the URL. 2. **Connect Supabase** โ€” provide your project URL and API key. Create the table in advance using the SQL below; the Actor upserts into it. 3. **Click Start** โ€” the Actor calls the [Ofsted Reports Data Scraper](https://apify.com/alkausari_mujahid/ofsted-reports-data-scraper), deduplicates by URN, and syncs everything to Supabase. ```jsonc // Example input { "start_urls": [ { "url": "https://reports.ofsted.gov.uk/search?q=&level_1_types=3&level_2_types%5B0%5D=11&status%5B0%5D=1&start=0&rows=10" } ], "latest_report_date_start": "01-01-2024", "latest_report_date_end": "31-12-2024", "only_latest_inspection": true, "apify_api_token": "apify_api_...", "ofsted_actor_id": "UNmCLFqfH6zXa3Mfc", "supabase_url": "https://xxxx.supabase.co", "supabase_api_key": "eyJ...", "supabase_table": "ofsted_inspections" } ```` - **`latest_report_date_start` / `latest_report_date_end`** โ€” optional date filters (`DD-MM-YYYY`). Leave blank to fetch all reports. - **`only_latest_inspection`** โ€” `true` (default) gives one record per provider; useful for dashboards and monitoring. - **`max_depth`** โ€” how deep the underlying scraper crawls linked pages. Default `3` covers most search results. *** ### ๐Ÿ“ฆ What you get back Each record written to Supabase (and the Apify dataset): ```json { "unique_reference_number": "SC012345", "registered_provider": "Bright Futures Care Ltd", "registered_provider_address": "12 Oak Street, Manchester, M1 1AB", "provision_sub_type": "Children's home", "home_type": "social and emotional difficulties", "home_capacity": "4", "responsible_individual": "Jane Smith", "registered_manager": "John Doe", "inspection_dates": "15 March 2024", "inspection_type": "Unannounced", "overall_experiences_and_progress": "Good", "help_and_protection": "Good", "leadership_and_management": "Outstanding", "date_of_last_inspection": "10 September 2023", "overall_judgement_at_last_inspection": "Good", "enforcement_action_since_last_inspection": "None", "inspectors": "[{\"name\": \"Sarah Jones\", \"role\": \"Social Care Regulatory Inspector\"}]", "pdf_url": "https://files.ofsted.gov.uk/v1/file/..." } ``` Also downloadable as **JSON, CSV, Excel, or HTML** from the run's **Storage** tab โ€” or live via the Apify API. *** ### ๐Ÿ“‹ Input | Field | Type | Required | Default | Description | |---|---|---|---|---| | `start_urls` | Array | Yes | โ€” | One or more Ofsted search page URLs | | `apify_api_token` | String | Yes | โ€” | Your Apify API token (used to call the Ofsted scraper) | | `ofsted_actor_id` | String | Yes | `UNmCLFqfH6zXa3Mfc` | Actor ID of the underlying Ofsted scraper | | `supabase_url` | String | Yes | โ€” | Your Supabase project URL (`https://xxxx.supabase.co`) | | `supabase_api_key` | String | Yes | โ€” | Supabase service role or anon key | | `supabase_table` | String | Yes | `ofsted_inspections` | Target table name in Supabase | | `latest_report_date_start` | String | No | โ€” | Filter from this date (`DD-MM-YYYY`) | | `latest_report_date_end` | String | No | โ€” | Filter up to this date (`DD-MM-YYYY`) | | `only_latest_inspection` | Boolean | No | `true` | Return only the most recent inspection per provider | | `include_unsupported` | Boolean | No | `false` | Include providers with unsupported inspection types | | `max_depth` | Integer | No | `3` | Crawl depth for the underlying Ofsted scraper | *** ### ๐Ÿ—„ Supabase table setup Run this SQL once in your Supabase SQL editor before the first run: ```sql CREATE TABLE ofsted_inspections ( unique_reference_number TEXT NOT NULL PRIMARY KEY, pdf_url TEXT, registered_provider TEXT, registered_provider_address TEXT, provision_sub_type TEXT, responsible_individual TEXT, registered_manager TEXT, inspection_dates TEXT, inspection_type TEXT, overall_experiences_and_progress TEXT, help_and_protection TEXT, leadership_and_management TEXT, date_of_last_inspection TEXT, overall_judgement_at_last_inspection TEXT, enforcement_action_since_last_inspection TEXT, inspectors JSONB, home_capacity TEXT, home_type TEXT ); ``` The `unique_reference_number` primary key is what enables upserts โ€” re-running updates existing rows instead of inserting duplicates. *** ### ๐Ÿ’ก Use cases - **Regulatory monitoring** โ€” automatically track newly published inspection outcomes for children's homes and social care providers. - **Quality dashboards** โ€” sync Ofsted ratings into Supabase and power a live Metabase, Grafana, or Retool dashboard โ€” no manual CSV imports. - **Compliance alerting** โ€” run on a schedule; query Supabase to detect rating changes or new enforcement actions since the last sync. - **Research & due diligence** โ€” aggregate inspection histories across hundreds of providers for SQL/BI analysis. - **Replace Make/Zapier pipelines** โ€” eliminate the middleware layer and per-operation costs by keeping the pipeline on Apify. *** ### โ“ FAQ **Why do I need my own Apify API token?** This Actor orchestrates the [Ofsted Reports Data Scraper](https://apify.com/alkausari_mujahid/ofsted-reports-data-scraper) via the Apify API โ€” that scraper is what actually extracts data from the PDFs. Your token authenticates that call. It's marked as a secret and never logged. **Do I need to create the Supabase table myself?** Yes โ€” use the SQL above. The Actor only writes into an existing table; it does not create one. **Should I use the `service_role` or `anon` key?** Use `service_role` if your table has Row Level Security enabled; the anon key may block inserts. **Can I run this on a schedule?** Yes โ€” use the Apify **Schedule** feature. Each run upserts new and updated records, leaving unchanged rows untouched. Ofsted typically publishes inspection batches on Tuesdays and Thursdays. **What if a run fails halfway?** Re-run the Actor. The upsert ensures already-processed records are updated, not duplicated โ€” no data is lost. **Is this legal?** Ofsted publishes inspection reports as public information under the [Open Government Licence v3.0](https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/). This Actor accesses only publicly visible report data. Handle any personal data in reports in accordance with UK GDPR. *** ### ๐Ÿ“ฎ Support Bugs, feature requests, or custom database targets (PostgreSQL, BigQuery, Airtable) โ€” open an issue on Apify or email ****. *** Built by **Alkausari M**. This Actor is independent and not affiliated with, endorsed by, or sponsored by Ofsted or His Majesty's Government. Ofsted inspection data is published under the Open Government Licence v3.0. # Actor input Schema ## `start_urls` (type: `array`): A search URLs from reports.ofsted.gov.uk ## `latest_report_date_start` (type: `string`): Filter inspections from this date (DD-MM-YYYY) ## `latest_report_date_end` (type: `string`): Filter inspections up to this date (DD-MM-YYYY) ## `only_latest_inspection` (type: `boolean`): Returns only the latest inspection per URN ## `include_unsupported` (type: `boolean`): Include unsupported inspection types in results for later processing. ## `max_depth` (type: `integer`): Keep it always 3 otherwise if you want to process PDFs URLs directly then set it to 1. Maximum crawl depth for the Ofsted actor ## `apify_api_token` (type: `string`): The Apify API token of your account where the Ofsted Data Scraper Scraper is installed ## `ofsted_actor_id` (type: `string`): The actor ID for the Ofsted Reports Data scraper ## `supabase_url` (type: `string`): Your Supabase project URL (e.g. https://xxxx.supabase.co) ## `supabase_api_key` (type: `string`): Use the service\_role key if Row Level Security is enabled on your table (recommended); the anon key may block inserts. ## `supabase_table` (type: `string`): Name of the table in your Supabase database to upsert into. Must exist before the run (see the README for the CREATE TABLE statement). ## Actor input object example ```json { "start_urls": [ { "url": "https://reports.ofsted.gov.uk/search?q=&level_1_types=3&level_2_types%5B0%5D=11&status%5B0%5D=1&start=0&rows=10" } ], "only_latest_inspection": true, "include_unsupported": false, "max_depth": 3, "ofsted_actor_id": "UNmCLFqfH6zXa3Mfc", "supabase_table": "ofsted_inspections" } ``` # Actor output Schema ## `results` (type: `string`): No description # API You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup. ## JavaScript example ```javascript import { ApifyClient } from 'apify-client'; // Initialize the ApifyClient with your Apify API token // Replace the '' with your token const client = new ApifyClient({ token: '', }); // Prepare Actor input const input = { "start_urls": [ { "url": "https://reports.ofsted.gov.uk/search?q=&level_1_types=3&level_2_types%5B0%5D=11&status%5B0%5D=1&start=0&rows=10" } ] }; // Run the Actor and wait for it to finish const run = await client.actor("alkausari_mujahid/sync-ofsted-reports-data-with-supabase").call(input); // Fetch and print Actor results from the run's dataset (if any) console.log('Results from dataset'); console.log(`๐Ÿ’พ Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`); const { items } = await client.dataset(run.defaultDatasetId).listItems(); items.forEach((item) => { console.dir(item); }); // ๐Ÿ“š Want to learn more ๐Ÿ“–? Go to โ†’ https://docs.apify.com/api/client/js/docs ``` ## Python example ```python from apify_client import ApifyClient # Initialize the ApifyClient with your Apify API token # Replace '' with your token. client = ApifyClient("") # Prepare the Actor input run_input = { "start_urls": [{ "url": "https://reports.ofsted.gov.uk/search?q=&level_1_types=3&level_2_types%5B0%5D=11&status%5B0%5D=1&start=0&rows=10" }] } # Run the Actor and wait for it to finish run = client.actor("alkausari_mujahid/sync-ofsted-reports-data-with-supabase").call(run_input=run_input) # Fetch and print Actor results from the run's dataset (if there are any) print("๐Ÿ’พ Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"]) for item in client.dataset(run["defaultDatasetId"]).iterate_items(): print(item) # ๐Ÿ“š Want to learn more ๐Ÿ“–? Go to โ†’ https://docs.apify.com/api/client/python/docs/quick-start ``` ## CLI example ```bash echo '{ "start_urls": [ { "url": "https://reports.ofsted.gov.uk/search?q=&level_1_types=3&level_2_types%5B0%5D=11&status%5B0%5D=1&start=0&rows=10" } ] }' | apify call alkausari_mujahid/sync-ofsted-reports-data-with-supabase --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=alkausari_mujahid/sync-ofsted-reports-data-with-supabase", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "Sync Ofsted Reports Data with Supabase", "description": "Pulls Ofsted children's home inspection data from PDF reports, deduplicates by URN, and upserts directly into your Supabase table. Filter by date range, schedule daily runs, and feed dashboards or compliance workflows โ€” no Make, no Zapier, no glue code needed.", "version": "0.0", "x-build-id": "Wk8Zn5J6RjrC3njgQ" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/alkausari_mujahid~sync-ofsted-reports-data-with-supabase/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-alkausari_mujahid-sync-ofsted-reports-data-with-supabase", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } }, "/acts/alkausari_mujahid~sync-ofsted-reports-data-with-supabase/runs": { "post": { "operationId": "runs-sync-alkausari_mujahid-sync-ofsted-reports-data-with-supabase", "x-openai-isConsequential": false, "summary": "Executes an Actor and returns information about the initiated run in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/runsResponseSchema" } } } } } } }, "/acts/alkausari_mujahid~sync-ofsted-reports-data-with-supabase/run-sync": { "post": { "operationId": "run-sync-alkausari_mujahid-sync-ofsted-reports-data-with-supabase", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } } }, "components": { "schemas": { "inputSchema": { "type": "object", "required": [ "start_urls", "apify_api_token", "ofsted_actor_id", "supabase_url", "supabase_api_key", "supabase_table" ], "properties": { "start_urls": { "title": "Start URLs", "type": "array", "description": "A search URLs from reports.ofsted.gov.uk", "default": [ { "url": "https://reports.ofsted.gov.uk/search?q=&level_1_types=3&level_2_types%5B0%5D=11&status%5B0%5D=1&start=0&rows=10" } ], "items": { "type": "object", "required": [ "url" ], "properties": { "url": { "type": "string", "title": "URL of a web page", "format": "uri" } } } }, "latest_report_date_start": { "title": "Report Date From", "type": "string", "description": "Filter inspections from this date (DD-MM-YYYY)" }, "latest_report_date_end": { "title": "Report Date To", "type": "string", "description": "Filter inspections up to this date (DD-MM-YYYY)" }, "only_latest_inspection": { "title": "Only Latest Inspections per URN", "type": "boolean", "description": "Returns only the latest inspection per URN", "default": true }, "include_unsupported": { "title": "Include Unsupported PDFs", "type": "boolean", "description": "Include unsupported inspection types in results for later processing.", "default": false }, "max_depth": { "title": "Max Depth", "minimum": 1, "type": "integer", "description": "Keep it always 3 otherwise if you want to process PDFs URLs directly then set it to 1. Maximum crawl depth for the Ofsted actor", "default": 3 }, "apify_api_token": { "title": "Apify API Token", "type": "string", "description": "The Apify API token of your account where the Ofsted Data Scraper Scraper is installed" }, "ofsted_actor_id": { "title": "Ofsted Actor ID", "type": "string", "description": "The actor ID for the Ofsted Reports Data scraper", "default": "UNmCLFqfH6zXa3Mfc" }, "supabase_url": { "title": "Supabase URL", "type": "string", "description": "Your Supabase project URL (e.g. https://xxxx.supabase.co)" }, "supabase_api_key": { "title": "Supabase API Key", "type": "string", "description": "Use the service_role key if Row Level Security is enabled on your table (recommended); the anon key may block inserts." }, "supabase_table": { "title": "Supabase Table Name", "type": "string", "description": "Name of the table in your Supabase database to upsert into. Must exist before the run (see the README for the CREATE TABLE statement).", "default": "ofsted_inspections" } } }, "runsResponseSchema": { "type": "object", "properties": { "data": { "type": "object", "properties": { "id": { "type": "string" }, "actId": { "type": "string" }, "userId": { "type": "string" }, "startedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "finishedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "status": { "type": "string", "example": "READY" }, "meta": { "type": "object", "properties": { "origin": { "type": "string", "example": "API" }, "userAgent": { "type": "string" } } }, "stats": { "type": "object", "properties": { "inputBodyLen": { "type": "integer", "example": 2000 }, "rebootCount": { "type": "integer", "example": 0 }, "restartCount": { "type": "integer", "example": 0 }, "resurrectCount": { "type": "integer", "example": 0 }, "computeUnits": { "type": "integer", "example": 0 } } }, "options": { "type": "object", "properties": { "build": { "type": "string", "example": "latest" }, "timeoutSecs": { "type": "integer", "example": 300 }, "memoryMbytes": { "type": "integer", "example": 1024 }, "diskMbytes": { "type": "integer", "example": 2048 } } }, "buildId": { "type": "string" }, "defaultKeyValueStoreId": { "type": "string" }, "defaultDatasetId": { "type": "string" }, "defaultRequestQueueId": { "type": "string" }, "buildNumber": { "type": "string", "example": "1.0.0" }, "containerUrl": { "type": "string" }, "usage": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "integer", "example": 1 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } }, "usageTotalUsd": { "type": "number", "example": 0.00005 }, "usageUsd": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "number", "example": 0.00005 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } } } } } } } } } ```