Export to Excel with Data Page backed by a REST connector

User Experience
1

We are facing an issue with enabling the Export to Excel option for a landing page in the portal.

The landing page is populated using a Data Page that retrieves its data from a REST connector. We have enabled the “Allow querying any column” checkbox on the Data Page.

With this option enabled, the Export to Excel option is available in the menu. However, when we select it, the request results in a 500 error. From the tracer, we can see that this is caused by an empty response in pzDataExplorerExport.

When “Allow querying any column” is disabled, the Export to Excel option is no longer available in the menu.

According to the Pega documentation, the Export to Excel option is only available when the source is a Report Definition.

Our questions are:

Is there a supported way to enable Export to Excel for a landing page that uses a Data Page backed by a REST connector?
If not, is there a supported way to hide or disable the Export to Excel option when “Allow querying any column” is enabled?
Any guidance or recommendations would be greatly appreciated.

2

Hello @RoelK642

We had a similar use case almost a year ago and raised an SR with Pega as well.
Below is the screenshot for your reference.

image
image1470×246 31.8 KB

Thanks
Naganand

3

Ok, thanks! So the option should not be available.

4

Agreed! Good feedback item to capture.

5

We are already using Pega 25.1.2. If this issue was supposed to be fixed in Pega 25, why do we still see this option? Could it be that the fix will be included in a later minor or patch release?