We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [external-data]

External data refers to data that isn't under the management of SharePoint, but is made visible through crawl, indexing and search of the external data source.

Filter by
Sorted by
Tagged with
1
vote
1answer
815 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 ...
2
votes
0answers
18 views

Create, read, and update from SQL table to on-prem SharePoint 2016?

Ultimately I would like to create an external list that can be customized (i.e., partly columns from a SQL table and partly native SharePoint columns). BCS isn't an option because it would not let me ...
0
votes
1answer
48 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 ...
0
votes
1answer
78 views

read data from external SQL database

What's the best approach for reading data from external SQL database? build web services and call it in web part using ado.net and read data directly in web part using external list and read data ...
0
votes
1answer
92 views

set BCS field using powershell

I have an external data field. I have to copy the value from list to another list. How i can set the value in the other list? $web = Get-SPWeb http://intranet/CAC/RestrictedAreaManco/ $listProspect = ...
0
votes
1answer
12 views

Synchronize BCS when item is deleted from source

I have a contact list where i store all my contacts info. In my subsites, I have lists where i created an External Data Column which is referenced to the Contact list. The Problem is : When i delete ...
1
vote
1answer
346 views

Save data to SharePoint list from external website

I have a web page running locally on my machine which hosts a bunch of forms for different requests, built using HTML/CSS/JS (AngularJS). I want to export that data to a SharePoint list when a user ...
1
vote
1answer
146 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. ...
-1
votes
2answers
911 views

Fetching external data into SharePoint online sites

Is it possible to get data from external sources into SharePoint online sites? I suppose rest API's is an option, but how can that be done? Any suggestions would be much appreciated.
0
votes
1answer
129 views

Update External Data Field in SPD workflow

I created a Workflow in SharePoint Designer that create an item in a List B that was created in List A. The issue that the creation is OK. but when i Update the item, the workflow not delete the old ...
1
vote
1answer
68 views

SPO Search from external DB

The scenario is this (in SharePoint Online): I am trying to implement a search box, in our Intranet Page, that is connected to an external database. This is just a small DB with people's names, phone ...
1
vote
0answers
32 views

Create a Key Filter from an External Data column

I'm currently creating a Document management system in On-prem SP 2013 to store documents with specific meta data terms so the document library is easily searchable/filtered. We have an external DB ...
3
votes
1answer
537 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 ...
2
votes
1answer
70 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
71 views

Business Connectivity Service on Sharepoint online-How to link with external data source?

We have a sharepoint online(O365) solution,now we are maintaining all our dept user data in a virtual db in our dept itself,i just want to know how to connect our sharepoint site to that data source ...
2
votes
1answer
42 views

Does external column data refresh change list items' modified and modified by?

I have SharePoint list having External Data column. Now I want to refresh that column data. I can do it through UI using refresh button at top on the column. But I am not sure whether it will change ...
4
votes
1answer
558 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 ...
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 ...
0
votes
1answer
395 views

Data from oracle db to sharepoint 2013 list

I want to get data from oracle to sharepoint 2013 list.I need one way sync only i-e from oracle to sharepoint list.Is there any way other than BCS or BDC? can i do this using web services and jquery ...
0
votes
1answer
39 views

Connecting to external data sources like sql database and exchange

I am looking for the best options on connecting my SharePoint list with external data sources like SQL database and exchange servers to update the contacts list automatically. I am using SharePoint ...
3
votes
0answers
513 views

Excel Services: Configuring Data Refresh for an External Workbook Data Source

Honestly, configuring this has been such a hard experience. I encountered many errors already, one after another but am stuck now. To illustrate what I've come across so far, I've had problems with ...
0
votes
1answer
47 views

Does Excel Services support connecting / refreshing external data that comes from another workbook?

I'm testing Excel Service via the Excel Web Access Web Part. I managed to make a working sample of a chart that retrieves its data from a SharePoint List. However, for some reason, I can't make a ...
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
266 views

Inserting an External Link in Page Viewer Webpart in SPS 2013 gives warning

Inserting an External Link in Page Viewer Webpart in SPS 2013 gives warning. Warning Message: Only Secure content is displayed. Gives an option to click on a button name: show all content Please ...
1
vote
1answer
1k views

POST Request through WebProxy with JSON data

I want to make a POST request with JSON data to a REST API through the WebProxy. Therefor I make a request like: $.ajax({ url: "../_api/SP.WebProxy.invoke", type: "POST", data: JSON....
0
votes
1answer
317 views

Lookup column data from another database

I've explored lookup columns, managed meta column, and external datatypes, and I'm either not understanding them, or I haven't found what I'm looking to do, so I'm hoping I can describe my goal and ...
6
votes
1answer
2k views

SharePoint Hosted App Cross Domain Calls to a REST API

I have a SharePoint hosted app and I want to use the JIRA REST API with it. Which means I want to make requests and work with the data from the responses. Because it's a SharePoint hosted app I can ...
0
votes
1answer
91 views

Sharepoint not indexing external site

I have a simple HTML documentation site with a TOC column on the left side that includes all the links on the page. The URLs are structured http://documentation/section1_subsection1_subsection2.htm ...
1
vote
1answer
341 views

Can not refresh external data in Excel file which connected to Postgres via PowerQuery in Excel Web App

We have an Excel file which is connected to a postgres database via PowerQuery. PowerQuery needs npgsql provider for it. When I open file locally on my computer and try to update data - everything is ...
0
votes
1answer
23 views

How to use Sharepoint as a filserver against external programs

I am workig for a survey company and we are starting to implement sharepoint as a fileserver. The idea is that the surveyours working in the field uploads there measerud files to the file library and ...
0
votes
1answer
136 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, ...
1
vote
1answer
502 views

Access is denied when search external SharePoint site

We have an internet (SharePoint 2013) and intranet (SharePoint 2010). I want to have our internet (http://www.example.com) items in our intranet search result. We also have proxy setting. I created a ...
0
votes
1answer
19 views

SharePoint Workflows and Lists, External Housing Dilemma

So I have a client who has arranged for their SharePoint environment to be housed and managed to by an external entity (not my contracting group) and we have limited access to administrative ...
2
votes
2answers
77 views

Using External Data in SharePoint 2013

Hi i am new to SharePoint, i have been given a requirement and i am not able to find the right approach. We have a SharePoint portal which keeps track of employees details, very recently we have ...
0
votes
2answers
143 views

Searching external files on a disk

I have a bunch (1000s) of external files that I want to search using SharePoint search. What is the best way to index these files and get SharePoint to Search them as well when users key in queries?
0
votes
0answers
34 views

Sharepoint with external database

We have a Sharepoint application which uses external database besides content database.we have stored connection string in a list to connect to that external database. everything works fine in a ...
1
vote
1answer
91 views

Crawling external database with security trimming

We have a legacy records management system that we want to index in SharePoint 2013. We just want to index it and leave the documents where they are. The records management system of course has a ACL ...
0
votes
1answer
89 views

External Data Column keeps showing wrong value

I have created an external data column that allows you to search by one of the columns. The column is a string in the following format: number-number. For example, "001-001". I have a large range of ...
0
votes
1answer
72 views

Recommended way to access external data?

There are different ways in SharePoint to access external data (i.e. BCS, custom web service, some might even consider creating a custom service application), but is there a recommended way in ...
1
vote
1answer
6k views

Does sharepoint online support external Data sources

We are looking to migrate to sharepoint online from our current on premise installation and currently have one question that is still unanswered. We use custom WebParts (which we will need if we ...
0
votes
1answer
1k views

SharePoint 2013 InfoPath External Connections with Kerberos

Environment 2 App 2 WFE 1 DB C2WTS account- domain\AppPool (Log on as service/act as OS/Impersonate auth policy on all 4 servers) IIS Kernel mode - off Delegation for the all four servers: Using ...
1
vote
2answers
561 views

Query External Data using BCS

I'm using SharePoint 2013 and I'm developing a webpart that has to query an external data and show the results. I cannot create external list due to the fact that my external table has more than 200,...
2
votes
0answers
2k views

Getting External Data from Oracle to O365?

We have an on-premise oracle database with customer info (lets say roughly 10,000 rows), that we need to make available in our SharePoint Online (2013) environment in O365. The requirement is that ...
0
votes
1answer
287 views

Business Connectivity Services vs. ADO.NET

Why should I prefer Business Connectivity Services (BCS) over plain ADO.NET, if all I want are simple CRUD operations on an external database (e.g. remote Oracle Database), which are made from a ...