News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Automate excel Import/...

Finance | Project Operations, Human Resources, ...

Suggested answer

Automate excel Import/export to /from SFTP server

(0) Share

Report

Report

Posted on by AnkitW

5

We have a requirement where we need to export/import excel from SFTP server(with private key authentication). It should be automatically at regular intervals.

As X++ code for excel can not be scheduled in batch we have to create a custom entity which is used to create Excel. If we use scheduling feature of Data framework this file needs to be generated at some location what would it be ? Then the point is how it will be shared to SFTP ?

It would be appreciable if someone can explain the flow for this. Need simple approach for this requirement.

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

zhifeng on at

Like (0)

Report

RE: Automate excel Import/export to /from SFTP server

Hello AnkitW,

You can use package API/Recurring integrations export data and put file somewhere then copy to your SFTP server.

docs.microsoft.com/.../data-management-api

docs.microsoft.com/.../recurring-integrations
Martin Dráb 230,235 Most Valuable Professional on at

Like (0)

Report

RE: Automate excel Import/export to /from SFTP server

I disagree with the statement that you can't work with Excel files in batch, but anyway using data entities look like the right approach to me.

You could, for example, create a Logic App that will use a data management API to export data to a file and then it'll push this file to the SFTP server.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans