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

learn more… | top users | synonyms

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 ...
3
votes
1answer
708 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: ...
0
votes
1answer
731 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
1answer
24 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
16 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
1answer
615 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 ...
1
vote
1answer
762 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
3answers
73 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
votes
0answers
16 views

can we scope external content type to site collection level?

I have some content type in web application , now i want to create a list based on that content type in different site collection ,but when i selecting external list in add an app the external content ...
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 ...
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 ...
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
21 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
47 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 ...
2
votes
1answer
33 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
2k 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
22 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
36 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
49 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
36 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
111 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
521 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
957 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
31 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
102 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
24 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
79 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
38 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
22 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
12 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
24 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
89 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
37 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
15 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
77 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 ...
1
vote
0answers
24 views

Display SQL Server data in Sharepoint with the ability to Drill Down

Metadata External List Users need to see & update metadata information about user databases via sharepoint. Users open a Sharepoint site and look for metadata Information Data being pulled from ...
0
votes
0answers
53 views

External content type add connection to a rest api

Is there a way to connect an external content type to a third party rest API? If so how? I have tried to find information about this, but have only found methods to using rest to get data out from ...
0
votes
1answer
131 views

External list with hyperlinks sharepoint 2013

How do I make a column (content) a hyperlink with an external list in SharePoint 2013? I have the url in the database and need to turn it into a hyperlink.
1
vote
1answer
165 views

BCS Managed Client Code Get all method instances

When using the class Microsoft.BusinessData.MetadataModel.Entity entity; does anyone know how to get all the External Content type operation method instances so i can dynamically pass the value to ...
0
votes
1answer
525 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
0answers
12 views

Custom Data Provider for External Content Type

I have a several data services and I want to add them to SharePoint portal. I found that I can create an external content types for that. All tutorials says that External Content Type can be created ...
0
votes
2answers
789 views

InfoPath does not support customizing the form used for this list.

How to enable this feature? "InfoPath does not support customizing the form used for this list." I want to edit the form in infopath and publish it back to SharePoint.
0
votes
1answer
75 views

External Content Type does not match the schema version for the form

When I try to edit or view the item within the External List view the error message is as followed: Error InfoPath cannot open the form because of an application configuration error: The schema ...
1
vote
1answer
160 views

SharePoint 2013 BCS and SQL Views

I have setup my SharePoint 2013 publishing site with BCS and Secure Store so that users can access multiple external lists within the site and if they have the correct permissions setup in Secure ...
0
votes
2answers
75 views

External Content Type - SQL - Filters

I create a new external list via a new external content type SQL . I retreive my data and i can display it. BDC Service allows us to view 2000 items . 1st Issue: I can filtered through a ...
0
votes
0answers
42 views

External Content Type based on SQL View allow insert/update/delete

I have two tables in SQL, one of them is read only (it is the "master"). The other is a detail table. They are joined on column 'VNO'. It is constructed with a left join on the master table, so ...