New answers tagged

0

function queryListItems() { var clientContext = new SP.ClientContext.get_current(); var oList = clientContext.get_web().get_lists().getByTitle('My List'); var camlQuery = new SP.CamlQuery(); camlQuery.set_viewXml('<View><Query><Where><Leq><FieldRef Name=\'ID\'/><Value ...


0

Like Melanie Culver alluded to a CAML query can be used to pass the parameters directly to the stored procedure. My external content type has an input parameter like this and I can specify my input parameter by name in JavaScript like: var viewXml = '<View Name="{my view GUID}" >' viewXml += ' <Method Name="GetTaskListForUserSite">' ...


1

I had the exact same challenge yesterday and found a solution. I came across this blog post: https://blogs.msdn.microsoft.com/chjain/2013/03/01/getting-data-from-large-external-lists/ One problem I had though was, that if I didn't list all the fields in the view fields, I got a KeyNotFound exception. I put the CAML query in the solution suggested here: ...


1

Please find the steps to be followed in SharePoint Designer to achieve your desired result. SharePoint 2013: BDC Configuration And Creating External Content Type and External List UPDATED SharePoint List From SQL Server Table (External Content Type with SharePoint Designer) Please let me know if you need some more help. Thanks.


1

Here's a very short overview of what you need to do assuming you have set up SP server already. Create the columns in your external database if you haven't already. This is important as changes to the db schema later have a problematic effect on external content types (ECT) in SP. In Sharepoint Designer (SPD) create a new ECT where you will be asked to ...


0

If you need to add data connection for external database you can refer Add a data connection to a Microsoft Access database. In this article only for Microsoft Access but you can similarly add for other databases. Please let me know if it enough for you. Thanks


0

I was facing the same problem these days and found the solution in my case ! I'm posting this hoping that it would help. Context: Sharepoint 2013 Online. External data in SQLSERVER 2012. Scenario: via SPD, I've created an external content type, choosing SQL server for the data source. I've created an external list from this ECT. Problem: In my site, ...



Top 50 recent answers are included