Uploading a file to SharePoint

Posted on 2013-05-16
Medium Priority
Last Modified: 2014-09-30
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?
Question by:ajl7519
  • 2
LVL 15

Expert Comment

ID: 39174225
You can do a HTTP PUT command to upload to Sharepoint.
Example here (MOSS version but still relevent with later versions):

This wont set meta data but you can use the the lists web service for this.

Author Comment

ID: 39175252
Thanks for the reply. Still getting the 405 error. I'm wonding if I need to do via ASP and have it Open IE and run the code when IE loads the page. Just guessing here. My code below modified from the page in a Console project. Was getting a DirectoryNotFound exception so I used a file path instead.

namespace UploadToSharePoint
    class Program
        static void Main(string[] args)
        static void UploadFileToSharePoint()
            WebResponse response = null;
            string UploadedFilePath = @"C:\Reports\test.xml";
            string SharePointPath = "https://server/list/test.xml";
                // Create a PUT Web request to upload the file.
                WebRequest request = WebRequest.Create(SharePointPath);

                request.Credentials = CredentialCache.DefaultCredentials;
                request.Method = "PUT";

                // Allocate a 1 KB buffer to transfer the file contents.
                // You can adjust the buffer size as needed, depending on
                // the number and size of files being uploaded.
                byte[] buffer = new byte[1024];

                // Write the contents of the local file to the
                // request stream.
                using (Stream stream = request.GetRequestStream())
                using (FileStream fsWorkbook = File.Open(UploadedFilePath,
                    FileMode.Open, FileAccess.Read))
                    int i = fsWorkbook.Read(buffer, 0, buffer.Length);

                    while (i > 0)
                        stream.Write(buffer, 0, i);
                        i = fsWorkbook.Read(buffer, 0, buffer.Length);

                // Make the PUT request.
                response = request.GetResponse();
            catch (DirectoryNotFoundException e)
               //Result will be: Could not find a part of the path "C:\incorrect\path".
                //Result will be: C:\incorrect\path
                Console.WriteLine(e.Message.Replace("Could not find a part of the path \"","").Replace("\".","")); 


Open in new window


Accepted Solution

ajl7519 earned 0 total points
ID: 39175646
I found the issue using fiddler. I need to post login credentials (twice actually). Worked for the first one, but not the second.

Featured Post

Managed Security Services Webinar - March 15

Selecting the right managed security services platform to grow your business can be a huge undertaking. Join WatchGuard and Frost & Sullivan in an upcoming webinar as we dive into the key elements of selecting a vendor platform and partnership to fuel a successful MSSP business.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
The PowerShell Core 6.0 of .NET release is just the beginning. The upcoming PowerShell Core 6.1 would have artificial intelligence and internet of things capabilities. So many things to look forward to in the upcoming release.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the adminiā€¦
Loops Section Overview

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question