I was hoping here to get some guidance on how I can retrieve SharePoint list data in Web focus.

I don't know if there is a specific adapter needed for SharePoint, if there is, then we don't have it other than using ODBC adopter.
Is anyone here retrieving data from share point list? If so, what is the good method to use?

Any help will be greatly appreciated.

This message has been edited. Last edited by: FP Mod Chuck,

I know that we retrieve data from SharePoint, but not directly through WebFOCUS. We are tabling the data in SQL Server and then accessing the data in WebFOCUS through the SQL Server adapters.

Thanks Hallway for the quick reply. We are also thinking similar way, but our team ask me to find is there any other better ideas like calling via Web service or other methods than introducing intermediate tables.

Hi RaviD

The WebFOCUS REST Web Services adapter can be used to get sharepoint list information. Here is a link to the documentation.

http://infocenter.informationb...om/wf81rel/index.jsp

Navigate to WebFOCUS Reporting Server then Adapter administration

Chapter 65, p. 2135 - Using the Adapter for REST

Chapter 76, p. 2891 - Using the Adapter for Web Services

To add to Chuck's previous post, the Web Services SOAP adapter can definitely be used to report against SharePoint Lists.
There are also SharePoint REST Web Services available which can be accessed via the REST adapter.
But, SharePoint limits the amount of items to 5000.
To get more than 5,000 items using the REST adapter, additional REST Paging calls would be needed.

But, based on my experiences, you will not have this issue when accessing SharePoint SOAP Web Services with the Web Services SOAP Adapter.

Efrem