workforce_profile_files

The BC Stats Work Force Profile CSV files (B.C. Public Service representation statistics for 2018, 2020, 2022 and 2024): employee counts by ministry, designated group representation by occupation and region, comparison with the available workforce, hiring, flow, leadership and progress tables. Returns each file's title, columns, row count and size, the profile year, and a ref. To read the rows call fetch_record with that ref and upstream true. Aggregates by ministry only; small groups are suppressed by BC Stats.

Cost: 1 unit of your allowance (see Rate limits).

ParametersCopy Anchor Link

• year (integer, optional): min 2018, max 2040
• table (Comparison, EmpCounts, Flow, Hiring, Ind_Progress, Leadership, MinistryKey, Rep_Occ_Rgn, optional)
• query (string, optional): min length 1, max length 60
• limit (integer, optional): min 1, max 50, default 30

RESTCopy Anchor Link

curl -X POST https://api.bcmcp.ca/v1/tools/workforce_profile_files \
  -H "Authorization: Bearer $BCDATA_KEY" \
  -H "Content-Type: application/json" \
  -d '{}'

MCPCopy Anchor Link

Call the tool workforce_profile_files with these arguments. Over raw JSON-RPC:

curl -X POST https://api.bcmcp.ca/mcp \
  -H "Authorization: Bearer $BCDATA_KEY" \
  -H "Content-Type: application/json" \
  -H "Accept: application/json, text/event-stream" \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"workforce_profile_files","arguments":{}}}'

What comes backCopy Anchor Link

Every answer is the same envelope, over REST and over MCP: available, data, citations, freshness and notes. See Citations and freshness.