OSFI · Example Payload
Osfi Datastore Search Pc1 Example
Read PC1 P&C Core Financial Statement Return data points.
InsuranceCanadaRegulatorLife InsuranceProperty and CasualtyFinancial RegulationPrudential SupervisionOpen DataRisk DataMarket InfrastructureBankingBasel IIICapital AdequacyRegulatory ReportingPensions
Osfi Datastore Search Pc1 Example is an example object payload from OSFI, with 5 top-level fields. It illustrates the shape of data this provider's APIs accept or return.
Top-level fields
generatedmethoddescriptionrequestresponse
Example Payload
{
"generated": "2026-07-25",
"method": "searched",
"description": "Read PC1 P&C Core Financial Statement Return data points.",
"request": {
"method": "GET",
"url": "https://open.canada.ca/data/en/api/3/action/datastore_search?resource_id=d4c1d98d-c19e-4730-ab2d-6e64160351a7&limit=2",
"headers": {
"Accept": "application/json",
"User-Agent": "a browser User-Agent is required; the open.canada.ca WAF rejects default curl UAs with an HTML page under HTTP 200"
},
"auth": "none \u2014 anonymous"
},
"response": {
"status": 200,
"content_type": "application/json",
"body": {
"help": "https://open.canada.ca/data/en/api/3/action/help_show?name=datastore_search",
"success": true,
"result": {
"include_total": true,
"limit": 2,
"records_format": "objects",
"resource_id": "d4c1d98d-c19e-4730-ab2d-6e64160351a7",
"total_estimation_threshold": null,
"records": [
{
"_id": 2583670,
"Fiscal Year/Annee fiscale": "2026",
"Fiscal Quarter": "Q1 - 2026",
"Trimestre fiscal": "T1 - 2026",
"Id": "1000012",
"Total P&C Companies/FIs": "Total Canadian Property & Casualty",
"Total Societes d'assurance multirisque/IFFs": "Total soci\u00e9t\u00e9s d\u2019assurances multirisques canadiennes",
"Industry Group": "Canadian Property & Casualty",
"Groupe Sectoriel": "Assurances multirisques canadiennes",
"Return/Releve": "PC1",
"Return Title": "PC1 - P&C Core Financial Statement Return",
"Titre du releve": "PC1 - P&C Relev\u00e9 des \u00e9tats financiers de base",
"Data Point Address/Adresse de point de donnee": "P20100101",
"Data Point Address Label": "PC1: ASSETS:Cash and Cash Equivalents, Current Period, Total",
"Libelle de l'adresse du point de donnees": "PC1: ACTIF: Encaisse et quasi-esp\u00e8ces, Exercice courant, Total",
"FI Inactive Date/Date d'inactivite IFF": "9999-12-31",
"Measure Value/Valeur de mesure": "3682194.62"
},
{
"_id": 2583671,
"Fiscal Year/Annee fiscale": "2026",
"Fiscal Quarter": "Q1 - 2026",
"Trimestre fiscal": "T1 - 2026",
"Id": "1000012",
"Total P&C Companies/FIs": "Total Canadian Property & Casualty",
"Total Societes d'assurance multirisque/IFFs": "Total soci\u00e9t\u00e9s d\u2019assurances multirisques canadiennes",
"Industry Group": "Canadian Property & Casualty",
"Groupe Sectoriel": "Assurances multirisques canadiennes",
"Return/Releve": "PC1",
"Return Title": "PC1 - P&C Core Financial Statement Return",
"Titre du releve": "PC1 - P&C Relev\u00e9 des \u00e9tats financiers de base",
"Data Point Address/Adresse de point de donnee": "P20100103",
"Data Point Address Label": "PC1: ASSETS:Cash and Cash Equivalents, Prior Period, Total",
"Libelle de l'adresse du point de donnees": "PC1: ACTIF: Encaisse et quasi-esp\u00e8ces, Exercice pr\u00e9c\u00e9dent, Total",
"FI Inactive Date/Date d'inactivite IFF": "9999-12-31",
"Measure Value/Valeur de mesure": "3636300.16"
}
],
"fields": [
{
"id": "_id",
"type": "int"
},
{
"id": "Fiscal Year/Annee fiscale",
"type": "text"
},
{
"id": "Fiscal Quarter",
"type": "text"
},
{
"id": "Trimestre fiscal",
"type": "text"
},
{
"id": "Id",
"type": "text"
},
{
"id": "Total P&C Companies/FIs",
"type": "text"
},
{
"id": "Total Societes d'assurance multirisque/IFFs",
"type": "text"
},
{
"id": "Industry Group",
"type": "text"
},
{
"id": "Groupe Sectoriel",
"type": "text"
},
{
"id": "Return/Releve",
"type": "text"
},
{
"id": "Return Title",
"type": "text"
},
{
"id": "Titre du releve",
"type": "text"
},
{
"id": "Data Point Address/Adresse de point de donnee",
"type": "text"
},
{
"id": "Data Point Address Label",
"type": "text"
},
{
"id": "Libelle de l'adresse du point de donnees",
"type": "text"
},
{
"id": "FI Inactive Date/Date d'inactivite IFF",
"type": "text"
},
{
"id": "Measure Value/Valeur de mesure",
"type": "text"
}
],
"_links": {
"start": "/api/3/action/datastore_search?resource_id=d4c1d98d-c19e-4730-ab2d-6e64160351a7&limit=2",
"next": "/api/3/action/datastore_search?resource_id=d4c1d98d-c19e-4730-ab2d-6e64160351a7&limit=2&offset=2"
},
"total": 693693,
"total_was_estimated": false
}
}
}
}Work with this as data
Every example 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 examples
4 MCP tools reach this
find_examplesBrowse and filter every example 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.
Call it yourself
curl for this page
This example
curl "https://apis.io/api/v1/examples/osfi-datastore-search-pc1-example"
All examples
curl "https://apis.io/api/v1/examples?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.
A second provider on the same verified email joins the account you already have.