Query on File Management in BOARD with Azure SFTP Integration

Suman Das
Suman Das Active Partner
10 Comments Second Anniversary Year 2 Community Captain Photogenic

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:

  1. Is this functionality achievable in BOARD?
  2. 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.

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary
    edited December 5

    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
    Samson Sunny Employee, Community Captain
    25 Answers 100 Comments Third Anniversary 25 Likes

    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
    Suman Das Active Partner
    10 Comments Second Anniversary Year 2 Community Captain Photogenic

    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
    Suman Das Active Partner
    10 Comments Second Anniversary Year 2 Community Captain Photogenic
    edited December 6

    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
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    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
    Suman Das Active Partner
    10 Comments Second Anniversary Year 2 Community Captain Photogenic

    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
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    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