Posts for JavaScript

Simple Sharepoint API Usage with jQuery - Part 2

Posted by on November 12, 2008.

In my last post I talked about a simple example of using Sharepoint's owssvr.dll API interface with jQuery. Today I want to provide a more complex example by showing how I've used the technique to create object collections that can be manipulated to generate on-the-fly statistics. To start with, I had a Sharepoint survey that captured a set of data from the user. That data was later used to calculate statistics. Previously, the survey was exported to Excel and that was used to come up with the numbers. My goal was to create a client-side application that would pull the information from Sharepoint and generate the statistics dynamically based on up-to-the-minute data. To do this, I used the technique I described in my previous post to build a $.get query. var list = 'A1234567-B123-C123-D123-A12345678901'; var view = 'E9876543-F987-9876-B987-A98765432109'; Then, I set up an object called fields that would map each ...

(click to read more) 2 comments so far

Simple Sharepoint API Usage with jQuery - Part 1

Posted by on November 7, 2008.

(This is part 1 of a 2-part post. Part 2 can be found here) I've recently worked on some projects for a company heavily using Microsoft's Sharepoint platform. I've been trying to move away from it as much as possible, but for a few of my projects it has been unavoidable. On those projects I needed to work dynamically with data captured in Sharepoint. After a lot of trial and error, I discovered the owssvr.dll API interface. The owssvr.dll interface lives in the _vti_bin directory under the Sharepoint site you are working with. Using GET requests, you can access XML data in SOAP form containing the information from lists and surveys in Sharepoint. More information about the API can be found here. UPDATE: On part 2 of this post, Eduard Ralph pointed out that there is a Webservice API offered by WSS 3.0 and MOSS. Information on this can be ...

(click to read more)