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

learn more… | top users | synonyms

0
votes
1answer
696 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
701 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 ...
2
votes
1answer
2k views

External wcf (Soap/rest) datasource to external content type

I'm looking for a way to use an external datasource (WCF SOAP or REST) and include the results in a list. Using the External Content Type directly for a WCF service does not work, as I get a XML error ...
1
vote
1answer
1k 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 ...
1
vote
1answer
18 views

External Content Types Error

I want to get data from SQL Server 2013. I created Business Data Connectivity Service. Then I click the External Content Types but I get error.
3
votes
1answer
687 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
0answers
32 views

Data not showing in External list of SharePoint 2013 site

I have created external content type using stored procedure. Also created read list operation, as well as read item operation. But the problem is that the stored procedure that I have created is ...
1
vote
1answer
925 views

Throttled While Crawling Large External Databases

I created an ECT using SPD2013 last week. It connects to a SQL DB while using the Secure Store to impersonate a domain user for a particular DB View. Last week, I used my personal (farm admin) ...
1
vote
1answer
42 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 ...
0
votes
0answers
30 views

New “Read List” operations is not showing on external list

I am working on a SharePoint 2013 environment. We use external data to display contact information. To use some other Data we created a view on the SQL-Server and added a new Read List operation for ...
1
vote
0answers
47 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
2answers
414 views

How to do a Filter in a BCS External Data picker

I am using an OData web service with BCS (testing with Northwind) and I would like to define some filters when using the External Data picker. I'd like to be able to have a drop down that then ...
3
votes
2answers
952 views

Search in External content type

I am new to SharePoint. I am trying to add a search box to a list but I can't figure out how to do it. I have added an external content type and want to be able to search in it. So what I did was ...
1
vote
1answer
29 views

External Content Types Office 365

I've the following: In the cloud = SharePoint (office 365) On-Premises = SQL DB's that I want to connect to from SharePoint Is it possible to connect to my On-Premises SQL DB's?
2
votes
0answers
85 views
1
vote
2answers
5k views

Why won't the “New Item Form” create for an external list?

I'm using SharePoint Foundation 2010 and I have an external list created from an external content type. The external content type uses a WCF service as datasource. The WCF service has only three ...
0
votes
0answers
19 views

Doing some actions into multiple Item of External list

I have an external list of Microsoft CRM 2011 Accounts in SharePoint 2013 (By BDCS Service). In SharePoint 2013 environment I want to select some items in this External List and apply an action to the ...
2
votes
2answers
33 views

Trouble updating rows of data in an External Content Type using Javascript

I've tried a few different ways of doing this, including querying the External Content Type and then updating the current item. However as far as I ever get is an undefined variable error. This is my ...
1
vote
0answers
34 views

How to correctly update specific columns in an external database through an ECT?

Here is the scenario: I have an External Content Type based on a specific table in an external DB. The table itself has 33 columns, my ECT exposes a total of 13 of those columns, 7 as read-only and ...
1
vote
0answers
24 views

BDC update operation fails with socket exception

I have set up an external content type in my BDC Service, and I am using the Secure Store Service to provide the database credentials. In the ECT I have set up Read Item, Read List, and Update Item ...
0
votes
0answers
18 views

External ContentType to a public JSON feed

