forcedotcom/sf-skills / skills/crm-analytics-wave-generate
crm-analytics-wave-generate
VerifiedUse to build a Wave Recipe, deploy a CRM Analytics dataset or dashboard, or author the full CRMA asset stack — apps, Wave Recipes (.wdpr), datasets, and dashboards — against a connected Salesforce org via REST and Metadata APIs, without CRM Analytics Studio or Dashboard Builder. TRIGGER when: user asks to build or create a Wave Recipe, generate a .wdpr or .wdpr-meta.xml, deploy a .wdash or .wapp, run a recipe or dataflowjob programmatically, upload CSV data via InsightsExternalData, validate a dataset schema with synthetic data, fetch dataset XMD, audit dashboard SAQL re-encoding, or find unused dataset fields. TRIGGER on keywords: Wave Recipe, CRMA, CRM Analytics, wdpr, wdash, wapp, WaveRecipe, Wave dataflow, dataflowjob, InsightsExternalData, SAQL, dataset XMD, Analytics Studio, R3 format, wave/recipes, wave/dashboards, or analytics on Salesforce objects (opportunities, leads, cases, accounts, sales). DO NOT TRIGGER for standard Salesforce reports or LWC components unrelated to CRM Analytics.
scripts/find_unused_dataset_fields.js
View on GitHub#!/usr/bin/env node
// Given a dataset name, list every XMD field that no deployed dashboard SAQL references.
// Caveat: aggregateflex steps, multi-dataset SAQL, and archived app dashboards are out of scope.
// Usage: node scripts/find_unused_dataset_fields.js <alias> <datasetName>
const { execSync, execFileSync } = require("child_process");
function getOrgCredentials(alias) {
const result = execFileSync('sf', ['org', 'display', '-o', alias, '--json'], { encoding: "utf8" });
const json = JSON.parse(result);
return { accessToken: json.result.accessToken, instanceUrl: json.result.instanceUrl };
}
function apiFetch(instanceUrl, accessToken, apiPath) {
const url = `${instanceUrl}${apiPath}`;
const args = ["-s", "-H", `Authorization: Bearer ${accessToken}`, "-w", "\\nHTTP_STATUS:%{http_code}", url];
const raw = execSync(`curl ${args.map(a => `'${String(a).replace(/'/g, "'\\''")}'`).join(" ")}`, {
encoding: "utf8", maxBuffer: 20 * 1024 * 1024,
});
const parts = raw.split("\nHTTP_STATUS:");
const httpStatus = parseInt(parts[1] || "0", 10);
if (httpStatus < 200 || httpStatus >= 300) {
throw new Error(`HTTP ${httpStatus} on GET ${apiPath}: ${parts[0]}`);
}
return JSON.parse(parts[0]);
}
function decodeHtmlEntities(s) {
let prev = null;
while (prev !== s) {
prev = s;
s = s.replace(/"/g, '"').replace(/'/g, "'").replace(/&/g, '&');
}
return s;
}
const [,, alias, datasetName] = process.argv;
if (!alias || !datasetName) {
console.error("Usage: node find_unused_dataset_fields.js <alias> <datasetName>");
process.exit(1);
}
const { accessToken, instanceUrl } = getOrgCredentials(alias);
// Fetch dataset XMD
const datasets = apiFetch(instanceUrl, accessToken, "/services/data/v59.0/wave/datasets");
const dataset = (datasets.datasets || []).find(d => d.name === datasetName || d.developerName === datasetName);
if (!dataset) {
console.error(`Dataset "${datasetName}" not found.`);
process.exit(1);
}
const versionId = dataset.currentVersionId;
const xmdResult = apiFetch(instanceUrl, accessToken,
`/services/data/v59.0/wave/datasets/${dataset.id}/versions/${versionId}/xmd`
);
const xmd = xmdResult.xmd || xmdResult;
const allFields = [
...(xmd.dimensions || []).map(d => d.fieldName || d.name),
...(xmd.measures || []).map(m => m.fieldName || m.name),
...(xmd.dates || []).map(d => d.fieldName || d.name),
];
// Collect all SAQL from deployed dashboards
const dashboards = apiFetch(instanceUrl, accessToken, "/services/data/v59.0/wave/dashboards");
let allSaql = "";
for (const dash of (dashboards.dashboards || [])) {
try {
const detail = apiFetch(instanceUrl, accessToken, `/services/data/v59.0/wave/dashboards/${dash.id}`);
const steps = detail.state?.steps || {};
for (const step of Object.values(steps)) {
if (step.query) allSaql += " " + decodeHtmlEntities(step.query);
}
} catch {
// Skip inaccessible dashboards
}
}
// Check which fields are referenced
const unusedFields = allFields.filter(field => {
const escaped = field.replace(/[.*+?^${}()|[\]\\]/g, "\\$&");
return !new RegExp(escaped).test(allSaql);
});
const usedFields = allFields.filter(f => !unusedFields.includes(f));
console.log(JSON.stringify({
datasetName,
totalFields: allFields.length,
usedCount: usedFields.length,
unusedCount: unusedFields.length,
unusedFields,
note: "aggregateflex steps, multi-dataset SAQL, and archived app dashboards are not scanned",
}, null, 2));
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit. | Stars: 471k | Updated | Claude CodeCodex | Verified | Install |
| rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure. | Stars: 471k | Updated | Claude CodeCodex | Verified | Install |
| rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics. | Stars: 471k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |