Question

1
Replies
58
Views
 Maleesha Wilfred (MaleeshaW)
Evonsys
Associate Consultant - Technology
Evonsys
LK
MaleeshaW Member since 2019 35 posts
Evonsys
Posted: January 22, 2021
Last activity: February 1, 2021
Posted: 22 Jan 2021 3:43 EST
Last activity: 1 Feb 2021 22:36 EST
Solved

Get last modified file name from a directory

Report

Hi,

I have a requirement to obtain the last modified file from a set of files in a specific folder. The folder path is passed as a parameter.

I need to obtain the latest modified file and read its content via an activity or a DT.

Is there any way to obtain this without incorporating Java?

TIA

Pega Platform 8.4 Data Integration Java and Activities Insurance Senior System Architect
Reply

Accepted Solution

Posted: 5 months ago
Posted: 1 Feb 2021 22:36 EST
Maleesha Wilfred (MaleeshaW)
Evonsys
Associate Consultant - Technology
Evonsys
LK
Report

This was resolved by implementing an activity with the following steps.

  1. Set the folder path to a parameter
  2. Copy the list files in the target directory using D_SPOnlineGetFiles data page to a single page property.
  3. Sort the results in the single page property using the last modified date property in descending order
  4. Get the first result in the sorted list
Reply