Focal Point
[CLOSED] Reading Sharepoint Question

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3447098526

November 05, 2012, 10:20 AM
Vivian
[CLOSED] Reading Sharepoint Question
To all you WebFOCUS gurus..
I need to read a list of entries in Sharepoint. Actually, if I look at the Excel spreadsheet created out of Sharepoint, it is just one column that is labelled "Name". I would use that column to create a drop down combo box.

Is there a specific adapter for Sharepoint? And, if not or if the company does not have it, is there a way in JavaScript to retrieve the information? If someone has some code that is successful in just reading one column, that would be terrific.

Thanks for the help -- I am on 7.7.03 - 7.7.04 on the server

This message has been edited. Last edited by: Kerry,


Vivian Perlmutter
Aviter, Inc.


WebFOCUS Keysheet Rel. 8.0.2
(Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2
Focus since 1982
WebFOCUS since the beginning
Vivian@aviter.com

November 05, 2012, 03:28 PM
Waz
I've no experience in Sharepoint, but I would have thought that the data would come from a table or stored proc in a DB somewhere.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

November 05, 2012, 04:57 PM
Vivian
Waz -- You can export the data to an excel spreadsheet --- but I am trying to read the index entry or even just the first column in the excel spreadsheet --- Using Access you can point to the column and create a drop down box from the data. I have not been able or don't know how to do that in WebFOCUS -- unless there is a specific adapter that allows WebFOCUS to directly read the index.
Thanks
Vivian


Vivian Perlmutter
Aviter, Inc.


WebFOCUS Keysheet Rel. 8.0.2
(Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2
Focus since 1982
WebFOCUS since the beginning
Vivian@aviter.com

November 06, 2012, 09:35 AM
Prarie
See if this Helps
November 06, 2012, 09:36 AM
WF_IL
Hi

Sharepoint exposes several webservices which allow to query its objects such as lists, if you have the license, you could use the webfocus webservices adaptor to query sharepoint built in webservices.
You can find the sharepoint wsdl file:

http://yoursharepoint host/_vti_bin/lists.asmx?wsdl

and then create a master file for lists and items,

Yours

Eran


Yours,
Eran
SRL Products

http://www.srl.co.il

November 06, 2012, 10:59 AM
Vivian
Thank you Prairie and WF --- Prairie I am not certain what I am supposed to see on your Help link --- I got there and not sure what to see - very few of those links were activated.

WF aka Eran -- My mgmt is investigating whether we have the adapter from IBI -- If we do, I will follow that link - thanks!

In the mean time, do you know if you can write SQL against the table in Sharepoint -- I tried to do that, but it did not work --- not sure if the table name needs to be only 8 characters or what....or if this is a pipe dream.


Vivian Perlmutter
Aviter, Inc.


WebFOCUS Keysheet Rel. 8.0.2
(Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2
Focus since 1982
WebFOCUS since the beginning
Vivian@aviter.com

November 06, 2012, 11:12 AM
GamP
quote:
not certain what I am supposed to see

Well, you'll have to log in first. Once you've done that, you'll be taken to the page where it is explained how to configure Web Service adapter for Sharepoint.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
November 06, 2012, 11:27 AM
Vivian
Okay -- thanks - first we have to make certain that we have the adapter here ---


Vivian Perlmutter
Aviter, Inc.


WebFOCUS Keysheet Rel. 8.0.2
(Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2
Focus since 1982
WebFOCUS since the beginning
Vivian@aviter.com

March 15, 2013, 08:27 AM
roy
I have been quite vocal around this issue as WSDL URL is very difficult to set up.
Please if you do have success with SharePoint connectivity please post the results in this forum.

Respectfully


WebFOCUS 7.6
Windows, All Outputs