bcapi.ai

187 standard Business Central tables,
every W1 field, as OData v4 APIs.

A free, open-source extension that exposes 187 standard tables as ready-to-use API endpoints, localization-neutral, no custom development per table. Install it and start integrating.

App version 3.1.3.0 · API v3.1 · September 9, 2026 · What's new →
Designed forMicrosoft Dynamics 365 Business Central
187
Endpoints
9
Categories
135
Read / write
52
Read-only
v4
OData
01Install

Download the app. Upload it to Business Central. Assign a permission set.

One .app file, no dependencies, no setup page. Works on Business Central 2025 Wave 2 (v27.5) and later, in any localization.

Download the appv3.1.3.0 · .app

Install it in a sandbox first. The source is on GitHub if you prefer to build it yourself.

Step 1

Upload the extension

In Business Central, search for Extension Management, choose Manage → Upload Extension, pick the .app file, accept the terms and deploy. It takes a few minutes.

Step 2

Assign a permission set

Give the integration user OCPF - READ (every endpoint, GET) or OCPF - READ/WRITE (adds POST, PATCH and DELETE on the 135 editable endpoints), plus the standard permissions on the underlying BC tables.

Step 3

Call an endpoint

Authenticate with OAuth 2.0 (Microsoft Entra app registration) and GET any entity under the /v3.1/ base URL. The Getting Started guide has the full URL pattern and examples.

api.businesscentral.dynamics.com
# Base URL (replace the placeholders)
https://api.businesscentral.dynamics.com/v2.0/{tenantId}/{environment}
  /api/OnlyCopilotFans/ocpf_masterData/v3.1

# List customers
GET {base}/companies({companyId})/ocpfCustomers

# Filter, select, page
GET {base}/companies({companyId})/ocpfItems
    ?$filter=inventory gt 0&$select=no,description,inventory&$top=50

# Create a customer (OCPF - READ/WRITE)
POST {base}/companies({companyId})/ocpfCustomers
{ "no": "C-1001", "name": "Contoso Ltd." }

# Discover every entity and field in a category
GET {base}/$metadata

Permission sets included

OCPF - READ covers all 187 endpoints. OCPF - READ/WRITE covers the 135 editable ones.

Consumers also need the matching permissions on the base tables. The four Access Control endpoints additionally require SUPER or SECURITY to assign permission sets.