A variation of a content type that stores content outside of SharePoint.

learn more… | top users | synonyms

1
vote
1answer
1k views

Throttled While Crawling Large External Databases

I created an ECT using SPD2013 last week. It connects to a SQL DB while using the Secure Store to impersonate a domain user for a particular DB View. Last week, I used my personal (farm admin) ...
0
votes
0answers
9 views

Create ECT using Nested SQL Store Procedure

I'm creating ECT in SharePoint O365 using SP Designer. I'm defining the operations using Store Procedure. My Read List Store Procedure some thing like below: CREATE PROCEDURE [dbo].[...
2
votes
1answer
785 views

Secondary lookup columns for external content types not displaying data in list after refreshing from primary

I have created a SharePoint list that has a lookup column to an external list. I also have instructed SharePoint to display several secondary columns that are related to that primary external lookup ...
0
votes
0answers
11 views

MYSQL External Content Types in SharePoint Online

Is there a way to create an external content type using MySQL in SharePoint 2013 online?
1
vote
1answer
1k views

Permissions to write to External List from Workflow

I'm attempting to create a SharePoint workflow that creates a new item in an external list using the "Create item in [External List Name]" action available in SharePoint Designer. Currently, I keep ...
2
votes
0answers
23 views

Reading data from a external list using a 2010 workflow

I work with SharePoint 2013, and need to read information from a external list that I have created. The list can display information correctly when using it through the browser. I need to create a ...
3
votes
1answer
720 views

How to create new External Content Type on SharePoint Designer

I'm trying to create a new External Content Type on Sharepint Designer , but where I try to insert the web services wisdom into the "New Connection -> WCF Connection " I get the following error: ...
2
votes
0answers
27 views

Display additional fields on forms (External lists)

I have a external list where I have employee information. I am trying to do a lookup where I can select the employee and display it's corresponding department with the additional columns possibility. ...
0
votes
2answers
785 views

SharePoint Online Hosted App get List Items from within app

I have a Visual Studio 2013 solution and I have been successfully able to get list items from the host web using the following JavaScript code: var context = SP.ClientContext.get_current(); ...
0
votes
1answer
712 views

The remote server returned an error: (407) Proxy Authentication Required.- BCS

We are trying to Consume OData in BCS using an App External Content Type. The OData service that we used is http://services.odata.org/V3/Northwind/Northwind.svc We followed this to create app ...
0
votes
0answers
10 views

SharePoint External List editing

I create a page with 2 web parts. one displays the external list and 2nd web part displays the data of selected item. I would like to be able to make this 2nd web part as editable. is it possible? ...
0
votes
1answer
755 views

SharePoint 2013 External Content type. Populate secondary fields

I am trying to migrate data to a document library that contains a external content type using the SharePoint 2013 client object model. The external content type is pulling from a sql server 2012 ...
0
votes
0answers
18 views

SharePoint 2013 BCS identity delegation with kerberos and claims

I have a question about the BCS and having it successfully pass through the current users' identity to a SQL database whilst using Claims and Kerberos. I've read a lot of contradictory information ...
0
votes
2answers
55 views

Parameters not passed to BCS External List via REST API

I have two external lists connected via external content types which are connected to stored procedures in SQL Server. I believe I have them set up identically (though evidently not because one is not ...
1
vote
2answers
47 views

InfoPath or SharePoint Forms into SharePoint server

I am new to SharePoint and InfoPath or SharePoint designer. I am trying to do the following, could not able to find solution yet. read so many blogs. Have an external SQL server database. I want to ...
2
votes
1answer
2k views

External Content Type Search not returning results

I have configured my 2010 External Content Type for search by adding the RootFinder property to the ReadList method. I have also added the ShowInSearchUI property to the LOB entry. I then set up my ...
1
vote
0answers
109 views

SharePoint Designer 2013 - External Content Type, Page Number filter issue

I have created an External Content Type using SharePoint Designer. The data source is SQL table. The data in SQL table may increase up to around 25k rows. To handle this situation, we are using Page ...
0
votes
1answer
38 views

How to add External Content type To custom SharePoint list?

We have a requirement Creating External Content type in sharpoint 2013 based on that SQL database Table. For example in sql i have four database(db1,db2,db3,db4) and sharepoint i have 4 custom list(...
0
votes
2answers
4k views

Error with External Content Type List: “Unable to display this web part”

I have deployed an external content type to my local Sharepoint 2010 Server using a Visual Studio solution. The deployment appears to work. I can view the details of the content part in the central ...
0
votes
1answer
39 views

SharePoint 2013 Unexpected Error while creating lookup column to use external list

I am using SharePoint Server 2013. In that I am creating a custom column which lookup to an external list. My ECT is based on an SQL Server table and I have created the external list in the site. I ...
2
votes
1answer
22 views

What happens to External List created using BCS from SQL query once the server goes offline?

If the database gets deleted or somehow goes offline, will the list keep the existing data or will it all be gone due to failed synchronization.
0
votes
3answers
214 views

Query String Parameter pass to Data Source Filters in External List (BDC)

Can you please guide me how to pass the Query String Parameters to Data source Fiters in external list? I have created external list based on external content type. External content type has three ...
1
vote
1answer
1k views

Connect ECT to SharePoint List in InfoPath?

I'm trying to create a list in Infopath 2010. I'd like one of the fields to be a drop down list that connects to an external content type list. It doesn't show any of the External Content Type Lists ...
0
votes
0answers
28 views

Connecting outside database via WEB API's to SPO

Has anyone been able to automate a connection to an outside source that uses WEB API's? We use Deltek Vision in the cloud, and would like to be able to automate some information to carry over from ...
0
votes
1answer
75 views

use external liste error :Oracle database TNS The value's length for key 'data source' exceeds it's limit of '128'

I have created xml model for external list using bcs this is the code example for my BDCM model: <?xml version="1.0" encoding="utf-8" standalone="yes"?> <Model xmlns="http://schemas....
2
votes
1answer
38 views

Link Sharepoint Survey to External list

I am trying to go around the limitation of not being able to associate workflows to external lists. I am wondering if it is possible to create some form of association with a SharePoint survey. My ...
2
votes
1answer
3k views

External wcf (Soap/rest) datasource to external content type

I'm looking for a way to use an external datasource (WCF SOAP or REST) and include the results in a list. Using the External Content Type directly for a WCF service does not work, as I get a XML error ...
1
vote
1answer
24 views

External Content Types Error

I want to get data from SQL Server 2013. I created Business Data Connectivity Service. Then I click the External Content Types but I get error.
0
votes
0answers
41 views

Data not showing in External list of SharePoint 2013 site

I have created external content type using stored procedure. Also created read list operation, as well as read item operation. But the problem is that the stored procedure that I have created is ...
1
vote
1answer
50 views

Not able to create External Content Type in SharePoint Designer 2013 using Stored Procedure

I want to create the external content type using stored procedure but it is giving me error such that, when I right click on routines in Data Source Explorer and then select New Read Item Operation ...
0
votes
0answers
39 views

New “Read List” operations is not showing on external list

I am working on a SharePoint 2013 environment. We use external data to display contact information. To use some other Data we created a view on the SQL-Server and added a new Read List operation for ...
1
vote
0answers
229 views

How to get the data from external SQL Server database in SharePoint 2013 site

What I want to do is retrieve the data from external SQL server database and bring it on the SharePoint 2013 site and show the graphs accordingly. So the data might be from different database tables. ...
1
vote
2answers
569 views

How to do a Filter in a BCS External Data picker

I am using an OData web service with BCS (testing with Northwind) and I would like to define some filters when using the External Data picker. I'd like to be able to have a drop down that then ...
3
votes
2answers
963 views

Search in External content type

I am new to SharePoint. I am trying to add a search box to a list but I can't figure out how to do it. I have added an external content type and want to be able to search in it. So what I did was ...
1
vote
1answer
33 views

External Content Types Office 365

I've the following: In the cloud = SharePoint (office 365) On-Premises = SQL DB's that I want to connect to from SharePoint Is it possible to connect to my On-Premises SQL DB's?
3
votes
0answers
106 views
1
vote
2answers
5k views

Why won't the “New Item Form” create for an external list?

I'm using SharePoint Foundation 2010 and I have an external list created from an external content type. The external content type uses a WCF service as datasource. The WCF service has only three ...
0
votes
0answers
25 views

Doing some actions into multiple Item of External list

I have an external list of Microsoft CRM 2011 Accounts in SharePoint 2013 (By BDCS Service). In SharePoint 2013 environment I want to select some items in this External List and apply an action to the ...
2
votes
2answers
38 views

Trouble updating rows of data in an External Content Type using Javascript

I've tried a few different ways of doing this, including querying the External Content Type and then updating the current item. However as far as I ever get is an undefined variable error. This is my ...
1
vote
0answers
103 views

How to correctly update specific columns in an external database through an ECT?

Here is the scenario: I have an External Content Type based on a specific table in an external DB. The table itself has 33 columns, my ECT exposes a total of 13 of those columns, 7 as read-only and ...
1
vote
0answers
45 views

BDC update operation fails with socket exception

I have set up an external content type in my BDC Service, and I am using the Secure Store Service to provide the database credentials. In the ECT I have set up Read Item, Read List, and Update Item ...
0
votes
0answers
25 views

External content source as a ContentType refiner

In SharePoint 2013, when crawling an external database, how can you include the crawled items as a content type in the ContentType refiner?
0
votes
0answers
23 views

map External Content Types

I need to be able to map External Content Types/Columns to Sharepoint Columns or Lists. Basically, I need to be able to ‘marry’ lists/columns in SharePoint with External data. Best I can tell ...
0
votes
0answers
13 views

Need Help Understanding External Content Types

I need to be able to understand how to create an External Content type based off of Stored Procedures. All example I have seen thus far show me how to create using 'Create All Operations' using a ...
0
votes
0answers
14 views

External List doesnt 'see' External Content Types

I have created a few External Content Types in which standard lists find easily as an 'External Data' column type. However, a 'External List' doesnt see any of these external content types. I dont ...
0
votes
0answers
26 views

Create external content type with sql server

I need to have an external list in SharePoint 2013, i found a lot of tutorial but. I need that my external content type has a unique authentification to my sql tablE. i don't want connection to the ...
0
votes
0answers
119 views

External content type data retrieving error in SharePoint Online

I followed this page to create an external content type in SharePoint Online and add a Business Data List Web Part to read data from this external content type. But it displays an error, it says An ...
1
vote
0answers
45 views

How to enable quick edit in an External List?

I know, it is not supported. I am in the process to customize a ECT list view with access to enable the quick edit function.
1
vote
0answers
16 views

How to tell an ECT developed in VS to use credentials from Secure Store Service?

I am trying to develop an External Content Type using Visual Studio so I can use External Data Source columns in a SharePoint list. Most of the stuff I am finding online uses Designer, but I don't ...
0
votes
1answer
97 views

Remove Infopath form from external list?

The InfoPath form has broken for the external list. How to remove all GUI InfoPath form from the external list? I want to rebuild the InfoPath again for the external list without having to recreate a ...