Notifications
Announcements
No record found.
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.
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.
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 660 Most Valuable Professional
André Arnaud de Cal... 549 Super User 2025 Season 2
Sohaib Cheema 307 User Group Leader
