Questions tagged [external-content-type]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
13 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
14 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
8 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 ...
1
vote
1answer
29 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
0answers
16 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
27 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
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 ...
1
vote
1answer
79 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
1answer
26 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 ...
1
vote
0answers
25 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
19 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
141 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. ...
0
votes
1answer
101 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. ...
0
votes
1answer
126 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
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 ...
3
votes
1answer
496 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
0answers
345 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
0answers
230 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
1answer
112 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 ...
4
votes
1answer
537 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 ...
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, ...
-1
votes
1answer
148 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,...
1
vote
0answers
175 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 ...
1
vote
2answers
75 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 ...
1
vote
0answers
43 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 ...
4
votes
1answer
5k 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.
1
vote
0answers
56 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 ...
1
vote
1answer
38 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
vote
0answers
115 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 ...
1
vote
0answers
36 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
1answer
30 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
0answers
70 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 ...
0
votes
1answer
23 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
0answers
55 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?
2
votes
1answer
383 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
1answer
56 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
0answers
86 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 ...
0
votes
1answer
34 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 ...
1
vote
2answers
245 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 ...
1
vote
1answer
25 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.
0
votes
1answer
974 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 ...
0
votes
1answer
120 views

Create list view with unlimited items

We have a requirement in SharePoint Online to create list view that can view more than 100,000 items. We have a custom list synchronization with email, and there are more than 16,000 item creates ...
1
vote
0answers
95 views

Infopath 2013 and a list in another site collection

I have a host-based site collection A which has a custom list A and a site collection B with a list B where I would like to have a lookup field to the list A. Usually, I think you can try this with ...
2
votes
1answer
67 views

Creating External List [closed]

I have been asked to research External Lists. After exploration I came to know that in order to use data which isn't there on SharePoint we make use of External List. Now can anyone tell me a real ...
1
vote
0answers
44 views

Query BCS Connection to Update a SP 2013 Library

I have a requirement to update a SP 2013 Library (let's call this Test Library) The requirements are detailed below: Update all items with a Status = Created If Status = Created update: Name, ...
0
votes
1answer
89 views

InfoPath 3 DropDown pull inforamtion based on selction

I'm working on a form and am in need of some assistance. I used the following link, as a reference when I was creating this form I have three separate drop-downs (Name, Address, Phone Number) When ...