Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Answered

Auto update exchange rates in Dynamics CRM on premise

Posted on by 80

Hi All, Is there way to auto update exchange rates from API in Dynamics CRM on premise? My client is updating manually based on this link www.ecb.europa.eu/.../eurofxref-daily.xml. I need solution for on premise whether with this XML or any API. Thanks for the help.

  • Persis Profile Picture
    Persis 80 on at
    RE: Auto update exchange rates in Dynamics CRM on premise

    can somebody guide on how to fetch the base currency of the org in the C#, I am able to establish the connection using below:

    CrmServiceClient crmSvc = new CrmServiceClient(ConfigurationManager.ConnectionStrings["OnPremCRM"].ConnectionString);

  • Verified answer
    furkank Profile Picture
    furkank 535 on at
    RE: Auto update exchange rates in Dynamics CRM on premise

    Hi, There is a blog post about updating currencies automatically. The post shows how to connect API, read values from API and update data in CRM. The method used here is using Power Automate but you can create a custom console application. Everything is same, you will still consume the REST endpoint same but with .NET code!

    Please refer to this link: crmminds.com/.../

  • Persis Profile Picture
    Persis 80 on at
    RE: Auto update exchange rates in Dynamics CRM on premise

    Hi Ryan,

    Thanks for the response, do you have articles or blogs that can guide me on this?

    Also wanted to know if its possible to do it through flows with exchange rates in JSON but environment will remain On Premise only

    Regards,

    Persis

  • Verified answer
    Ray Profile Picture
    Ray 1,505 on at
    RE: Auto update exchange rates in Dynamics CRM on premise

    You can write a console application to get the exchange rate from this XML and update exhcnage rate into Dynamics CRM. Then you can deploy this console application on the CRM server and run this application every by windows scheduled task.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans