Using the OData Source in SQL Server Integration Services
-
I recently read Koen's article here: Using the new OData Source in SQL Server Integration Services[/url]. Looks like it fits my needs. Trying to use it though I have two issues:
1. How can I refer to a particular view of a SharePoint list? (e.g. Customer View)
2. How can I select properties(columns) whose names have embedded blanks (e.g. Customer Name)
Gerald Britton, Pluralsight courses
-
Regarding the white space, you can take a look here:
Regarding the view: no idea. Haven't used views in SharePoint yet. And I try to use SharePoint at the bare minimum
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Koen Verbeeck (1/14/2016)
Regarding the white space, you can take a look here:Regarding the view: no idea. Haven't used views in SharePoint yet. And I try to use SharePoint at the bare minimum
Thanks for that link! Just what I need
one other thing. In the article you state that you allways need
_vti_bin/listdata.svcon the end.
but the free Microsoft site is like this:
http://services.odata.org/Northwind/Northwind.svc/without that suffix. How does that work?
Gerald Britton, Pluralsight courses
-
The first is a SharePoint list exposed as OData, the second one from Microsoft is an actual OData source. Big difference
It's just how SharePoint exposes them.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply