Dynamic File name for AEP data ingestion | Community
Skip to main content
Level 2
January 3, 2022
Question

Dynamic File name for AEP data ingestion

  • January 3, 2022
  • 2 replies
  • 949 views

Hi, Can someone guide on how can a a dynamic file name can be configured in AEP SFTP connector. I would like to schedule a source connector to pick the file daily with date timestamp from the SFTYP location to ingest the data. 

Secondly I would also like to send the alert once the data is completely loaded for triggering the journey in AJO.

 

Thanks in advance.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Kishore_Reddy
Community Advisor
Community Advisor
January 4, 2022

Interesting question, I would like to follow this thread to know more!

ChetanyaJain-1
Community Advisor
Community Advisor
December 4, 2022

Hi @mohiniu12161390,

When you configure the SFTP for daily load, it automatically picks the files that are modified/added after the previous run date. So any specific reason why you want it to be defined externally? Also, I believe if you have selected the folder in your configuration it will monitor the entire folder for the file changes - just ensure that the file format is the same for all the files in the folder.

Triggering the journey can be done via the segments. I don't think you can start the journey based on the file load.

Alternatively from AJO, you can fire APIs so see if you can fire API and get the alert status and take action within the journey.