Getting data from sharepoint into drupal
drupal, sharepoint, web-services
Solution
I strongly recommend taking a close look at the FeedAPI module and it's extensions.
I've used it successfully:
- 'out-of-the-box' for node creation from RSS feeds
- with slight modifications for node creation from the contents of a Webservice
- as a blueprint/example for a custom module implementation that creates nodes from the content of another Webservice (some very special needs there that called for a custom solution)
If, as it sounds, you have some control over the way the sharepoint data gets exposed, you should be able to use FeedAPI successfully without any modifications at all, but maybe you'll need to implement your own parser extension (again, check the additional modules already written to extend FeedAPI for examples, if not solutions).
Problem
The problem: I am about to develop a Drupal site for a company that stores a lot of data in a sharepoint environment (products, recipes etc...). I need to get that information into my Drupal system somehow. Preferably saving it as drupal nodes. That information will also be edited/added in the sharepoint system, so on top of just saving the data to drupal it will also have to check for updates on a regular basis. One idea for a solution is using some sort of web-service to retrieve data, but i have no idea of how that would be done in drupal. So my question(s) is: Has anyone done anything like this, if so how, or does anyone have any suggestions to how one would go about doing this? Any answers would be highly appreciated. /Anders