Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [external-list]

An external list is a list published outside of the scope of SharePoint usually with the tool Business Connectivity Services (BCS).

0
votes
2answers
27 views

SharePoint migration - External List

I am doing a migration (mostly content) from SharePoint 2010 to SharePoint Online. There are a couple of External lists spread across the site collections. Any ideas/recommendations on how I should ...
0
votes
0answers
29 views

external data source filter with multiple values

I've an external list with data from a SQL database. I got some IDs (by querying a custom list) and want to get all items of the external list where those IDs match. The external list is very large so ...
0
votes
1answer
31 views

Workflow will not create an external list item

I have an external list in Sharepoint Online that is connected to SQL server (Azure) via BCS and secure store. I can manually add/edit items and it they immediately show up in the DB. I built and ...
0
votes
1answer
214 views

BCS External List CRUD operation using REST API on SharePoint 2013

Can we have CRUD operation on SharePoint External List Based on SQL Server using Rest API with Jquery on SharePoint 2013 On Premise. This link says it possible. But need more advice on this
0
votes
0answers
23 views

Can't get External List to use InfoPath Form

I have an external list which uses an external content type tied to a SQL Server table. Everything with the connection works fine. I can open a browser window in SharePoint and using the default ...
0
votes
1answer
84 views

Very slow external list based on SQL Server

I am using SharePoint 2016 on premises. This is a new farm with installation done just now. I created BDC to fetch data from SQL Server view. That view contain less than 8000 records. Then I created ...
1
vote
1answer
121 views

Bind dynamic DropDownList in new form (external lists involved)

Short version of the question: I am dynamically building the option list of a DropDownList based on a selection from another DropDownList with jQuery. How do I bind the new option list so that it will ...
0
votes
1answer
87 views

Sharing Sharepoint News with Digital Signage Screens

We have an intranet site where we carry employee news, announcements and vacancies. We also have screens for our front line staff running ScreenCloud. I was hoping to output RSS feeds from our lists ...
3
votes
2answers
152 views

2 ways Communication required from SAP to SharePoint

I need to to get the data from SAP to SharePoint, and on performing CRUD operations via Lists from SharePoint. The updated data should also get effected in SAP. Can anyone help me in knowing how I ...
0
votes
1answer
80 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 ...
2
votes
1answer
48 views

Display a standard grid for a external list connected through BCS

Environment Sharepoint 2016. Visual Studio 2017. Sharepoint Add-In in a hosted environment. Requirements Display an external list connected through BCS in a standard grid view with possibility of ...
3
votes
1answer
622 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 ...
1
vote
2answers
114 views

Search External List Web Part

I have a SharePoint 2010 on-prem site with 2 external lists and I want to add web parts of those lists on a landing page with search boxes for each list that displays the results in the web part. How ...
2
votes
1answer
56 views

“Export to Excel” - Database Connections Data - SP2010

We have few "Database Connections" created in SP Designer 2010 and I used the "Data view" web part to display the database connections' data. Is it possible to export this data to an excel?
1
vote
0answers
208 views

Sharepoint DataFormWebPart and ListFormWebPart validation SP2016

I'd like to add some custom validation to custom NewForm for external list. The default new item form has in the ZoneTemplate ListFormWebPart but if i add a new form in SPD2013 there is ...
1
vote
4answers
188 views

Alternative to BCS in SharePoint 2013

My requirements is to consume external data in SharePoint 2013. One of the option I know is SSIS, this is a lot of work. I wanted to know if you've achieved something similar using other methods. ...
1
vote
1answer
108 views

External List shows only BDC Identity

I have created an external list called Employees. When I go to site contents, I see Employees and when I click it, I see the exact contents I expect. When I create a new page for my site and insert ...
1
vote
1answer
380 views

How to identify data source for external list?

I'm a SharePoint noob, using SharePoint Designer 2010. There's an External List that is pulling data from a MS SQL server. How can I find out what database and table it's querying?
0
votes
1answer
93 views

External list from SQL database with more than 2000 rows

I created external list in SP2013 which has more than 2000 rows but I still cannnot read it all, error is: Database Connector limited response. The response from the database contains more than 2000 ...
0
votes
0answers
74 views

