I have a SQL database where I export one the tables to XML and then use the XML files as Data Source on a few list forms.
I was able to use C# to pull and create the XML from the SQL table, but I'm having issues uploading the file through code.
I've tried Powershell and C# using WebDav. Tried the SharePoint Client Object as well as SharePoint web services.
Unfortunately, I do not have access to SharePoint to make any changes, so I'm stuck putting it together on the client side. I'm the owner of the SharePoint site i'm trying to upload it too.
I've received a 405 Method Not Allowed with WebDav and "The request failed with an empty" response using Web Services. I tried using SPWeb, but I received an invalid url error.
I think one of the problems may be that night site is a subsite with this url and probably security related as well. My office has proxy and web filtering. They use Blue Coat.
Any other suggestions on what other methods I can try?