Applies to Product - Power Pages
What’s happening?
The WEB API is not retrieving attached files from a specific custom table, returning an empty array. This occurs despite no changes being made to the Site Settings or the table configurations. No error messages are displayed when calling the API.
Reason:
This is related to the permissions and relationships set up for the custom tables. Specifically, the absence of necessary parent-child relationships and permissions for the table in question is causing the attachments not to be retrieved.
Resolution:
- Review and adjust the table permissions to ensure that the necessary access is granted.
- Add extra relationships to the tables to minimize the number of parent-child permissions, which has been shown to resolve similar issues.
- If the problem persists, consider enabling global level access for users attempting to retrieve the attachments.
- Test the WEB API call after making the above adjustments to confirm if the attachments are now being retrieved successfully.