Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

How to read the file from SFTP using blob storage in d365 finance and operations by using cloud application

(1) ShareShare
ReportReport
Posted on by 122

How to read the file from SFTP using blob storage in d365 finance and operations by using cloud application.

Thanks in advance.

  • Martin Dráb Profile Picture
    231,927 Most Valuable Professional on at
    RE: How to read the file from SFTP using blob storage in d365 finance and operations by using cloud application

    Maybe you can also borrow some code from BusinessEventsAzureBlobStorageAdapter (and related classes).

  • Suggested answer
    Martin Dráb Profile Picture
    231,927 Most Valuable Professional on at
    RE: How to read the file from SFTP using blob storage in d365 finance and operations by using cloud application

    Power Automate license is included in Dynamics 365 license.

    Also, designing, developing, testing and maintaining a custom software solution isn't without cost; using something that is already done if often much cheaper. Your client is unusually lucky if they have a team working for them for free. Or, more likely, they forgot to include a plenty of things in their cost analysis.

    If you want to develop something by yourself, look at the available .NET APIs and (if you're not familiar with it), learn how to use .NET Interop from X++.

    Here a quick start for Azure Blob storage. And you can use SSH.NET for communication over SFTP.

  • SarathVarma Profile Picture
    122 on at
    RE: How to read the file from SFTP using blob storage in d365 finance and operations by using cloud application

    Yes, we have two type of storages like SFTP and Azure Blob Storage

    we want to read the data in D365 F&O and also write the data from D365 to storages.

    I have not considered using Logic Apps or Power Automate because my client want to go with low cost/no cost.

  • Martin Dráb Profile Picture
    231,927 Most Valuable Professional on at
    RE: How to read the file from SFTP using blob storage in d365 finance and operations by using cloud application

    Aha, so you have files on two types of storage - some files on a FTP server and some in Azure Blob Storage and you don't actually want to "read the file from SFTP using blob storage", correct?

    What do you want to do with those files?

    Have you considered using Logic Apps or Power Automate? They have connectors for all three things (SFTP, Blob Storage and D365FO).

  • SarathVarma Profile Picture
    122 on at
    RE: How to read the file from SFTP using blob storage in d365 finance and operations by using cloud application

    Hi Martin,

    Thanks for your response.

    We need to read and write the XML files from SFTP server and blob storage could you please help me to proceed the steps in d365 F&O.

  • Martin Dráb Profile Picture
    231,927 Most Valuable Professional on at
    RE: How to read the file from SFTP using blob storage in d365 finance and operations by using cloud application

    What do you mean by "by using blob storage"?

    Maybe you should start by explaining what you want to achieve from business point of view and burrow to implementation details later.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,245 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,927 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans