OSFI · Schema

OSFI FINDAT regulatory-return data point (calendar-month return series)

Derived from the live CKAN datastore field list returned by GET https://open.canada.ca/data/en/api/3/action/datastore_search?resource_id=d0f6040e-671c-4301-a235-e9e7ba164604&limit=1 on 2026-07-25. Every column OSFI publishes is bilingual (English/French pairs) and typed `text` by the datastore, including the measure value — consumers must cast numerics themselves.

InsuranceCanadaRegulatorLife InsuranceProperty and CasualtyFinancial RegulationPrudential SupervisionOpen DataRisk DataMarket InfrastructureBankingBasel IIICapital AdequacyRegulatory ReportingPensions

Properties

Name	Type	Description
_id	integer	CKAN datastore surrogate row id; not an OSFI identifier.
Calendar Year/Annee civile	string
Calendar Month/Mois civil	string
Id	string
Total All Banks/Total Industry Groups/FIs	string
Total Banques/Total des groupe sectoriel/IFFs	string
Industry Group	string
Groupe Sectoriel	string
Return/Releve	string
Return Title	string
Titre du releve	string
Data Point Address/Adresse de point de donnee	string
Data Point Address Label	string
Libelle de l'adresse du point de donnees	string
FI Inactive Date/Date d'inactivite IFF	string
Measure Value/Valeur de mesure	string

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://raw.githubusercontent.com/api-evangelist/osfi/refs/heads/main/json-schema/osfi-financial-return-datapoint-monthly.json",
  "title": "OSFI FINDAT regulatory-return data point (calendar-month return series)",
  "description": "Derived from the live CKAN datastore field list returned by GET https://open.canada.ca/data/en/api/3/action/datastore_search?resource_id=d0f6040e-671c-4301-a235-e9e7ba164604&limit=1 on 2026-07-25. Every column OSFI publishes is bilingual (English/French pairs) and typed `text` by the datastore, including the measure value \u2014 consumers must cast numerics themselves.",
  "x-source": {
    "resource_id": "d0f6040e-671c-4301-a235-e9e7ba164604",
    "records": 1555044,
    "probed": "2026-07-25",
    "method": "derived"
  },
  "type": "object",
  "properties": {
    "_id": {
      "type": "integer",
      "x-ckan-type": "int",
      "description": "CKAN datastore surrogate row id; not an OSFI identifier."
    },
    "Calendar Year/Annee civile": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Calendar Month/Mois civil": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Id": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Total All Banks/Total Industry Groups/FIs": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Total Banques/Total des groupe sectoriel/IFFs": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Industry Group": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Groupe Sectoriel": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Return/Releve": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Return Title": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Titre du releve": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Data Point Address/Adresse de point de donnee": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Data Point Address Label": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Libelle de l'adresse du point de donnees": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "FI Inactive Date/Date d'inactivite IFF": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Measure Value/Valeur de mesure": {
      "type": "string",
      "x-ckan-type": "text"
    }
  },
  "additionalProperties": true
}

Work with this as data

Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for schemas

4 MCP tools reach this

find_json_schemasBrowse and filter every JSON Schema in the catalog.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools →

Call it yourself

curl for this page

This JSON Schema

curl "https://apis.io/api/v1/json-schemas/osfi-financial-return-datapoint-monthly"

All schemas

curl "https://apis.io/api/v1/json-schemas?limit=25"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.