creating-bc-custom-api
Creates custom API pages (CRUD) and API queries (read-only joins) in AL for Business Central. Use when exposing custom tables, adding business logic to APIs, creating reporting endpoints, or joining multiple tables for external consumption.
100
—
Does it follow best practices?
Impact
100%
1.81xAverage score across 3 eval scenarios
—
The risk profile of this skill
Evaluation results
API Query joining header and lines with aggregation
100%
20%Power BI Dashboard Integration: Project Budget API
Read-only API page for Power BI reporting
Write operations disabled
100%
100%
ReadCommitted isolation
0%
100%
SystemId OData key
100%
100%
API version v2.0
100%
100%
EntityCaption
100%
100%
EntitySetCaption
100%
100%
camelCase EntityName
100%
100%
camelCase EntitySetName
100%
100%
Alphanumeric field names
100%
100%
lastModifiedDateTime field
100%
100%
PM API naming convention
0%
100%
camelCase field API names
100%
100%
No OData UI endpoint
100%
100%
100%
69%Rental Machine API Integration
CRUD API page for a custom BC table
PageType = API
100%
100%
ODataKeyFields = SystemId
0%
100%
DelayedInsert = true
100%
100%
OnInsertRecord calls Rec.Insert(true)
0%
100%
OnInsertRecord exits with false
0%
100%
lastModifiedDateTime field
0%
100%
lastModifiedDateTime is non-editable
0%
100%
EntityCaption present
0%
100%
EntitySetCaption present
0%
100%
camelCase entity and field names
50%
100%
Alphanumeric-only field names
40%
100%
APIVersion = 'v2.0'
0%
100%
Object name prefix convention
40%
100%
- Repository
- emgreppi/Business-Central-AI-Skill
- Commit
52f8705
- Evaluated
- Agent
- Claude Code
- Model
- Claude Sonnet 4.6
Table of Contents
Is this your skill?
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.