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?

    Write a Reply...

    -An Initiative Of OneStopPega- Love our work? Support Us🖤