Problem
I packaged a project as a Marketplace product and installed it in a different ontology, but users weren’t able to export object sets from that project to excel.
In workshop apps, the right-click menu Export to excel option for object tables gave the following error:
Users got the same error when using a button group + Export to excel approach.
Object explorer also gave a Permission denied error when users tried exporting from there:
And here’s the 403 response for the /phonograph2-export/api/export-object-set-to-excel-v2 request in the browser:
Users could view the objects they were trying to export and could execute actions that make edits on those objects in the ontology where the Marketplace product was installed - it seemed like the export functionality was the only feature that was failing.
Solution
Unlock the marketplace installation.
When installing the Marketplace product, the project resources are initially locked. This means edits can’t be made to the installed resources. Unlocking the installation required mapping the existing Marketplace Installation-scoped user roles to equivalent regular role (e.g. Marketplace Installation Discoverer → Discoverer).
Once the project was unlocked, the users were able to export to excel.