I am trying to parse an Excel (.xlsx) file using File Listener. (Pega Cloud Storage).
It works to the point where i get the path sent all the way to my modified version of MSOParseExcelFile activity, however the issue is the path I derive from Log-Service-File page does not exist in the context of the Activity.
It doesn't appear i can access the path that contains the file at all.
Getting error from modified version of MSOParseExcelFile activity as "The uploaded file template could not be recognized. Please upload a valid file. Refer to template "templatefilename" for details.
The following are samples of the information I have.
Listener Source Location: file://pegacloudfilestorage:/sftp/AccountDetails/
Sample Derived Path: /sftp/AccountDetails/work_AccountDetailsFileListener/AccountDetails_01.xlsx
How can I successfully access the files from the activity?