Any workarounds or alternatives that work on both SP2010 & 2007.
Web Services and CAML are your best bet with MOSS 2007. But having gone through all that pain, If I were to do it again, I would rather take the following approach:
Create a custom web application on the SharePoint server. Create .asmx or wcf services as you see fit. Inside these services you can have object model code.
Things to consider:
- This might save you time rather than having to get a grasp on the web services and CAML.
- You can create custom web services directly in SharePoint, but it is again another learning curve, and if you're in a hurry avoid this.
- It might be worth learning SharePoint 2007 web service methods for future projects, then again a lot of clients are upgrading to MOSS 2010.