Hi Sumit,
Thanks for your valuable input. I would definitely try out this option. Also as Leo Chen suggested I found out that these excel sheets are stored at Azure blob. I am planning to use its file url and pass in my custom created C# class method that could access Azure blob and download excel file and then upload at SFTP file server.
Below is C# code I am using to achieve my goal.
FtpWebRequest ftpClient = (FtpWebRequest)FtpWebRequest.Create(ftpurl + "/" + filename);
ftpClient.Credentials = new System.Net.NetworkCredential(ftpusername, ftppassword);
ftpClient.Method = System.Net.WebRequestMethods.Ftp.UploadFile;
ftpClient.UseBinary = true;
ftpClient.KeepAlive = true;
System.IO.FileInfo fi = new System.IO.FileInfo(fileurl);
ftpClient.ContentLength = fi.Length;
byte[] buffer = new byte[4097];
int bytes = 0;
int total_bytes = (int)fi.Length;
System.IO.FileStream fs = fi.OpenRead();
System.IO.Stream rs = ftpClient.GetRequestStream();
while (total_bytes > 0)
{​​​​​​​
bytes = fs.Read(buffer, 0, buffer.Length);
rs.Write(buffer, 0, bytes);
total_bytes = total_bytes - bytes;
}​​​​​​​
//fs.Flush();
fs.Close();
rs.Close();
FtpWebResponse uploadResponse = (FtpWebResponse)ftpClient.GetResponse();
string value = uploadResponse.StatusDescription;
uploadResponse.Close();
Please feel free to provide inputs from your side if any. This way I think I could direct leverage .Net framework capabilities without involving Power automate.
Thanks !!!!!
Share
Report
35
All responses (
Answers (