I had expected it to be easy to link to an external JSON feed by now (last time I did BCS was with SP2007) but SharePoint Designer (I don't master VS) only has: What would be the easiest solution ...
0
votes
0answers
18 views

External content source as a ContentType refiner

In SharePoint 2013, when crawling an external database, how can you include the crawled items as a content type in the ContentType refiner?
0
votes
0answers
22 views

map External Content Types

I need to be able to map External Content Types/Columns to Sharepoint Columns or Lists. Basically, I need to be able to ‘marry’ lists/columns in SharePoint with External data. Best I can tell ...
0
votes
0answers
13 views

Need Help Understanding External Content Types

I need to be able to understand how to create an External Content type based off of Stored Procedures. All example I have seen thus far show me how to create using 'Create All Operations' using a ...
0
votes
0answers
11 views

External List doesnt 'see' External Content Types

I have created a few External Content Types in which standard lists find easily as an 'External Data' column type. However, a 'External List' doesnt see any of these external content types. I dont ...
0
votes
0answers
19 views

Create external content type with sql server

I need to have an external list in SharePoint 2013, i found a lot of tutorial but. I need that my external content type has a unique authentification to my sql tablE. i don't want connection to the ...
0
votes
0answers
48 views

External content type data retrieving error in SharePoint Online

I followed this page to create an external content type in SharePoint Online and add a Business Data List Web Part to read data from this external content type. But it displays an error, it says An ...
1
vote
0answers
24 views

How to enable quick edit in an External List?

I know, it is not supported. I am in the process to customize a ECT list view with access to enable the quick edit function.
1
vote
0answers
15 views

How to tell an ECT developed in VS to use credentials from Secure Store Service?

I am trying to develop an External Content Type using Visual Studio so I can use External Data Source columns in a SharePoint list. Most of the stuff I am finding online uses Designer, but I don't ...
0
votes
1answer
58 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 ...
1
vote
0answers
21 views

Display SQL Server data in Sharepoint with the ability to Drill Down

Metadata External List Users need to see & update metadata information about user databases via sharepoint. Users open a Sharepoint site and look for metadata Information Data being pulled from ...
0
votes
0answers
38 views

External content type add connection to a rest api

Is there a way to connect an external content type to a third party rest API? If so how? I have tried to find information about this, but have only found methods to using rest to get data out from ...
0
votes
1answer
76 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
145 views

BCS Managed Client Code Get all method instances

When using the class Microsoft.BusinessData.MetadataModel.Entity entity; does anyone know how to get all the External Content type operation method instances so i can dynamically pass the value to ...
0
votes
1answer
265 views

SharePoint Online Hosted App get List Items from within app

I have a Visual Studio 2013 solution and I have been successfully able to get list items from the host web using the following JavaScript code: var context = SP.ClientContext.get_current(); ...
0
votes
0answers
10 views

Custom Data Provider for External Content Type

I have a several data services and I want to add them to SharePoint portal. I found that I can create an external content types for that. All tutorials says that External Content Type can be created ...
0
votes
2answers
522 views

InfoPath does not support customizing the form used for this list.

How to enable this feature? "InfoPath does not support customizing the form used for this list." I want to edit the form in infopath and publish it back to SharePoint.
0
votes
1answer
57 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 ...
1
vote
1answer
96 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 ...
0
votes
2answers
54 views

External Content Type - SQL - Filters

I create a new external list via a new external content type SQL . I retreive my data and i can display it. BDC Service allows us to view 2000 items . 1st Issue: I can filtered through a ...
0
votes
0answers
41 views

External Content Type based on SQL View allow insert/update/delete

I have two tables in SQL, one of them is read only (it is the "master"). The other is a detail table. They are joined on column 'VNO'. It is constructed with a left join on the master table, so ...
0
votes
0answers
35 views

External Content type column causes an error in the list view

I have a siet column/field of External Data type called "ABVictName". The problem with this field is that whenever I insert it in the List View it throws an error. In the logs I found this message: ...
0
votes
1answer
32 views

How to make user edit data in business data list?

I set up a business data list to get data from SQL server through external content type. It works very well and users are able to see the data from SQL server on their SharePoint UI. But now I'm ...
0
votes
1answer
61 views

Dynamically creating SharePoint 2013 external content type

Background: There is requirement of calling external list from SQL to SharePoint 2013. We have done it using BCS, external content Type and SecureStore. There are also some modification done using ...
0
votes
1answer
49 views

Apps cannot use External Content Types defined in the Business Data Connectivity Shared Service Application metadata catalog

My issue is getting Unauthoraized exception while accessing external data in workflow 2013 context throw REST call (HttpSend). I read several posts suggests to create BDC model inside App package, ...
0
votes
0answers
13 views

SharePont Workflow initiated automatically on item create via email not able to read from external list

I created a custom SharePoint 2010 workflow using SharePoint designer for a 2013 SharePoint environment. My workflow needs to read data from an external list, and works flawlessly when the workflow ...
0
votes
1answer
232 views

Could not save the list changes to the server

I have an External List in SharePoint 2013. I am trying to create a new Edit Form in SharePoint Designer but unfortunately it is throwing Could not save the list changes to the server error instead of ...
0
votes
0answers
25 views

Sage 50 Accounts Integration

I want to import Sage 50 Accounts information into my SharePoint Online environment as an external content type. Can this be done? Thanks
0
votes
1answer
64 views

ReadOnly columns in External List: SharePoint 2013.

I want to make some fields ReadOnly in External List in SharePoint 2013. I have tried JavaScript and SPUtility approaches as guided in this blog, but unfortunately did not work. In SharePoint ...
0
votes
0answers
75 views

External Content type failed to save, The name domain\username cannot be resolved via Active Directory

I get the below error when I try to edit the external content type through SharePoint Designer. The Name Domail\username, is no longer with our organization. I believe he created this External Content ...