Avatar of Gene Klamerus
Gene KlamerusFlag for United States of America

asked on 

Querying sharepoint lists and libraries

Is there not some web service or worst case library based API to query sharepoint lists and libraries similar to SQL?

I’ve only been able to find fairly obtuse ways of doing this and in reality the basis for these are sql server relational dB tables.

And I do mean querying to sharepoint not the tables behind it.  I have SP Online sites and I only have acces to SP not the DB behind it.
Microsoft SharePoint

Avatar of undefined
Last Comment
Gene Klamerus
Avatar of Walter Curtis
Walter Curtis
Flag of United States of America image

SPServices may be something you can use. It is very good...

http://sympmarc.github.io/SPServices/

Hope that helps...

btw... since providing just links is frowned upon, I will say that I have been aware of SPServices and using the library for over seven years with very good results. I don't see the need to fill space in this box with information that is not as good as what you will get from the web site that I referenced above. Good luck...
ASKER CERTIFIED SOLUTION
Avatar of Jamie McAllister
Jamie McAllister
Flag of Switzerland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Gene Klamerus
Gene Klamerus
Flag of United States of America image

ASKER

Would these approaches support the development of something I can upload into the site and expose to end-users as an alternative to the LTV interface?
Yes. Particularly the JSOM examples I.e. Javascript calling the client object model. Lot's of cut and paste examples online and you can put these on a page and surface data based on that users permissions.  Works great for small scale solutions.
Avatar of Gene Klamerus
Gene Klamerus
Flag of United States of America image

ASKER

Frustrating to get answers when they're disappointing answers, but they are the real answers nonetheless.
Avatar of Gene Klamerus
Gene Klamerus
Flag of United States of America image

ASKER

hard to believe how MS can deliver solutions that capacity limitations lower than applications I wrote 30 years ago due to some internal design/architecture decisions.
Microsoft SharePoint
Microsoft SharePoint

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

40K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo