Problem : "An error occurred while retrieving file from CRM"
Issue:
This is a common issue encountered in SFDC when a user tries to publish an offer. The error message “An error occurred while retrieving file from CRM” appears during the process.
Root Cause:
The error occurs when a user uploads an EULA file from their local system, but the Integration User (authenticated user) does not have the required permissions to access that external file.
Resolution 1: Grant File Access to the Integration User
You can resolve this by sharing the file with the Integration User and granting them Viewer access.
Follow the steps below to grant access:
Click on the 9-dots in the top-left corner.
Search for Files.
Locate the file you want to share access to.
Click the dropdown icon beside the file and select View File Details.
Click the Share button in the top-right corner.
Click on the blue profile icon and select People.
Search for the Integration User (Authenticated User).
Set the permission as Viewer.
Click on Share to save the changes.
Resolution 2: Enable “Query All Files” Permission
You can enable the “Query All Files” permission for the Integration User (authenticated user).
Follow the steps below to enable Query All Files permission:
Click on the Gear icon and select Setup.
Search for Users.
Open the Integration User (Authenticated User).
Click on Permission Set Assignments.
Select the SaaSify Permission Set assigned to the user.
Go to Object Settings.
Search for Query All Files .
Click Edit, then enable the Query All Files permission.
Click Save.