 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Reading Sharepoint Question
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Reading Sharepoint Question Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] Reading Sharepoint Question | Login/Join |
| Platinum Member |
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 serverThis 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 | ||
|
| Expert |
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...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Platinum Member |
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 | |||
|
| Virtuoso |
See if this Helps | |||
|
| Platinum Member |
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 | |||
|
| Platinum Member |
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 | |||
|
| Virtuoso |
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
| |||||||||
| ||||||||||
| Platinum Member |
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 | |||
|
| Silver Member |
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 | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Reading Sharepoint Question
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Reading Sharepoint QuestionCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |