microsoft/power-platform-skills / plugins/power-pages/skills/migrate-webapi-selectall
migrate-webapi-selectall
VerifiedReviews and migrates deprecated wildcard (*) values in Power Pages Web API fields site settings to least-privilege explicit Dataverse columns. Use whenever a user mentions Web API wildcard or select-all remediation, fields settings containing *, data-exposure review, wildcard deprecation readiness, or Web API failures after wildcard retirement. Applies to both non-SPA sites using HTML, CSS, JavaScript, Liquid, and downloaded YAML, and SPA sites using React, Vue, Angular, Astro, or TypeScript. The agent must inspect every source Web API call and consumer, report exact fixes for every wildcard, report every already-explicit configuration, apply approved edits, and verify no wildcard remains.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 21.1 KB |
| assets/migration-report-template.html | other | 17.4 KB |
| references/column-analysis.md | markdown | 4.7 KB |
| references/configuration-and-reporting.md | markdown | 6.0 KB |
| references/site-transfer.md | markdown | 3.6 KB |
| scripts/query-table-schema.js | script | 15.0 KB |
| scripts/render-migration-report.js | script | 2.2 KB |
references/site-transfer.md
View on GitHub# Site Transfer Safety
Download and upload move Power Pages configuration between Dataverse and the
local project. Neither operation has an undo, and both can destroy
configuration that this migration never touched.
## Identity to confirm
Establish every value below and have the user confirm it. Never infer one from
a folder name, a previous session, or the active default.
| Detail | Confirm with | Needed for |
|---|---|---|
| Environment | `pac auth who`, `pac env who` | download, upload |
| Website name and `WebSiteId` | `pac pages list`, `website.yml` | download, upload |
| Site type: non-SPA or SPA | `powerpages.config.json` presence | download, upload |
| Data model: Standard or Enhanced | user | non-SPA only |
| Deployment profile | user, and profile files in the project | upload |
| Target path | user | download |
Re-confirm the whole set whenever the environment, website, or data model
changes. One approval covers one target.
## Command matrix
| Site type | Download | Upload |
|---|---|---|
| Non-SPA | `pac pages download` | `pac pages upload` |
| SPA | `pac pages download-code-site` | `pac pages upload-code-site` |
```bash
pac pages list --environment "<ENVIRONMENT>"
pac pages download --path "<PATH>" --webSiteId "<WEBSITE_ID>" --environment "<ENVIRONMENT>" --modelVersion "<Standard|Enhanced>"
pac pages upload --path "<PROJECT_ROOT>" --environment "<ENVIRONMENT>" --modelVersion "<Standard|Enhanced>" --deploymentProfile "<PROFILE>"
pac pages download-code-site --path "<PATH>" --webSiteId "<WEBSITE_ID>" --environment "<ENVIRONMENT>"
pac pages upload-code-site --rootPath "<PROJECT_ROOT>" --siteName "<SITE_NAME>"
```
Pass `--modelVersion` explicitly on every non-SPA download and upload;
`Standard` and `Enhanced` may also be written as `1` and `2`.
## Failure modes
Each of these corrupts configuration and cannot be reverted.
- **Wrong upload command.** `pac pages upload` corrupts an SPA site's
metadata, and `pac pages upload-code-site` corrupts a non-SPA site. A
project holding `powerpages.config.json` is an SPA site even when it also
contains `.powerpages-site/` artifacts.
- **Wrong data model.** `pac pages download` uses `Standard` when
`--modelVersion` is omitted, so an Enhanced site downloads incomplete.
Editing that copy and uploading it overwrites live configuration.
- **Unpinned environment.** `pac pages upload-code-site` accepts no
`--environment` and targets whatever `pac auth who` reports. Re-run
`pac auth who` immediately before it and stop on any mismatch.
- **Wrong website.** Sites in one environment differ only by name and
`--webSiteId`. A wrong ID downloads another site over the target path.
Before uploading, confirm the project's `website.yml` identity still matches
the approved site.
- **Overwritten local work.** `--overwrite` replaces existing local content.
Never pass it while the project holds unreviewed changes.
- **Stale local copy.** Uploading configuration downloaded before another
maker's change reverts that change. Download fresh before editing when the
local copy's age is unknown.
- **Unintended deployment profile.** `pac pages upload` uses `default` when
`--deploymentProfile` is omitted, which can target the wrong environment's
values.
## Public references
- [Power Platform CLI pages commands](https://learn.microsoft.com/en-us/power-platform/developer/cli/reference/pages)
- [Tutorial: Use Power Platform CLI with Power Pages](https://learn.microsoft.com/en-us/power-pages/configure/power-platform-cli-tutorial)
- [Use deployment profiles](https://learn.microsoft.com/en-us/power-apps/maker/portals/power-apps-cli#use-deployment-profile)
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| brainstormingobra/superpowersYou MUST use this before any creative work - creating features, building components, adding functionality, modifying behavior, or planning anything new, in software or out of it (a talk, a business, a renovation). | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| brand-guidelinesanthropics/skillsApplies Anthropic's official brand colors and typography to any sort of artifact that may benefit from having Anthropic's look-and-feel. Use it when brand colors or style guidelines, visual formatting, or company design standards apply. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| frontend-designanthropics/skillsGuidance for distinctive, intentional visual design when building new UI or reshaping an existing one. Helps with aesthetic direction, typography, and making choices that don't read as templated defaults. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| mcp-builderanthropics/skillsGuide for creating high-quality MCP (Model Context Protocol) servers that enable LLMs to interact with external services through well-designed tools. Use when building MCP servers to integrate external APIs or services, whether in Python (FastMCP) or Node/TypeScript (MCP SDK). | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |