Exporting SharePoint data to external PHP script

manpreet Best Answer 2 years ago

My client has his intranet website running as a SharePoint 2010 site, consisting of about 40 lists making the different categories of news.

What would be the easiest way for me to fetch this data (including the contents html-formatting) to an external solution that's written in PHP?

The fetching/exporting must happen automatically. Either every time changes are made to one of the lists, or at a timed interval (i.e. every hour).

I was looking into the built-in RSS-feed option of SharePoint 2010. Will the RSS-fields contain the HTML-formatting as well? Or is there a smarter way to handle this export?

manpreet 2 years ago

If you're looking for list data, you can fire off a curl request to one of SharePoint's list REST services, and parse the results. Should be pretty simple. There's also a full set of SOAP web services, but those have been deprecated in 2013, so I'd argue that developing a solution using REST is likely more future proof. You could start here for a simple introduction to REST. Once you understand the concept and what comes back just open a curl connection in PHP and parse the dataset for the element(s) you need.