Questions tagged [external-content-type]

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

Filter by
Sorted by
Tagged with
3
votes
1answer
805 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
1k views

Creating External Content Type under BCS model by connecting to an Oracle Database

I want to create an External content type by connecting to an Oracle database using VS or SP designer,to show data in an external list? I am a bit new to BCS model so a little background will be ...
1
vote
2answers
743 views

How to change URL in search results from custom quelle

Given a database table with following columns: ID, TEXT, URL. This table contains some useful links to external sites. In Sharepoint 2010 we have added this table as a custom search source. How to map ...
2
votes
3answers
8k views

How can I get external content crawled into SharePoint online index

I have SharePoint online and I want to add external content to the index. So far I have it set up that the external content is put into an external list using BCS. The content passes through a WCF ...
1
vote
1answer
903 views

External Content Type creating problems in Saving Site as Template on SharePoint 2010

I'm having trouble trying to save a SharePoint 2010 site as template. SPSolutionExporter: Microsoft.SharePoint.SPException: Feature definition with Id a4fbae30-a689-43d0-8f75-484a940336cf failed ...
0
votes
1answer
1k 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 ...
0
votes
1answer
14 views

Unknown error has occurred. The form template has been published to the server but it can only be opened in InfoPath Filler

I have gotten this error before and to fix it, I created a new external list and new form. But when going back in and editing the new form, it doesn't even publish and keeps giving me this error. I ...
0
votes
0answers
15 views

External Content write to SQL DB value assignment not seeing Primary Key

I created an external content type in SharePoint Designer 2013 for SharePoint 2016 on premises using Impersonate Custom Identity with a SQL login using the Secure Store. I generated an external list ...
0
votes
0answers
9 views

SharePoint 2013 External List with multiple columns create lookup columns to each external list column?

Why does the identifier only allow me to use ‘Posting account ID’? What if I want to make separate lookup columns that would only ‘lookup’ to each row in the External List (i.e. a lookup column to ...
0
votes
0answers
13 views

How to only show specific columns in external list picker

How would one use an external list containing several columns to map each column in the external list to a drop-down control in a SharePoint List item? In the picture attached, how does one take each ...
2
votes
1answer
2k 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
1answer
601 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
810 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 ...
1
vote
1answer
716 views

BDC Model for ActiveDirectory

I am trying to build a BDC Model and a custom .net connector for ActiveDirectory so that users can search for data in AD from Sharepoint as well as create lists (ie: Users list that will show users ...
2
votes
1answer
1k 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 ...
1
vote
1answer
39 views

Create External Content Type in SP Online without SP Designer

I would like to create an External Content Type (ECT) inside SharePoint Online to connect to an Azure SQL Database. I cannot use SP Designer, what options do I have to create an ECT on a Macbook? ...
0
votes
1answer
16 views

External Content Type Connection : illegal operation attempted on a registry key marked for deletion

when I add a connection to a sql server database in an external content type from Sharepoint Designer 2013 I get this error: Retrieving the COM class factory for component with CLSID {BDEADDF26....} ...
0
votes
1answer
789 views

Workflow to Copy Item to a Library with External Data field?

I have a workflow that is triggered when a item is approved, it looks at the status and copies it over to a archive library with a external data field. Problem I am having is when the copy happens ...
0
votes
0answers
18 views

External Content Type: Cannot logon with credentials obtained from Secure Store Provider

Trying to set up a new External Content Type that connects to a SQL database using a service account. I have verified that the service account can actually connect to the DB because I used SQL ...
1
vote
0answers
15 views

Is it possible to sort items from an external content type?

I have an external list/content type set up that reads data from a SQL database view. I only have access to the one view, I do not have access to any tables directly. This database has been around ...
0
votes
0answers
28 views

Will a CAML query using Method and Filter against an external list be passed through to the external data source?

I have an external list/content type set up that reads data from a SQL database view. (I only have access to one view, I do not have access to any tables directly.) This database has been around for ...
0
votes
2answers
278 views

Create external content type without using SharePoint Designer

I have a web service and I need to create an external content type. I am using SPD but that is not working. It is asking me to select at least one field and the errors will not go away. So I am stuck ...
3
votes
2answers
1k views

Problem with limit of Items in External list

My Web part consumes a list that presents this error: The Database Connector limited the response. The database response contains more than '2000' rows. The maximum number of rows that can be read ...
0
votes
0answers
18 views

External List - datetime fields UTC adjusted

In SP 2013, we are able to pull in data from sql server to an external list (via an External Content Type) - unfortunately the datetime fields in SharePoint do not match what's in the database. The SP ...
4
votes
1answer
905 views

Adding a non WCF SOAP wsdl as external content type in sharepoint manager

This is location to my wsdl, it is WSDL created by Spring WS: http://foo.bar/local/rpc/file.wsdl I am trying to add the connection to external data source from sharepoint designer. In the selection ...
1
vote
1answer
80 views

SP Online WCF External Content Types using SP Designer 2013

To create External Content Types in SharePoint Online, i have created a WCF service and hosted it in IIS and it is working fine as shown below. Now, I tried to create External Content types using ...
0
votes
0answers
1k views

Sharepoint Online External Content Types WCF Service

I have this issue I can't find solution for a couple of days now as I am working on creating External Content Types for Sharepoint Online 2013 (trial period will expire in the next 5 days :( ). I ...
0
votes
1answer
27 views

Backup & Restore SP Site with External Content Type to Another Site - make error

My site includes External Content Type (BCS) on Dev site, with List which of that type - and when i restore it to Prod server, the connectivity of the list, stay as previous system..! any way to ...
0
votes
0answers
16 views

Can Sharepoint augment List items with external data fetched using an API using BDC services?

We currently have a case management system built in .net which exposes an API to fetch cases, generate documents, save cases etc. Example get case : http://casemgmt.foo/case/{id} There is a business ...
0
votes
1answer
288 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 ...
0
votes
3answers
2k 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 ...
2
votes
1answer
388 views

Authentication between SharePoint O365 and external OData web service

We are using SharePoint Online (O365) with ADFS. We are also building an on-premise OData web service to provide data into the cloud as an External Content Type. We understand generally how to use ...
1
vote
0answers
26 views

POSH created Items and BusinessData fields not displaying additional ECT fields

I have a POSH script that create items on a list that pulls additional field data from a BCS source. The function is as follows. Function Add-SPItems($TargetingDetails) { $site = New-Object ...
1
vote
1answer
21 views

Firewall issues while creating an external content type

I'm trying to create an external content type using SP designer in an SP2013 farm. The SP servers have access to the SQL server I need, and I have access to the SP servers from the VM I'm running the ...
1
vote
1answer
143 views

SharePoint Online Azure SQL Database External Content List Error

I have an Azure SQL database created. I also have fallowed the steps listed hereExternal List from a SQL Azure table with Business Connectivity I have also created an external list on my SPO site. ...
4
votes
1answer
1k 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
1answer
104 views

Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information

I am trying to create a new external content type using SharePoint Designer, whenever I am trying to add WCF connection I get an error message as "Unable to load one or more of the requested types. ...
4
votes
1answer
3k 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 ...
0
votes
1answer
133 views

External Content Type - Large List (5k or more)

I setup a external content type for a list that has ~ 6k rows (SalesPerson). I have setup the list threshold to be 50k in central admin so I can test this. I am not able to return any data when I try ...
3
votes
0answers
232 views

SharePoint external list (sql) with multi lined text field

I have an external content type with one of the fields having huge text in it. (SQL type: varchar(MAX)). When I create the external list and open a new form, the field is a single line textbox and it ...
3
votes
1answer
518 views

How to change the external content type of a list?

I have a webpart that consumes and displays items from a list that has an external content type. The problem is that the list is consuming the wrong font and I would like to know If it is possible ...
0
votes
1answer
84 views

BCS Question (scenarios when data source is unreachable)

I have a few real-world (hopefully simple) BCS questions for on-premise database and SharePoint Online (O365) connected by OData web service: In the scenario where the data source is unavailable/...
1
vote
0answers
355 views

Business data connectivity metadata store is currently unavailable

When I tried to add External Content Type via sp designer, I got following error "business data connectivity metadata store is currently unavailable". sp2013. I've tried many common solutions, ...
1
vote
1answer
421 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....
3
votes
1answer
4k views

External Content Type in SharePoint Online

Can we create external content type for SharePoint online environment? If yes then how can we create it using visual studio 2012? Any suggestion or anyone have done something like this? I have a ...
1
vote
1answer
1k views

Business Data Connectivity: error when saving External Content Type due to invalid assembly or codebase

I am trying to create an external content type that will be connected to a SOAP webservice using SharePoint Designer. To do this, I added a WCF Connection in the Operation Designer section with the ...
3
votes
3answers
15k views

Create External Content Type - Access denied by Business Data Connectivity

Following the technet articles on how to get external data into SharePoint 2013 (for testing purposes) I've created: Business Data Connectivity Service with Metadata Store Permissions Secure Store ...
2
votes
1answer
116 views

Issue with SP2013 External List ID Column and SP2013 Views

I am having a weird issue with an External Content Type ID column when added to the view causes the view to drop into SP2010 branding (with new button at the bottom). When I remove the ID from the ...
2
votes
1answer
2k views

Create External Content Type in SharePoint 2016

I would like to crawl (Search) a custom database/table using SharePoint 2016. I know this is possible and doable using SharePoint Designer. What I am wondering is since Microsoft has discontinued, ...
2
votes
0answers
1k views

Sharepoint external list problem

I'm taking my first crack at creating an External list in SharePoint 2010. I've taken 3 training classes in SharePoint 2010, and am now trying to transfer my knowledge to my own development ...