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).
307
questions
0
votes
1
answer
23
views
BCS: get notified when data is changed in sql server?
We were using a sharepoint 2019 list as logging list and we moved that to SQL server. Then using BCS we are only reading the data from SQL and displaying in sharepoint using External Content Type and ...
- 11
0
votes
0
answers
10
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
13
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
25
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 ...
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
40
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
63
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 ...
- 307
0
votes
1
answer
79
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
43
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
382
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
21
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 ...
- 2,284
0
votes
0
answers
215
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
237
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
2
answers
2k
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
134
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
57
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.5k
1
vote
1
answer
114
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 ...
- 41
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 ...
- 11
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 ...
- 111
1
vote
1
answer
63
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
195
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
236
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 ...
- 157
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 ...
- 157
1
vote
1
answer
1k
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, ...
- 11
3
votes
0
answers
311
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 ...
- 468
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
843
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
220
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
59
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
48
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,136
1
vote
0
answers
127
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;
...
- 31
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 ...
- 31
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 ...
- 326
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
622
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 ...
- 95
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 ...
- 209
1
vote
0
answers
111
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
57
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
392
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