Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 release wave 1 Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I have MS SQL stored procedure, in linked server. It have several input parameters and one output parameter(uniqueidentifier). Procedure returns one record.
I need to call it in web resource.
Is it possible to do this without creating any Plugin/Assembly which can be called in Action/Workflow ?
I don't think there is a good way to implement your scenario without plugin and action. You already described the best way so good luck in making it real.
I write plugin, It works perfect in debug mode, but from CRM it returns error
Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=188.8.131.52, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]
Why ? Have you any example that works ?
My main question - why do you need stored procedure and what's your scenario?
I need execute stored procedure for record of contact entity, when the concrete field change value.
But this procedure is in another server. I can not change that.
Sorry, I don't tell you that it works perfect on the machine, that connect to SQL by another user.
My recommendation - create some kind of endpoint that will call your SQL server and call that endpoint from your plugin. Believe me - I was in your shoes and that's the only good way to implement your scenario.
what endpoint ?
With endpoint I meant some kind of webservice.
ok, thank you.
Business Applications communities