How to read the file from SFTP using blob storage in d365 finance and operations by using cloud application.
Thanks in advance.
How to read the file from SFTP using blob storage in d365 finance and operations by using cloud application.
Thanks in advance.
Maybe you can also borrow some code from BusinessEventsAzureBlobStorageAdapter (and related classes).
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.
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.
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).
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.
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.
André Arnaud de Cal...
293,245
Super User 2025 Season 1
Martin Dráb
231,927
Most Valuable Professional
nmaenpaa
101,156
Moderator