Exernal List /BCS and OData Performance Issue

I'm having issue with the peformance of loading a single record being queried using REST API against an External List. I'm using REST API and Jquery Ajax call. The the underlying Data Source is a ...
1
vote
0answers
52 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 ...
0
votes
3answers
198 views

Still getting Odata Service Connector Throttle Error - Already tried Set-SPBusinessDataCatalogThrottleConfig

I've already tried powershell to reset the throttle value as well as disabled it completely: This disables a throttling rule. Set-SPBusinessDataCatalogThrottleConfig -Identity $dbRule -Enforced:$false ...
1
vote
0answers
103 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
56 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 ...
2
votes
1answer
303 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
377 views

How to fill External Item picker using jquery?

Set value of a SharePoint 2013 BDC External Item Picker field using JQuery I want to fill customer name using jquery. How can fill this when page load?
0
votes
1answer
51 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 ...
0
votes
1answer
814 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
102 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
209 views

Read External List (BCS) Data in SharePoint Hosted App

I have this SharePoint hosted app on SharePoint Online. In this app, I am able to read the data from any SharePoint List/Library using the REST calls. However, when I try to fetch the items from a ...
0
votes
1answer
93 views

How to create a Sharepoint 2013 form to update a Sharepoint SQL database

I have a SQL database, I have created an External Content Type and an External List for the Table. I can see the list in SharePoint. I would like to be able to change the form to add a new instance ...
2
votes
1answer
61 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 ...
0
votes
0answers
25 views

Share external list with external users in office 365

can we share external list with external user in Office 365.
1
vote
0answers
40 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, ...
2
votes
1answer
5k views

Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’ in BCS

I have already configured BSC service in SharePoint 2013, I created an external content type in SharePoint Designer, everything is ok. But unfortunately, When I tried to browse an external list from ...
2
votes
0answers
81 views

Reading data from a external list using a 2010 workflow

I work with SharePoint 2013, and need to read information from a external list that I have created. The list can display information correctly when using it through the browser. I need to create a ...
2
votes
0answers
166 views

Display additional fields on forms (External lists)

I have a external list where I have employee information. I am trying to do a lookup where I can select the employee and display it's corresponding department with the additional columns possibility. ...
0
votes
1answer
440 views

Show filter choices error on external list in SharePoint 2013

I have an external list on SharePoint 2013 migrated from SharePoint 2010. There are about 1500 items in the list. When I click to filter a text column it gives me the option to "Show Filter Choices". ...
2
votes
1answer
36 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.
1
vote
3answers
4k 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
vote
1answer
219 views

SharePoint 2010 bcs item limit

I have an on premise SharePoint 2010 implementation. I need to implement a custom form with 65 fields which has rich text, drop downs and some complex filtering logic on the form. I want to load the ...
3
votes
4answers
328 views

Approaching to have a third part web application inside SharePoint 2013

I am working on SharePoint enterprise server 2013, and I am trying to find the best approach I can follow to achieve this requirement:- Our customer has a web page which list their employees info. ...
0
votes
1answer
816 views

SPServices GetListItems from External List causes HTTP 500 Internal Server Error

My function only works when I'm using my SP_ADMIN user. But when I'm using another user I receive the following error message from the console: 500 (Internal Server Error) What's wrong with this ...
0
votes
2answers
86 views

List where only some columns are confidential

I have created an external list which is drawing data from a single table in an Azure SQL Database (SAAS). Two external content type operations: List & Read Item. This is a generic list ...
1
vote
1answer
390 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....
2
votes
1answer
260 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 ...
1
vote
0answers
1k 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
1answer
190 views

Put external List data into a Drop Down

I am developing an app for my site. I have an external list that displays all the data i need fine. I need to somehow get that data in Visual Studio 2013 so i can loop through the data and create a ...
1
vote
1answer
148 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 ...
3
votes
0answers
292 views

Event receiver on external list

Recently I am working on a project to set event receiver on external list. Below list what we have done Create trigger to capture data change in database and log them into data table Implement ...