PHP to SharePoint Library


The TEALS program ([url removed, login to view]) hosts many of its public facing services such as volunteer and school applications on a WordPress platform. Yet its internal operations are managed through SharePoint lists. This document describes the requirements of a PHP library callable from a WordPress site when faced with a table DELETE, UPDATE or INSERT request that must have an equivalent experience in its SharePoint counterpart.


The PHP library must support interfaces to accomplish the following:

• Read full or partial record from SharePoint list

• Insert full or partial record to SharePoint list

• Update full or partial record to SharePoint list

Common interface parameters are:

- SharePoint site URL

- SharePoint list name

- SharePoint username

- SharePoint password

To maintain integrity between a table on the WordPress site and its SharePoint list equivalent, every list operation must include a column representing the unique key value. Additionally, the destination list column that hosts the key must be identified in the interface call.


The interface for every operation (read, insert, update, delete) must be represented as a query in a format similar to “select {columns…} from list where ….”


The protocol format must be JSON and XML. In phase 1 of the project, JSON will be the standard format. In phase 2, XML will be supported. As a result, the interface must specify which protocol is required for formatting the output (i.e. JSON or XML).


The library must account for security over the wire. SharePoint passwords must not be sent in clear text over the wire.


For testing, a DEBUG USER INTERFACE allows end-user testing of the library. The library presents UI elements for:

- Fixed configurable variables

- Query input

- Response output in JSON (phase 1) or XML (phase 2)

The debug interface serves two purposes

1. Create the protocol specific input which the PHP library needs to submit

2. Create the protocol specific output which the PHP library will receive


Scenario 1

The volunteer and school application are filled in the WordPress forms on www.tealsk12.org. When the applications are created, a process will call the PHP library to insert the full or partial contents of the newly created application into a SharePoint list.

Scenario 2

Volunteers and schools can return to a partially completed application to update their preferences. When the applications are updated, a process will call the PHP library to update the full or partial contents of the application into a SharePoint list.

Scenario 3

TEALS administrators make updates to volunteers and schools data in their SharePoint lists. Sample changes include removing volunteers or schools from circulation. When this occurs, the website on [url removed, login to view] must be updated to reflect these changes. A process on the public website will do a read query on a SharePoint list via a CRON job at a scheduled interval, looking for an update in a SharePoint list record or set of record(s). If the record has been updated, the WordPress site will query the SharePoint list for the record contents and update itself in WordPress.


[url removed, login to view]%28v=office.15%[url removed, login to view]

Evner: PHP, Sharepoint, Software Arkitektur

Se mere: website debug software, volunteer experience, standard library c, sharepoint job, library scenarios, document formatting services, c standard library list, common services architecture, common query, c list library, c library standard, clear wire, call scenarios, application specific passwords, sample job applications, microsoft sharepoint support, microsoft office sharepoint, software testing services, php introduction, wordpress website needs to be updated, sharepoint website, SharePoint Site, sharepoint services, sample json data, Protocol Testing

Om arbejdsgiveren:
( 28 bedømmelser ) Bellevue, United States

Projekt ID: #6011344

Tildelt til:


A proposal has not yet been provided

$526 USD in 10 dage
(8 bedømmelser)

7 freelancere byder i gennemsnit $910 på dette job


My team is really interested in this project as it is exactly within our scope of expertise: We are WEB application design & development experts. Please kindly visit our website [login to view URL] to learn more about us and Flere

$2444 USD in 30 dage
(18 bedømmelser)

A proposal has not yet been provided

$700 USD in 20 dage
(135 bedømmelser)

Hi, I am Priyanka from Binary Resource Management. I would like to introduce our company that provides services of website design, website development, flash website design, website hosting, software development, g Flere

$526 USD in 10 dage
(1 bedømmelse)

Hello, Placing a PlaceHolder Bid At Vijay Web Solutions Provide Assortment of Services and Skilled Staff For Your Offshore Project Requirement. We are Based In India. We have Good Expertise in Design a Flere

$670 USD in 10 dage
(11 bedømmelser)

Hello, Thanks for opportunity , ABOUT US "WEB GLOBAL IT" is a "DELHI" based Private firm that provides Website, WEB & Window System app, and Hosting & Networking services With a venture Of "DELHI" Host Flere

$504 USD in 10 dage
(0 bedømmelser)

A proposal has not yet been provided

$1000 USD in 14 dage
(0 bedømmelser)