How to call exportDataStoreEntityToExcel on page load

You cannot call a smart service function outside of a user interaction.

Hi,

To achieve exporting data to Excel on page load using the ExportDataStoreEntityToExcel function, you can use the following code:

local!exportDocId,
local!exportLink,
local!errorMessage,
{
a!save(
local!exportDocId,
a!exportDataStoreEntityToExcel(
entity: cons!SCE_SITS_VW_INCIDENTS,
documentName: "test Report",
sheetName: "Test Report",
saveInFolder: cons!TEST_DOCUMENT_FOLDER,
onSuccess: a!save(
local!exportLink,
fv!newDocument
),
onError: a!save(
local!errorMessage,
"Error Exporting File to Excel"
)
)
),
a!save(
fv!exportDocumentId,
local!exportDocId
),
a!save(
fv!exportLink,
local!exportLink
),
a!save(
fv!errorMessage,
local!errorMessage
)
}
)```

This code utilizes the `a!localVariables` function to declare and assign local variables for `exportDocId`, `exportLink`, and `errorMessage`. Within the `a!localVariables` function, we make use of the `a!save` function to store the values of the `exportDocId`, `exportLink`, and `errorMessage` variables.

Please ensure that you have the appropriate configuration for the `cons!SCE_SITS_VW_INCIDENTS` entity, `cons!TEST_DOCUMENT_FOLDER`, and the necessary data to be exported to Excel.

By implementing this code, the data export to Excel will be triggered automatically on page load. The exported Excel document will be saved in the specified folder (`cons!TEST_DOCUMENT_FOLDER`). If the export is successful, the `exportLink` will contain the link to download the exported Excel file. In case of any error during the export process, the `errorMessage` will be populated with the appropriate message.

Feel free to modify the code as per your specific requirements, and let me know if you need any further assistance!