Xpp Data Access Apis

Choose and use the right D365FO data-access API when a plain `select` will not do — the SysDa fluent API, the AOT Query/QueryRun object model, and direct SQL. Invoke when the user asks about dynamic queries, building a query at runtime, QueryBuildDataSource/QueryBuildRange, SysDa, or executing raw SQL from X++.

49 stars 26 forksAI, LLMs & Agents

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add dynamics365ninja/d365fo-cli --skill xpp-data-access-apis
Manual install
git clone --depth 1 https://github.com/dynamics365ninja/d365fo-cli.git /tmp/d365fo-cli
mkdir -p ~/.claude/skills
cp -r /tmp/d365fo-cli/skills/anthropic/xpp-data-access-apis ~/.claude/skills/xpp-data-access-apis

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

> ⛔ **NEVER write X++ AOT XML files directly** via PowerShell, terminal file commands (`Set-Content`, `Out-File`, `New-Item`), editor write tools, or any raw text approach. The XML schema is proprietary. **ALWAYS use `d365fo generate …` commands** to produce correct AOT XML. If `d365fo` is unavailable in PATH, stop and ask the user to install it.

# Data-access APIs beyond `select`

> Three alternatives to the `select` statement, in the order you should reach for
> them. `select` stays the default — it is the only one with compile-time field
> validation. Everything below trades that away for something specific.

| API | Reach for it when | Cost |
|---|---|---|
| `select` / `while select` | the shape is known at compile time | — |
| **AOT `Query` / `QueryRun`** | a form or report binds to it, a user edits the filter, or several consumers share it | no compile-time field checking |
| **SysDa** | the shape depends on runtime conditions and you are writing framework code | verbose; easy to get the object graph wrong |
| **Direct SQL** | a read X++ genuinely cannot express efficiently | no company/partition filter, needs a permission assert |

Full `select` grammar: `d365fo knowledge get xpp-database-queries`.

## 1. AOT Query object model

- `Query` holds the structure; `QueryBuildDataSource` (QBDS) is one table;
  `QueryBuildRange` is one filter; `QueryRun` executes and iterates.
- Add a range **idempotently** with `SysQuery::findOrCreateRange(qbds, fieldNum(…))`.
Read the full skill on GitHub

Details

Skill name
xpp-data-access-apis
Path
skills/anthropic/xpp-data-access-apis/SKILL.md
Repo updated
16 November 2026

FAQ

What does the Xpp Data Access Apis skill do?

Choose and use the right D365FO data-access API when a plain `select` will not do — the SysDa fluent API, the AOT Query/QueryRun object model, and direct SQL. Invoke when the user asks about dynamic queries, building a query at runtime, QueryBuildDataSource/QueryBuildRange, SysDa, or executing raw SQL from X++.

How do I install the Xpp Data Access Apis skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add dynamics365ninja/d365fo-cli --skill xpp-data-access-apis. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Xpp Data Access Apis popular?

It lives in dynamics365ninja/d365fo-cli, which has 49 GitHub stars and 26 forks.

Related skills

Analytics and Er

49

dynamics365ninja/d365fo-cli

Model the D365FO analytical and document-generation surfaces — aggregate measurements and the entity store, tiles/cues and KPIs, and Electronic Reporting (ER). Invoke when the user asks about a workspace tile, a KPI, an aggregate measurement, the entity store, Power BI content, or running/binding an ER format.

Data & Analytics26

Barcode Scanning

49

dynamics365ninja/d365fo-cli

Barcodes and scanner input in D365FO — printing vs scanning are unrelated code paths, GS1-128 application identifiers, item-barcode resolution, and where the platform parses a scan for you. Invoke when the user mentions barcodes, GS1, GTIN, SSCC, scanning, scanners, item barcodes, or barcode setup.

AI, LLMs & Agents26

Build Error Triage

49

dynamics365ninja/d365fo-cli

Turn a D365FO compiler, best-practice, or runtime error into the specific fix it calls for. Invoke when the user pastes a build log, an xppc message, a BP violation, or an infolog stack trace and asks what it means or how to fix it.

AI, LLMs & Agents26

Xpp Runtime Functions

49

dynamics365ninja/d365fo-cli

The ~170 predefined (run-time) X++ functions the compiler actually has — argument counts as the compiler enforces them, the optional trailing parameters the language reference presents as fixed, the variadic ones, and the AX 2012 names that are gone. Invoke when calling or debugging strFmt/subStr/conPeek/date2Str-style global functions, or an FN001/FN002 finding.

AI, LLMs & Agents26

Xpp Class and Method Rules

49

dynamics365ninja/d365fo-cli

Rules for X++ class declarations, method modifiers, parameter passing, constructors, and extension methods (separate from CoC). Invoke when authoring new classes, overrides, factory methods, or extension methods.

AI, LLMs & Agents26

Xpp Runtime Types

49

dynamics365ninja/d365fo-cli

Use the X++ runtime type surface correctly — collections and containers, utcdatetime and time zones, .NET interop, the Dict* reflection API, and macros. Invoke when the user asks about List/Map/Set/Struct/container, date and time zone handling, calling .NET from X++, runtime metadata, or macro libraries.

AI, LLMs & Agents26

Browse the most popular Claude skills, all ai, llms & agents skills, or write your own with the skills generator.