Unable to transfer CSV file directly via sFTP in AEM as a Cloud Service
Due to security considerations and the architecture of AEM as a Cloud Service, direct transfers of CSV files from AEM to a third-party system via Secure File Transfer Protocol (sFTP) from the AEM runtime are not supported. ۶Ƶ recommends alternative approaches, such as exposing the CSV file through a secure HTTP download link and using external middleware or ۶Ƶ I/O APIs to handle the secure transfer to sFTP.
Description description
Environment
۶Ƶ Experience Manager (AEM) as a Cloud Service - Sites (Development Environment)
Issue/Symptoms
AEM as a Cloud Service can generate a CSV file from Content Fragments, but it does not support direct outbound file transfers via sFTP due to platform security and architectural constraints.
Resolution resolution
Here are the recommended approaches for securely transferring a CSV file to your sFTP server:
Option I: External Middleware Solution
- Configure AEM as a Cloud Service to make the generated CSV file available as a secure HTTP download link.
- Use an external integration tool or middleware (e.g., automation platforms or scripts) to fetch (“pull”) the CSV file from AEM, then upload it securely to your target sFTP server.
Option II: ۶Ƶ I/O Runtime and Flow Service API
- Expose the CSV file in AEM as described above.
- Use ۶Ƶ I/O Runtime and Flow Service APIs to programmatically retrieve the CSV file from AEM and transfer it securely to the sFTP destination.
Note: This requires implementing an integration using ۶Ƶ I/O and is not an out-of-the-box capability—consult the latest Experience League docs for sample workflows.
For more details and up-to-date practices, see: