70
Hello,
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 ?
Thanks.
ok, thank you.
what endpoint ?
Marina,
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.
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.
Andrew,
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=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]
Why ? Have you any example that works ?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (