Questions tagged [external-content-type]

A variation of a content type that stores content outside of SharePoint. External Content Types are part of the configuration for Business Connectivity Services (BCS).

Filter by
Sorted by
Tagged with
0 votes
0 answers
9 views

Linking sharepoint library to external site

I am very new to SharePoint, so I'll try to simplify my query as much as possible. Our foundation runs a Microsoft team within our university team's framework. We have a lot of files in that team. ...
0 votes
0 answers
11 views

Imported BDC file using CA not showing up in SPD

We're in the process of moving an application/site from 2013 to 2019. I do not have CA rights but had an admin import the .bdcm file into the 2019 environment that I exported from 2013 using SPD. He ...
0 votes
1 answer
14 views

Importing Data from Excel to Sharepoint (External Data field)

I have a list containing external data columns. I have an excel file that has values for external data columns. I want to bulk update via Powershell. When I try to update the value from excel to ...
0 votes
0 answers
10 views

SharePoint Designer BCS Prompts The Secure Store Credentials

I am trying to setup BCS Connection to a SQL Server Database Table and I have setup Secure Store Target Application. Now I am trying to Create External Content Type from SharePoint Designer where I ...
  • 416
1 vote
0 answers
20 views

External Content Profile Pages in Sharepoint Online

My institution is migrating to SharePoint online from an on-prem 2016 environment. One thing we currently rely on heavily is getting an ECT into the existing 2016 site and having a profile page for ...
0 votes
0 answers
39 views

SharePoint designer craziness

I am using SharePoint Designer 2013, when I try to add an external system in the external content type dialog, it adds the system, I can browse databases and routines. If I try to browse views then ...
  • 1
0 votes
2 answers
53 views

Pass parameters to external list on SP2019 Standard

I have an external list that is displaying data from a SQL Server view. Now, I want to add filtering. The problem is that I'm working on Standard version of Sharepoint, so no Enterprise webparts are ...
  • 297
0 votes
1 answer
64 views

To add a new column in the external list

I have created external list to retrieve SQL data into my SharePoint via External Content Type (ECT). Everything working fine till here but the problem is when ever i want to add a new column to the ...
0 votes
1 answer
41 views

InfoPath form not opening in browser while using BCS external content type

I am using external content type in InfoPath form in SharePoint 2016 and the form doesn't open in browser. How could it be solved?
  • 1
0 votes
0 answers
318 views

External content type not visible

I created external content type in my SharePoint 2013 site to get data from sql database. Now I want to change the connection but I cannot see my old external content types in the designer. Any idea ...
  • 156
1 vote
0 answers
20 views

How to update the External Content Type of existing column

I have a list with multiple columns as the type of External Data. There are some changes in the External Content Type. so I want to update the reference for some of the columns. But I am not able to ...
0 votes
0 answers
187 views

Creating external content type using wcf service for SP Online BCS using SP Designer 2013

I have created WCF Service and I am able to generate WSDL URL and Endpoints when I use SharePoint designer 2013 to Create external content type to connect to SharePoint online BCS It does not show any ...
0 votes
1 answer
214 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 ...
1 vote
1 answer
1k 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? ...
  • 267
0 votes
1 answer
109 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....} ...
  • 1,183
1 vote
0 answers
55 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 ...
  • 12.4k
1 vote
1 answer
112 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
1 answer
50 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 ...
1 vote
0 answers
30 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
1 answer
60 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 ...
  • 13
1 vote
1 answer
189 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. ...
  • 155
0 votes
1 answer
226 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. ...
  • 1
0 votes
1 answer
183 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 ...
4 votes
2 answers
3k 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 ...
3 votes
1 answer
1k 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 ...
1 vote
1 answer
978 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, ...
3 votes
0 answers
306 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 ...
2 votes
1 answer
165 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 ...
  • 21
4 votes
1 answer
826 views

Update column having external data as data type using CSOM

I have a list which contains a column having data type as "External Data". I want to update that particular column using CSOM. I have tried below code: ClientContext clientContext = new ...
  • 722
3 votes
1 answer
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, ...
  • 795
-1 votes
1 answer
219 views

Secure Store Target Application (Group) Setting credential owners to Everyone gives Access Denied error

I'm using an external content type in Sharepoint 2013. As part of setting it up, I have setup a Secure Store Application ID. While setting up a secure store application ID, I've set it to Type = Group,...
  • 101
1 vote
0 answers
192 views

Connect from external list from different site collections via OData in SP Online

I am using SharePoint Online and I have followed the steps of the tutorial: But the OData service url was the list of the second site collection. https://myTenant.sharepoint.com/sites/Site ...
  • 291
1 vote
2 answers
88 views

Error with Create Method on External Content Type

SharePoint 2013 I have an External Content Type (ECT) defined for a table in a SQL Server database. I also have the usual CRUD methods defined for the ECT. The table has over 50 fields, but there is ...
  • 61
1 vote
0 answers
49 views

How to pull data on to SP Online from an external source without Azure instance?

I am new to SharePoint Online, so checking is there a way to connect and pull/push data from an external data source like (SQl on prem, Chatter) on to SharePoint Online through BCS or External content ...
  • 489
7 votes
2 answers
7k views

BCS in Sharepoint Online

What are the features and limitations of BCS in Sharepoint online. Can we create an external content type using Stored procedure in Sharepoint online.
  • 83
1 vote
0 answers
57 views

Get foreign key in external content type to show up in list view using Visual Studio

How can I setup external content types in such a way that when in the list view of these external content types, I can jump between and possible lookup values to that other type? Note: No 3rd party ...
  • 152
1 vote
1 answer
47 views

What is SystemType.Database in LobSystem?

I am trying to create external content type programmatically with SharePoint 2010. Here is the MSDN link which I am using for reference. I have created a console application and put the same code as ...
  • 1,126
1 vote
0 answers
125 views

External Content Type : How to display label on lookup columns (without unable edit / new form)?

I have a SQL Server Table A with a foreign key with reference to B : id_A [int auto_increment PK] name [varchar()] ref_B [int FK_ref_to_B] I try to display A in an External List based on External ...
  • 11
1 vote
0 answers
39 views

the web server cannot connect to specified data source

I have been trying to connect to a OLEDB data source using SharePoint designer custom connection string and receiving an error. Provider=myProvider;Data Source=myPath;Initial Catalog=catalogName; ...
0 votes
1 answer
33 views

Display the Business data that reside on PDW to sharepoint list

I was trying to display the Business data that reside on PDW or APS (parallel data warehouse), to SharePoint list .And to do so I tried to connect to the database server using SharePoint designer ...
1 vote
0 answers
93 views

Can not retrieve sql server routine return parameter schema information

I am trying to create an external content type on Sql stored procedure in sharepoint 2013 and getting the following error: Invalid Object Name '#...' .Can not retrieve sql server routine return ...
  • 83
0 votes
1 answer
26 views

SharePoint external content type using SharePoint hosted WCF (inside layouts)

I have some requirements to create external content type using WCF service which is hosted into SharePoint layouts folder. I get error while creating external content type into SharePoint designer ...
1 vote
0 answers
70 views

External Content Type from an OAuth2 secured REST data store in SharePoint Online

Is it possible to create an external content type that accesses a RESTful data store which requires OAuth2 authorisation without building a proxy website in between?
  • 133
2 votes
1 answer
619 views

Failed to create list item for external list using REST API POST

I've AN OData API, which I'm consuming in SharePoint via BCS and External List. I already have the Get and Update functionality working using REST API to external list. But when I try to add an item ...
0 votes
1 answer
83 views

Sharepoint 2013 BDC IEnumerable<T> VS List<T>

When I follow this walkthrough for External Content type I am not able to register the ECT in SPD with the following error This operation is based on a method with complex data types in its ...
1 vote
0 answers
110 views

BDC Incremental crawl always crawls full

I added External Content Type to my BCD application. The content type gets data from SAP trough a service. There is a column/property in the service called PartnerChangeDate, that is set to last ...
  • 2,165
0 votes
1 answer
50 views

Show name property of associated external content type in display/edit form

I have an external list. The underlying external content type has an association to another external content type. The content types are built in sharepoint designer. When I edit the item - the ...
  • 113
1 vote
2 answers
361 views

How do I configure The Business Data Connectivity Service Application?

I'm currently trying to add an external content type. In order to do this I've read that I need the Business Data Connectivity service running. I have tried Provisioning the service but it ends up in ...
  • 137
1 vote
1 answer
27 views

How to add External Content Types?

Hi All, I am currently having an issue with trying to add External Content Types. My error is in the pic provided. Any help will be appreciated. Thanks.
  • 137
0 votes
1 answer
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 ...
  • 31

1
2 3 4 5
7