Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Microsoft Sharepoint as Webservice Datasource
SPUSER
Hi,
i want to use lists form MS Sharepoint as DataSource in BIRT.
To access the data, I want to use the WSDL methods, that are provided by Sharepoint.
Does anybody have experience in connecting to Sharepoint via a Webservice?
Maybe you can give me some appropriate informations or documentantions.
Thank you!
Find more posts tagged with
Comments
Virgil Dodson
Generally, you just find out the WSDL URL you want to connect to and use that for setting up the Web Service Data Source in BIRT. I do not know if there is anything else needed or different for SharePoint web services.
Migrateduser
> But unfortunately it's not as easy as you write to get an interconnection between (local) BIRT Report Designer (Version 2.322 or 2.52, whatever) and a sharepoint list (online) - within the WSDL interface. <br />
<br />
Now over a week of disappointments I really need your help, because I think I'm only one step behind a final and hopefully working solution. <br />
My current error message look like this:<br />
=> <a class='bbc_url' href='
http://s1.directupload.net/images/100511/95rz5pbk.png'>http://s1.directupload.net/images/100511/95rz5pbk.png</a><br
/>
<br />
But at first I wanna discribe my activities till I reach that? Wright? okay...<br />
1. I'd create a new project and a new report, with "Simple Listing"-layout.<br />
2. At next I'll add to the "Data Sources" a new one, with usage of the "Web Services Data Source" interconnection, and the following WSDL URL or location: "
http://<site>/_vti_bin/lists.asmx?wsdl"
; / Test connection = Ping succeeded!<br />
3. I've created a "New Data Set", with the Data Set Type from above. I'm choosing the "GetListItems"-Soap-Action (v1.2) from the WSDL Operation list, and choose the both really required SOAP parameters, "listName" plus "viewName". At the next I've inserted the parameters, which a grapped from sharepoint (they are validated...) - The rest of the SOAP request, I leave untouched, okay?<br />
4. And important next step, called "The SOAP response", hm... Maybe thats my problem at all... Because at the top option fields I've do non changes, because the SOAP Schema is be given and (seems to be) valid. And at the bottom, I don't know exactly what I should choose... (Any suggestions?) I think thats my final problem...<br />
BUT at this option field, I've used "Use external sample data file" - That file which I have created automatically by a self-written VB programm, looks like this one... <br />
<br />
<listitems xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns="
http://schemas.microsoft.com/sharepoint/soap/"><br
/>
<rs:data ItemCount="2"><br />
<z:row ows_ID="1" ows_Title="Birt_test" ows_MetaInfo="1;#" ows__ModerationStatus="0" ows__Level="1" ows_owshiddenversion="2" ows_UniqueId="1;#{FCAD553C-6BA2-4177-8423-8766FA8BD672}" ows_FSObjType="1;#0" ows_Created="2010-05-03T12:21:58Z" ows_FileRef="1;#Committees/DN1/Lists/pl trial/1_.000" /><br />
<z:row ows_ID="2" ows_Title="Microsoft Report Builder Test" ows_MetaInfo="2;#" ows__ModerationStatus="0" ows__Level="1" ows_owshiddenversion="1" ows_UniqueId="2;#{ED0FDDC1-B1DA-4B1A-9E4D-83CF6B9DD927}" ows_FSObjType="2;#0" ows_Created="2010-05-04T12:42:40Z" ows_FileRef="2;#Committees/DN1/Lists/pl trial/2_.000" /><br />
</rs:data><br />
</listitems><br />
<br />
5. I've choosed the /listitems/rs:data/z:row at "any location" and selected all columns.<br />
<br />
And after all these steps, clicking on the "Preview results", I'll get the error message from above.<br />
Dear community - Do you have any idea how I can solve that issue???<br />
For any help I'm grateful...<br />
<br />
---<br />
<br />
=> My doings till here, are described at next:<br />
- I've did a lot of try and error with the MS Report Builder 3.0, which works as expected very well with any kind of chart diagrams and so on... XML-Query Source: <a class='bbc_url' href='
http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/a8e59ad6-614f-4078-96a5-63773a24f94c'>Possible
to use a Sharepoint List as a Datasource?</a> <br />
- I've tried to use the web service example from the Birt wikipedia, <a class='bbc_url' href='
https://bugs.eclipse.org/bugs/attachment.cgi?id=97678'>https://bugs.eclipse.org/bugs/attachment.cgi?id=97678</a>
, <a class='bbc_url' href='
http://wiki.eclipse.org/Web_Service_Data_Source_(BIRT)'>Web
Service Data Source (BIRT) - Eclipsepedia</a>, which doesn't also work as expected:<br />
<a class='bbc_url' href='
http://s7.directupload.net/images/100511/i6q3yy5v.png'>http://s7.directupload.net/images/100511/i6q3yy5v.png</a><br
/>
- Then I've programmed a little VB programm, <a class='bbc_url' href='
http://s3.directupload.net/images/100511/wn7ke9r8.png'>http://s3.directupload.net/images/100511/wn7ke9r8.png</a>
, based on VB example => <a class='bbc_url' href='
http://msdn.microsoft.com/en-us/library/lists.lists.getlistitems.aspx'>Lists.GetListItems
Method (Lists)</a><br />
which gaves me the possibility to create a "sample XML data file".<br />
-> So on... I'm really exhausted by that... Any suggestions from your side? What does the no protocol error statement mean? I don't find any useful information in the forum, till yet...<br />
<br />
Thanks for reading and for support,<br />
Tobi
esuku
Did you get this to work? If so, how?
Thanks,
Elizabeth
