Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Data Management Import...
Finance | Project Operations, Human Resources, ...
Suggested answer

Data Management Import Project to read zipped excel data from Azure Storage file share.

(0) ShareShare
ReportReport
Posted on by jt1024 185
Hello,
 
The previous D365 admin setup a Data Management Import Project to read excel data from a zip file from a file share on Azure Storage.
 
I think that is set up in this job:
 
 
Does anyone know what I do to see the connection to the Azure File Share?
  • Suggested answer
    jt1024 Profile Picture
    jt1024 185 on at
    Data Management Import Project to read zipped excel data from Azure Storage file share.
    Hello all,
     
    Follow up on this one. It turns out there is custom code developed by previous teams to provide a SysOperation framework.  That code provides for specifying the target ERP environment and for the source location on an Azure File Storage location.
     
    Best Regards,
    - Jim
  • Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Data Management Import Project to read zipped excel data from Azure Storage file share.
    Hi,
    I'm sorry I couldn't help you, and thank you for your contribution to the community. If you have any questions, feel free to post on the forum, I will do my best to help you.
    Best regards,
    Kevin
  • jt1024 Profile Picture
    jt1024 185 on at
    Data Management Import Project to read zipped excel data from Azure Storage file share.
    Hello Martin, Kevin,
     
    Thanks to you both for your replies.  So far I have not found any custom code or API's.  But I've reached out to the former admin who has been helpful in the past to try and figure it out.
     
    For the benefit of the community I'll post again here once I've figured it out.
     
    - Jim
  • Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Data Management Import Project to read zipped excel data from Azure Storage file share.
    Hi,
    Based on the problem you described, it seems that you have a problem reading files from Azure. You can refer to this document: Connect to data in Azure Data Lake Storage - Dynamics 365 Customer Insights | Microsoft Learn.
    Best regards,
    Kevin
  • Martin Dráb Profile Picture
    Martin Dráb 230,476 Most Valuable Professional on at
    Data Management Import Project to read zipped excel data from Azure Storage file share.
    Data Management doesn't support it. Someone could modify it, but it's much more likely that there is an external app (such a Logic App, Azure Function or something like that) that reads files from Azure Storage and calls this import project through a Data Management API.

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.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,476 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans