File Path problems Parsing Excel file using file listener
I am trying to parse an Excel (.xlsx) file using File Listener. I have read may posts and pieced together a solution.
It works to the point where i get the path sent all the way to my modified version of pxParseExcelFile, however the issue is the path I derive from Log-Service-File page does not exist in the context of the Activity. From many of the posts I've read, it appears most have been able to successfully use the path derived from LogServiceFile.
It doesn't appear i can access the path that contains the file at all.
I wrote a test in the activity to print out the contents of the "/" directory to gain a reference and /sftp directory did not appear. The directory had contents such as:
issrv
isdev
istmp
isboot
isetc
ismedia
isroot
.....
The following are samples of the information I have.
Listener Source Location: file://pegacloudfilestorage:/sftp/CoERM_Incoming/
Sample Derived Path: /sftp/CoERM_Incoming/work_CHPMemberFileListener/CHPMemberO_Len_20073.xlsx
How can I successfully access the files from the activity?
Thanks
***Edited by Moderator Marissa to update General to Product***
Accepted Solution
Updated: 14 Sep 2020 10:11 EDT
Excellus Blue Cross Blue Shield
US
Good Day.
I am using the File listener to listen.
Then in the service File, I created an Activity to use in the Initial Activity of the service file.
In this activity, I derive the path from the LogServiceFile.pyPathName.
In the next step is where I refer to the D_pxGetFile data page (which is part of the Repository API: https://community.pega.com/knowledgebase/articles/data-management-and-integration/84/get-file-api) to get the file contents from pyContents.
Now content is available for the Final Activity where i parse the file
Hope this helps
Accepted Solution
Updated: 14 Sep 2020 10:11 EDT
Excellus Blue Cross Blue Shield
US
Good Day.
I am using the File listener to listen.
Then in the service File, I created an Activity to use in the Initial Activity of the service file.
In this activity, I derive the path from the LogServiceFile.pyPathName.
In the next step is where I refer to the D_pxGetFile data page (which is part of the Repository API: https://community.pega.com/knowledgebase/articles/data-management-and-integration/84/get-file-api) to get the file contents from pyContents.
Now content is available for the Final Activity where i parse the file
Hope this helps