OSFI · Schema

OSFI FINDAT regulatory-return data point (fiscal-quarter 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=f3ddcfbc-a852-4dee-be3c-5b08864c9afe&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.
Fiscal Year/Annee fiscale	string
Fiscal Quarter	string
Trimestre fiscal	string
Id	string
Total Life Insurance Companies/FIs	string
Total Societes d'assurance-vie/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.json",
  "title": "OSFI FINDAT regulatory-return data point (fiscal-quarter 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=f3ddcfbc-a852-4dee-be3c-5b08864c9afe&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": "f3ddcfbc-a852-4dee-be3c-5b08864c9afe",
    "records": 531347,
    "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."
    },
    "Fiscal Year/Annee fiscale": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Fiscal Quarter": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Trimestre fiscal": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Id": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Total Life Insurance Companies/FIs": {
      "type": "string",
      "x-ckan-type": "text"
    },
    "Total Societes d'assurance-vie/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"

All schemas

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

Discovery needs no key. Ratings and market analysis are Pro.

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.