Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / How to Read the file f...
Finance forum
Suggested answer

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

editSubscribe (2) ShareShare
ReportReport
Posted on by Saran S 25
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!
Categories:
Development / Customization / SDK
  • Layan Jwei Profile Picture
    Layan Jwei 3,079 Super User on at
    How to Read the file from SFTP in D365 F&O
    Hi,

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

    Thanks,
    Layan Jweihan
     
  • Suggested answer
    Sankar.R Profile Picture
    Sankar.R 62 on at
    How to Read the file from SFTP in D365 F&O
    We can achieve this requirement with 3 option:
     
    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)
  • Suggested answer
    Judy Profile Picture
    Judy Microsoft Employee on at
    How to Read the file from SFTP in D365 F&O
  • Suggested answer
    Layan Jwei Profile Picture
    Layan Jwei 3,079 Super User on at
    How to Read the file from SFTP in D365 F&O
    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
  • S Gopi Krishna Profile Picture
    S Gopi Krishna 217 on at
    How to Read the file from SFTP in D365 F&O
    We implemented this using the Azure Logic Apps as the X++ customization would be complex and costly.
  • Suggested answer
    Anthony Blake Profile Picture
    Anthony Blake 862 on at
    How to Read the file from SFTP in D365 F&O
    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.

Helpful resources

Quick Links

Take the Community feedback survey!

Answer this brief 15-question survey about your Community experience…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

more Community News

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,375 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,308 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans