BDC Custom Actions and WCF

I am developing an application that involves BDC, and one of the things I would like to do is accept a value from a field on an External List and pass that parameter to SQL

So for example, someone is viewing a record in an External List and the status of said record needs to be reset, and it is not something that is available via editing the record using BDC Update Operations.  This is due both to a technical limitation in how the status is controlled, and it is also something we do not want the user to edit directly.  It should be controlled by the SQL Stored Proc, which accepts a key field parameter.

How can I accomplish this via Custom Actions  - if at all?  Is it possible to consume a restful wcf from a BDC Custom Action?

If that is possible, then I would like some guidance on creating a WCF that will simply accept a parameter value and pass it to a SQLStoredProc.  I am very new to restful wcf, and I am having difficulty finding a simple example that I can get comfortable with.

What if any are the alternatives in this case?  I cannot attach a workflow to an external list, and I cannot pass parameters from the external list, with the exception of Custom Actions.  There are simple ASMX web services written to handle the status change as well, but I am unaware of how to call them and pass parameters from SharePoint.

I would really like to try to keep all the functionality in SharePoint, and this is the only thing that is tripping me up.

Any guidance would be greatly appreciated

&

March 25th, 2015 9:58pm

Hi,

We can create a WCF service and custom action, then use jQuery ajax to call the WCF service.

The following articles for your reference:

SharePoint: How to create a custom REST WCF Service available in _layouts folder

http://dotnetfollower.com/wordpress/2013/08/sharepoint-how-to-create-a-custom-rest-wcf-service-available-in-layouts-folder/

How to: Add a Custom Action to an External List

https://msdn.microsoft.com/en-us/library/office/ee558387%28v=office.14%29.aspx?f=255&MSPPError=-2147217396

Best Regards,

Dennis Guo

Free Windows Admin Tool Kit Click here and download it now
March 27th, 2015 3:00am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics