Finance | Project Operations, Human Resources, ...

Process a file on SFTP server

(1) Share

Report

Posted on by CU29041349-0

604

I have a requirement to pick up a file from a SFTP server and process it within F&O (i.e., validate and load records). I'm wondering whether a Power Automate or LogicApp job would make the most sense at least to detect and pick up the file from the SFTP server, then the job calls F&O in some fashion to process the file. Does this make more sense than coding to retrieve the file directly?

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

for me, I used PowerAutomate with BusinessEvent and it worked fine.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Suggested answer

Anthony Blake 2,963 Super User 2025 Season 2 on at

Like (1)

Report

This is a text book case for a logic app or power automate.

Theres then a few options for then getting the data into D365. Depending on complexity, you could load using dmf, so RestAPI, recurring integration, or load using OData. These methods will give you some built in validations. The other option is write a custom service to handle the import (volume dependant), then handle all the processing and validation in X++.

Was this reply helpful? Yes No