How to Read the file from SFTP in D365 F&O

(1) Share

Report

Posted on by Saran.S

How can I read a file from SFTP, retrieve the data from that file, and process it in D365 F&O X++?

Could you please guide on how to read a file from SFTP using x++.

I'd appreciate any insights or experiences you can share to help me with this.
Thank you!

I have the same question (0)

All responses (6)

Answers (2)

Suggested answer

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

Like (2)

Report

It depends on the contents of the file, but I would start by looking at Logic Apps or Power Automate to pick up your file from SFTP.

What you do with the file after that depends on what is in there, but I would guess you need some kind of import.

https://learn.microsoft.com/en-us/azure/logic-apps/connectors/built-in/reference/sftp/

Was this reply helpful? Yes No
S Gopi Krishna 637 on at

Like (2)

Report

We implemented this using the Azure Logic Apps as the X++ customization would be complex and costly.

Was this reply helpful? Yes No
Verified answer

Layan Jwei 8,122 Super User 2025 Season 2 on at

Like (2)

Report

Hi Saran,

This question was asked before, so please check this link
https://community.dynamics.com/forums/thread/details/?threadid=28d9fcc6-ed1d-4ed0-9479-718533e552c5

You could also check these two links if they are helpful:
https://dynamicsax4u.wordpress.com/2020/08/18/read-files-from-sftp-server-and-write-data-in-ax365-part-1/
https://dynamicsax4u.wordpress.com/2020/08/18/read-files-from-sftp-server-and-write-data-in-ax365-part-2/

Thanks,
Layan Jweihan
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No
Verified answer

Judy Microsoft Employee on at

Like (2)

Report

Hi, in addition, please refer to the following helpful links:

https://dynamicsax4u.wordpress.com/2020/08/18/read-files-from-sftp-server-and-write-data-in-ax365-part-1/

https://axvigneshvaran.wordpress.com/2024/03/07/read-the-mt940-files-from-sftp-and-upload-into-d365fo-using-x/

Hope it helps.

Was this reply helpful? Yes No
Suggested answer

Sankar Ramalingam 262 on at

Like (2)

Report

We can achieve this requirement with 3 option:

1. We can do the native x++ using "Renci" dll ref: https://dynamicsax4u.wordpress.com/2020/08/18/read-files-from-sftp-server-and-write-data-in-ax365-part-1/

2. Create your own dll using C# and refer it in x++ if there are complexity requirement like using SSH/private key.

3. Using Azure Logic apps or Power automate to get the file content from the SFTP and consume the file content using odata action or customer service in D365. (RECOMMENDED)

Was this reply helpful? Yes No
Layan Jwei 8,122 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Is your question answered? is yes, then please verify the answers that helped

Thanks,
Layan Jweihan

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to Read the file from SFTP in D365 F&O

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to Read the file from SFTP in D365 F&O

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates