January 11, 2016 at 1:08 pm
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
January 14, 2016 at 1:27 am
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
January 19, 2016 at 5:15 pm
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.svc
on 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
January 20, 2016 at 1:38 am
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply