Excel file not getting generated.

Hi,

I am trying to generate excel document by using the a!exportDataStoreEntityToCsv(). Below is my code snippet:

load(
local!exportDocId,
local!errorMessage,
{
if(
isnull(local!exportDocId),
a!linkField(
labelPosition: "COLLAPSED",
links:a!dynamicLink(
Label: "Export Inactive Users Details to Excel",
saveinto:{
a!exportDataStoreEntityToCsv(
entity: cons!VW_EPMT_EWR,
selection: a!querySelection(
columns:{
a!queryColumn(
field: "ewr_number"
),
a!queryColumn(
field: "name"
),
a!queryColumn(
field: "active"
)
}
),
documentName: "EWR Grid Record Data",
saveInFolder: cons!EWR_FOLDER,
onSuccess: a!save(
local!exportDocId,
fv!newDocument
),
onError: a!save(
local!errorMessage,
"Error in Exporting File"
)
)
}
)

),
{}
),
if(
not(isnull(local!exportDocId)),
a!linkField(
links:a!documentDownloadLink(
Label:"Download Excel File",
document: local!exportDocId
)
),
a!textField(
value:local!errorMessage,
readonly:true
)
)
}
)

Now when i am clicking on the link in design interface, it gives the below error:

Interface Definition: Expression evaluation error: An error occurred while executing a smart service: Error accessing data store entity: VW_EPMT_EWR. Please contact a system administrator for additional details. (APNX-1-4505-026).

Could anyone please help me out by identifying the mistake. Any help will be appreciated.

Thanks,

Anandita

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data