Power Pages Web API: quick fix for wildcard * deprecation

On 2026-09-14 wildcard (*) stops working in the Power Pages Settings.

Example of this setup:

Go to make.powerapps.com -> Apps -> start Power Pages Management (older name Portal Management) -> Site Settings -> Example settings name Webapi/account/fields, value *

What to do

Replace * with actual field names: accountid,accountnumber

Quick Fix

To skip digging actual name do this:

In a browser type in the URL bar your Web API endpoint and authenticate.
Example: https://contoso.api.crm4.dynamics.com.

Type on the URL bar https://contoso.api.crm4.dynamics.com/api/data/v9.2/accounts?$top=1.

Now open console in devtools and do this:

const tableName = 'accounts';
const filterFn = (key) => ( 
  !key.startsWith('_') && 
  !key.startsWith('@')
);
await fetch(`/api/data/v9.2/${tableName}?$top=1`)
  .then(r => r.json())
  .then(r => Object.keys(r.value[0])
    .filter(filterFn)
    .toSorted()
    .join(',')
);

Output: accountcategorycode,accountclassificationcode,accountid,accountnumber,...,websiteurl,yominame

Adjust filter filterFn to your needs, or take from the output what you need.

Paste this output in Value instead of *.