web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Integrating Microsoft ...
Microsoft Dynamics CRM (Archived)

Integrating Microsoft Azure with Dynamics CRM Online

(0) ShareShare
ReportReport
Posted on by FikriHailal 121

I have a requirements to read excel in azure blob storage through Dynamics CRM plugin. But the crm plugin doesn't support external DLL so i think it's not possible. However i still need to read the excel file and create records from its. Since im not familiar with azure and its features. 

What is the best option i have in this case ?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Radu Chiribelea Profile Picture
    Radu Chiribelea 6,667 on at

    Hello,

    You can create an Azure WebJob that reads data from the Excel and then creates it into CRM.

    You can also use the XrmTooling to generate a CrmServiceClient instance using certificate authentication (in this case you would need to register an App in Azure AD together with a signed certificate that contains the private key and an application user in CRM pointing to the registered app). You can then store the certificate in the WebJob settings and avoid hardcoding any credentials in your webjob code.

    Hope this helps,

    Radu

  • Verified answer
    PranavShroti Profile Picture
    PranavShroti 4,510 on at

    Hi Fikri,

    We had a similar requirement, we achieved it using Azure LogicApps which provides you OOB connectors like Dynamics CRM and Azure Blobs. Transformation logic can be written in actions and conditional statements are available. It will actually save lots of development time. You can utilize built in monitoring, retry framework.

    You may find more details in this link: docs.microsoft.com/.../logic-apps-overview

    Other option is to host a new Azure service which will talk to Dynamics at one end and Azure blob at another end. This will be pure custom development.

    Regards,

    Pranav

    If found useful, please mark the answer as verified

  • FikriHailal Profile Picture
    FikriHailal 121 on at

    Hi Pranav,

    It's seem that Azure LogicApps is a paid service. Isn't it ?

    If it is, then how much cost you have to pay to get the license?

  • FikriHailal Profile Picture
    FikriHailal 121 on at

    Hi radu,

    Seems lika a good solution for me, let me try this azure webjob. Thanks

  • Suggested answer
    PranavShroti Profile Picture
    PranavShroti 4,510 on at

    Hi,

    Yes Azure LogicApps are paid, and costing depends how many actions or connectors you are using.

    Microsoft site has a calculator which will help you get the indicative pricing.

    For your scenarios you will use all Standard Connectors and every time a Logic App definition runs the triggers, action and connector executions are metered.

    azure.microsoft.com/.../logic-apps

    Regards,

    Pranav

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans