Load Document from Document Library using the Client Object Model

Question

I`m able to receive all document items from a document library using the c# client object model, but when i try to download it using the OpenBinaryStream() function each of the items return a null value for the stream. Can somebody help me?

regards Joerg

Answer 1

Is it possible that the API is broken?

Answer 2

You can use following code for download documents

using (ClientContext ctx = new ClientContext("Site URL"))
            {
                List _list = ctx.Web.Lists.GetByTitle("Documents");
                CamlQuery camlQuery = new CamlQuery();
                camlQuery.ViewXml = "<View/>";
                ListItemCollection Items = _list.GetItems(camlQuery);
                ctx.Load(Items);
                ctx.ExecuteQuery();
                foreach (ListItem Item in Items)
                {
                    if (Item != null)
                    {
                       FileInformation fInfo = Microsoft.SharePoint.Client.File.OpenBinaryDirect(ctx,Item["FileRef"].ToString());
                      
                        //Path where you want to save the file
                        string strPath = "C:\\Copy";
                        FileStream writeStream = new FileStream(strPath, FileMode.Create, FileAccess.Write);
                        int Length = 256;
                        Byte[] buffer = new Byte[Length];
                        int bytesRead = fInfo.Stream.Read(buffer, 0, Length);
                        // write the required bytes
                        while (bytesRead > 0)
                        {
                            writeStream.Write(buffer, 0, bytesRead);
                            bytesRead = fInfo.Stream.Read(buffer, 0, Length);
                        }
                        fInfo.Stream.Close();
                        writeStream.Close();

                    }
                   
                }
            }

---

Navneet Singh

Answer 3

Hi, i'm able to get the document reference

but i'm stuck at this line:

FileInformation fInfo = Microsoft.SharePoint.Client.File.OpenBinaryDirect(ctx,Item["FileRef"].ToString());

"The remote server returned an error: (403) Forbidden

any idea how should I overcome this?

Answer 4

Hi Winston,

If this is a secure server you're trying to access, do you have the appropriate credentials to the server?  If not, that can account for that error.

Regards,

---

- Kemp Brown [MSFT]

Answer 5

> i'm stuck at this line:
> FileInformation fInfo = Microsoft.SharePoint.Client.File.OpenBinaryDirect(ctx,Item["FileRef"].ToString());
... because it is wrong. Correct version:

using SPC = Microsoft.SharePoint.Client;

. . .

string relPath = Item.FieldValues["FileRef"].ToString();
using (FileInformation fInfo = SPC.File.OpenBinaryDirect(ctx, relPath))
etc.

---

[e-mail]