Query on File Management in BOARD with Azure SFTP Integration

Suman Das · 2024-12-05T11:52:03+00:00

There was an error rendering this rich post.

Dear Team,

I hope this message finds you well.

I have received a specific requirement from the client regarding file management within our Azure storage environment. The requirement involves moving files from one folder to an archive folder in the SFTP directory under Azure storage.

I would like to know:

Is this functionality achievable in BOARD?
Can we implement schedulers within BOARD to automate this process, ensuring that once a file is loaded, it is moved to the archive folder?

Your insights and guidance on this matter would be greatly appreciated. If additional details or clarifications are needed, please let me know.

Looking forward to your response.

Find more posts tagged with

Accepted answers

All comments

Helmut Heimann

Hi @Suman Das ,

you'll probably need an AZcopy API to accomplish that.

The API would be called from a Board procedure (that can be scheduled).

Please have a look at this article describing the API's Microsoft is providing:
https://azure.github.io/Storage/docs/application-and-user-data/basics/azure-blob-storage-upload-apis/

Best,
Helmut

Samson Sunny

HI @Suman Das,

Yes, we can archive files within the SFTP folder in the Azure Shared Storage to an Archive folder within the same SFTP folder. The cloud operations team can create a PowerShell script to move the files within the SFTP folder. You can have this script to run on a scheduled basis to move the historical files. This script cannot be scheduled to run from within Board. Only the cloud operations team can schedule it for you.

Thanks,
Samson.

Suman Das

Dear @Samson Sunny I have already reached out to board support with your appeoach they told me that they don't provide this solution to the cloud customer any more.

Suman Das

Dear @Helmut Heimann,

Can you please clarify where this api needs to be present?

Is it in the client side , in azure or in board?

It will be very helpful if we can have a quick call on this please.

Helmut Heimann

Hi @Suman Das ,

the API's I was talking about, are provided by Azure. Usually, the should be present there.
First off all, I'd try to call one of those (i.e. using Postman) with the credentials you have been provided to access your Azure Cloud.
You can check if they did their job in Azure's File Explorer.

When that's done, implement the same call in a Board procedure.

Best,
Helmut

Suman Das

Dear @Helmut Heimann ,

I am not able to find the APIs that you are talking about. Can we connect over a quick call? or can you please share an example with us.

Helmut Heimann

Dear @Suman Das ,

since I'm working on projects I can't do a call and I don't have an example, either, I'm afraid.

You might want to have a look at Microsoft's reference.

https://learn.microsoft.com/en-us/rest/api/storageservices/

That should give you an introduction. If that doesn't help, I'd suppose to get in touch with our cloud support.

Best,
Helmut