Deploy the Promotion BO API
What this does
Turns on the Consumer Goods Cloud TPM Promotion Business Object (BO) API in a
Salesforce org, interviews the user for
one custom Workflow Step to add to
the promotion pipeline, generates and deploys that Apex class, registers it
against a BO API entity, wires it into the customer's chosen subset of
workflows, then proves the whole path end-to-end via
three REST endpoints:
POST /services/apexrest/<prefix>/promotions/initialize
POST /services/apexrest/<prefix>/promotions/ingest
GET /services/apexrest/<prefix>/promotions/status?importId=...
It is meant for
headless delivery: point it at an org, answer the interview,
and the skill installs the step and verifies it. The Promotion BO API ships in
the CGCloud
managed package (namespace
released,
dev/beta). Every Apex identifier, object/field API name, and REST URL is derived
from the detected package prefix at runtime — this skill never hard-codes it.
is out of scope here (a follow-up skill covers it). Detailed runbooks
for the write and smoke phases live under
:
references/conventions-and-payload-rules.md
— sales-org partitioning, schema-first contract derivation, and the eight cross-workflow payload rules R1–R8.
references/generate-and-wire.md
— Phase 5a (generate + deploy the class) and Phase 5b (register + wire the step), with the full .
references/smoke-and-verify.md
— Phase 6 (contract derivation, payload materialization, create/update/copy legs + verification).
references/reference-example-set-comment-value.md
— the shipped preset (assets at assets/set-comment-value/
).
Inputs to collect first
Ask before starting; do not guess.
- Org alias — the alias of the target org. Required.
- Sales org — required pre-parameter, default . Must be 4 chars, uppercase (mirrors
TPMSetupData.validateSalesOrg
). Every downstream lookup (promotion template, tactic template, anchor account, product filter criteria, SKUs) is scoped to this sales org — see references/conventions-and-payload-rules.md
("Sales-org partitioning").
- Yes to seeding? — Phase 3a fetches the packaged BO API seed and asks for confirmation before inserting ~232 rows across 8 objects. Offer for CI callers.
- Dry run? — runs Phases 1, 2, 3a-preview, the Phase 5 interview, and a validate-only deploy. Writes nothing.
What the customization is gets collected in Phase 5's interview, once the
framework state is known.
Find the namespace first
The prefix depends on the installed build — detect it, do not guess. Released
package →
; dev/beta →
; source-deployed → no prefix.
bash
sf data query --target-org <alias> \
--query "SELECT NamespacePrefix FROM ApexClass WHERE Name = 'TPMSetupData'" --json
Read
records[0].NamespacePrefix
and bind three variables used everywhere below:
- — Apex references: / / empty.
- — object/field API names: / / empty.
- — REST paths: / / empty.
Every Apex call is
${PREFIX_DOT}ClassName.method(...)
; every SOQL object/field is
; every REST URL is
/services/apexrest${URL_NS}/promotions/<endpoint>
. Substitute at run time.
Phase 1 — Preflight
Run these and stop on the first failure.
- ; (only if running shipped scripts).
sf org display --target-org <alias> --json
— confirm reachable, capture + org id (for display/logging only). Every REST call in later phases goes through , which uses the CLI's stored session — this skill never extracts the access token.
- Validate the sales org locally: length 4, uppercase, non-blank (mirrors
TPMSetupData.validateSalesOrg
). Fail fast instead of surfacing an Apex stack trace.
- TPM entitlement (Permission Set License) — the TPM app is licensed through the Permission Set License ("CGC Retail and Trade Promotion Management"); there is no UserLicense. Check the running user's PSL assignment:
sql
SELECT Id FROM PermissionSetLicenseAssign
WHERE Assignee.Username = '<running-user-name>'
AND PermissionSetLicense.DeveloperName = 'CGCRetailAndTPMMgmtPsl'
On scratch/dev-hub the PSL may be legitimately unassigned; detect env with SELECT OrganizationType, IsSandbox FROM Organization
:
OrganizationType = 'Developer Edition'
OR and empty → warn ("permset gate below is the real check"), continue.
- Any other org shape and empty → stop ("TPM Permission Set License not assigned to the running user").
- Running-user permission set (TPM Admin persona) — the setup needs a permission set granting the TPM Master Data Admin persona. The shipped permset is (packaged; is the bare name regardless of namespace), but customers frequently clone it under their own name — so treat a miss as "ask", not "fail". Take from
sf org display ... .result.username
:
sql
SELECT PermissionSet.Name, PermissionSet.Label FROM PermissionSetAssignment
WHERE Assignee.Username = '<running-user-name>'
AND (PermissionSet.Name = 'TPM_Master_Data_Admin'
OR PermissionSet.Label LIKE '%TPM%Master Data Admin%')
Match → proceed. No match → do not hard-fail on the name: show sf org assign permset --name TPM_Master_Data_Admin --target-org <alias>
as the default option, but also ask the user to confirm whether they already hold an equivalent (possibly cloned/renamed) permission set for the TPM admin persona. Pause, wait for a cloned-permset confirmation or the assignment, then re-query. Proceed only once admin access is confirmed.
- Namespace discovery (above).
Phase 2 — Verify BO API framework state
Read-only; tells you whether Phase 3 needs to run. All three counts MUST be
scoped to
— the framework rows are sales-org-partitioned.
bash
# 1. Workflow rows for this sales org (expect 4: create/update/copy/derive)
sf data query --target-org <alias> --json --query "
SELECT Name FROM ${PREFIX_UNDER}BO_API_Workflow__c
WHERE ${PREFIX_UNDER}BO_API__r.Name = 'Promotion'
AND ${PREFIX_UNDER}BO_API__r.${PREFIX_UNDER}Sales_Org__c = '<salesOrg>'"
# 2. Step rows for this sales org
sf data query --target-org <alias> --json --query "
SELECT COUNT(Id) FROM ${PREFIX_UNDER}BO_API_Workflow_Step__c
WHERE ${PREFIX_UNDER}Sales_Org__c = '<salesOrg>'"
# 3. Junction rows whose parent workflow belongs to a Promotion BO API for this sales org
sf data query --target-org <alias> --json --query "
SELECT COUNT(Id) FROM ${PREFIX_UNDER}BO_API_Workflow_Workflow_Step__c
WHERE ${PREFIX_UNDER}BO_API_Workflow__r.${PREFIX_UNDER}BO_API__r.Name = 'Promotion'
AND ${PREFIX_UNDER}BO_API_Workflow__r.${PREFIX_UNDER}BO_API__r.${PREFIX_UNDER}Sales_Org__c = '<salesOrg>'"
- Zero workflow rows → fresh for this sales org, Phase 3 will seed.
- Full state (4 workflow rows
create/update/copy/derive
; >0 step + junction rows) → Phase 3 is a no-op for this sales org (still run for idempotency; 3a shows zero net-new).
- Partial state → error; stop, report which rows are missing. A human inspects first.
Phase 3a — Preview the default BO API seed (fetch + confirm)
The workflows/steps/junctions/entities/input-structures ship as CSVs inside the
packaged
static resource;
reads and
upserts them. Before running it, show the user what will land.
- Locate the resource:
bash
sf data query --target-org <alias> --json --query "
SELECT Id, Name, NamespacePrefix, SystemModStamp, BodyLength
FROM StaticResource WHERE Name = 'TPMSetupData'"
Zero rows → stop ("TPMSetupData static resource not found — is the CGCloud package installed?"). Multiple rows → prefer the one whose matches Phase 1; if prefixes disagree, stop and ask.
- Retrieve + expand the resource cross-platform via SFDX — use , which unpacks a zip StaticResource into a folder on every OS (no , no — isn't present on Windows by default). Retrieve into a dedicated subproject so the read-only managed resource never mixes into the Phase-5a deploy tree (
./.promotion-bo-api-deploy/force-app
, which is what gets deployed back):
bash
mkdir -p ./.promotion-bo-api-deploy/setup-data/force-app/main/default
printf '{ "packageDirectories": [{ "path": "force-app", "default": true }], "sourceApiVersion": "60.0" }' \
> ./.promotion-bo-api-deploy/setup-data/sfdx-project.json
( cd ./.promotion-bo-api-deploy/setup-data && sf project retrieve start \
--metadata "StaticResource:${PREFIX_UNDER}TPMSetupData" --target-org <alias> --json )
Non-success → stop, print errors.
- SFDX expands the zip to
./.promotion-bo-api-deploy/setup-data/force-app/main/default/staticresources/${PREFIX_UNDER}TPMSetupData/BOApi/
. it. Expected: , , 0_BO_API_Output_Entity__c.csv
, , 0_BO_API_Workflow_Entity__c.csv
, 0_BO_API_Workflow_Step__c.csv
, 0_BO_API_Workflow_Workflow_Step__c.csv
, 0_BO_API_Step_Input_Structure__c.csv
, . Any missing → stop, print the delta.
- Confirm each target sObject exists:
sf sobject describe --sobject '${PREFIX_UNDER}BO_API_Workflow__c' --target-org <alias> > /dev/null
(etc.). Any describe failure → stop (package partially installed).
- Show a summary (row counts per object; total ~232 rows across 8 objects; "upsert on Unique_Key__c — re-running is idempotent"), plus the first 3 rows of and
0_BO_API_Workflow_Step__c.csv
with / substituted.
- Wait for confirmation unless . "no"/blank → abort clean, point at
./.promotion-bo-api-deploy/setup-data/force-app/main/default/staticresources/${PREFIX_UNDER}TPMSetupData/BOApi/
.
- On → stop here; do not run 3b.
Phase 3b — Apply the default seed
Only after 3a confirmation.
PHASE3_START=$(date -u +%FT%TZ)
.
- Run metadata-wizard setup via anon Apex:
${PREFIX_DOT}TPMSetupData.setupMetadataWizard('<salesOrg>');
→ sf apex run --target-org <alias> --file ./.promotion-bo-api-deploy/setup-metadata-wizard.apex
.
- Wait for the whole batch chain.
GenericDemoSetupDataBatch
self-chains via ; polling a single job id misses children. Poll by class:
bash
sf data query --target-org <alias> --json --query "
SELECT COUNT() FROM AsyncApexJob
WHERE ApexClass.Name = 'GenericDemoSetupDataBatch'
AND CreatedDate >= ${PHASE3_START}
AND Status NOT IN ('Completed','Failed','Aborted')"
Sleep 5s between polls; break when count is zero for two consecutive polls (covers the gap between a parent's and the child's row appearing).
- Final check — every child succeeded (
SELECT Id, Status, NumberOfErrors, ExtendedStatus FROM AsyncApexJob WHERE ApexClass.Name = 'GenericDemoSetupDataBatch' AND CreatedDate >= ${PHASE3_START}
). Any // → stop, print .
- Repeat 2–4 for
${PREFIX_DOT}TPMSetupData.setupBOApi('<salesOrg>');
.
Phase 4 — Verify the BO API framework is on
Re-run the Phase 2 queries. Expect 4
rows
(
/
/
/
, uniqueness on
), ≥46
rows, ≥54
BO_API_Workflow_Workflow_Step__c
junction
rows. Anything short → stop, print what's missing. Never claim success while a
component failed.
Phase 5 — Interview: what does the user want to customize?
The framework is now on. The customization is user-supplied — do not skip
the interview; do not invent an answer. Print:
text
The Promotion BO API framework is installed. To add a custom step, tell me:
- Which BO API entity does it target? (e.g. Promotion or Tactic — I'll list the exact entities registered in your org)
- Which workflows should it fire in? (create, update, copy)
- What does it read from the ingest input?
- What does it write on the SObject or elsewhere?
- Any preconditions or side effects I should know about?
If you want a worked example, say "use the SetCommentValue reference" —
it copies the tactic input Comment onto Tactic.Comment__c.
5.1 — Answers to collect
| Field | Required | Notes |
|---|
| yes | PascalCase Apex class name + BO API Workflow Step . Unique across . |
| yes | BO API entity — MUST match a row queried live from ${PREFIX_UNDER}BO_API_Entity__c
(shared, not sales-org-partitioned); do not assume a fixed list. In a current org these include , , , , (plus the structures). Query the org and offer the actual rows. |
| yes | Non-empty subset of . is out of scope. |
| yes | Symbolic action string the class receives in . Convention: lowerCamelCase of . |
| yes (≥1) | JSON paths to read from , e.g. . |
| yes | JSON type of the input paths — , , , , . Drives the on each SIS row; a wrong value causes TransformationError: Expected <Type>
at ingest. Different types → run Phase 5b once per type group. |
| yes (≥1) | pairs; is the target API name without the namespace prefix (skill adds ), references an value / literal / computed expression. |
| yes | One-sentence step description → ${PREFIX_UNDER}Description__c
+ class docstring. |
| optional | Free-text guards before writing. |
| optional | Named packaged step to sort after; default . |
5.2 — Interview flow
- Preset shortcut. If
--preset set-comment-value
or the user says "use the SetCommentValue reference", load the answers from references/reference-example-set-comment-value.md
(assets/set-comment-value/interview-answers.json
) and skip the interactive interview. loads answers from a JSON file mirroring the 5.1 table (wins over ).
- Ask the questions one at a time (or as a block); do not proceed until every required field has a concrete value.
- Show the entity's writeable fields after the user names the entity:
bash
sf sobject describe --target-org <alias> --sobject '${PREFIX_UNDER}<Entity>__c' --json \
| jq -r '.fields[] | select(.updateable == true and .createable == true) | .name'
Any field must appear here; otherwise stop and ask for a different one (FLS is caller-scoped).
- Confirm the plan (recap Class/Entity/Workflows/Reads/Writes/Sort/Description → "Deploy + wire? [y/N]"). /blank → save answers to
./.promotion-bo-api-deploy/interview.json
and exit. → Phase 5a.
Phases 5a / 5b — Generate + deploy, register + wire
Runbook in
references/generate-and-wire.md
. In short: guard the class name for
idempotency; confirm target-field writeability; generate a namespace-agnostic
from the interview (reads
/
, derives the
prefix from
at runtime); show + confirm;
. Then, in one anon-Apex transaction, upsert one
(bare class name in
), one
BO_API_Workflow_Workflow_Step__c
junction per chosen workflow (never assume all three;
dropped), and the
BO_API_Step_Input_Structure__c
rows (RecordType per
). Both
upserts key on
(idempotent).
Phase 6 — Smoke test through the REST endpoints
Runbook in
references/smoke-and-verify.md
. Derive the payload contract per
invoked workflow from
BO_API_Step_Input_Structure__c
(schema-first), apply
rules R1–R8 from
references/conventions-and-payload-rules.md
, resolve every
reference in-sales-org, materialize
./out/smoke/{create,update,copy}.json
, then
run
initialize → ingest → poll status
for each chosen workflow. Verify via a
direct
BO_API_Transaction_Log__c
query (any row
→ fail) plus
an
field assertion against
./out/smoke/expected.json
. Update and
copy legs run only if the interview included them.
Phase 7 — Report
Short status: org, sales org, dry-run flag; namespace prefix; BO API seed rows
before/after (Phases 2 & 4); interview (preset name or resolved
,
,
,
,
); class deploy result +
workflow-step id + junction ids (1–3); smoke import ids per invoked workflow, all
with matching write assertions — or exactly which failed (SOQL,
expected, actual); manual follow-ups (
if clean).
Rules
- Never claim success while any
BO_API_Transaction_Log__c
row for the smoke import ids has Status__c != 'Calculated'
. is the terminal success state (R2); does NOT exist in the picklist.
- Never claim success while any assertion fails, or while any
GenericDemoSetupDataBatch
since the phase start is still running or failed.
- Stop on the first failed preflight or verify check; report the exact failure.
- Never hard-code the namespace prefix — compose every Apex/SOQL/REST reference from the Phase-1 detection.
- Never invent Apex method signatures — use what the packaged / objects and the shipping REST endpoints declare.
- The seeded BO API metadata is packaged content — preview it and get user confirmation before invoking .
- Never invent an interview answer. Absent a user and any /, stop and print the questions.
- Never wire a workflow the interview did not include. // are individually opt-in; is always excluded.
- Never compose a smoke payload from a hard-coded template — derive accepted paths per workflow from
BO_API_Step_Input_Structure__c
and validate user input against that contract first.
- Never resolve a reference value without the sales-org filter. A record under a different sales org is not valid for this invocation.