Questions tagged [bcs]
Microsoft Business Connectivity Services (BCS) (formerly named the Business Data Catalog) provides the capability to allow data sources outside of SharePoint to be surfaced and potentially modifiable in SharePoint's List user interface. Use this tag for questions or problems related to configuration or using BCS.
386 questions
0
votes
1
answer
108
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
1
answer
73
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
44
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
1
answer
100
views
Unable to access data from external list by REST API
I'm trying to retrieve items from external list by REST API. The external list displays data from SQL Server view. Unfortunately I always get error saying that the list does not exist. This happens ...
- 317
0
votes
2
answers
123
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 ...
- 317
0
votes
1
answer
64
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
276
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
50
views
SharePoint training options
I'm looking for training in the SharePoint 2013/2016/2019 on-premises sphere with specific concentration on BCS solutions developed using JSOM and REST models.
Does anyone have a recommendation they ...
- 25
0
votes
1
answer
479
views
How we can read External SharePoint List data using Rest in SharePoint 2016/2019?
I have a SQL database, I have configured BCS service in my SharePoint, using SharePoint Designer. It's means Now i have External list.
What I want, i want read and insert this external list data ...
- 435
1
vote
1
answer
153
views
Microsoft Flow vs BCS/ECT to keep an Azure SQL table in sync with an SPO Modern List?
We worked with BCS (Business Connectivity Services) and ECT (External Content types) a while back and did not like it. Seemed like a lot of overhead maintaining the map. If the goal is to keep a ...
- 1,299
0
votes
1
answer
155
views
Access denied when trying to get SPListCollection out of SpWeb in BCS connector
I have a BCS connector.
In a constructor of its service class I want to access a SharePoint list.
using (var site = new SPSite("My site URL")
{
using (var web = site.RootWeb)
{
var ...
- 178
1
vote
0
answers
71
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.9k
0
votes
1
answer
79
views
Using the REST API to view an External Column in a list (Not an External List)
I have done some research and it does seem possible to read an External List, but I am trying to read an External Column within a regular list. How can I use the REST API to view an External Column (...
- 109
0
votes
1
answer
188
views
Copy BCS Field from a list to another list using powershell
My problem is when copying items from a list to another, i can see the BCS field in the Display form(the value of the BCS in the display form is correct) but not in the Edit form(the text box of the ...
- 513
1
vote
1
answer
270
views
Update all BCS Field in SPSite using Powershell
When i delete an item in my external list, it's not deleted automatically from the list where i use the BCS Field. I have to click Refresh. I'm using this BCS in many lists.
I'm looking for a ...
- 513