How do I locate a certain file in SharePoint using C# console app

Question

I'm building a console app which gets a file from a folder in sharepoint, processes it, and then moves it to a "Processed" folder on Sharepoint. I've got my app to login but having real trouble getting the document as I don't quite understand the sharepoint structure.

Do I need to use a url or go through a document library? How do I then either move the file or delete it and upload to another folder?

This is what I've tried at the moment.

many thanks guys!

Answer 1

I'm sure that this is a common scenario that you'll have no difficulty searching a bit.

Here's a small example (it's actually an image found here but I don't feel like writing into actual code :p )

public void MoveFile()
{
    ClientContext ctx = new ClientContext("http://site/");//_spPageContextInfo.webAbsoluteUrl
    Web web = ctx.Web;

    //fetch our item
    ListItem item = web.Lists.GetByTitle("My List").GetItemById(1);
    ctx.Load(item);
    ctx.ExecuteQuery();

    if(item.FileSystemObjectType == FileSystemObjectType.File)
    {
        //load up file object
        File file = item.File;
        ctx.Load(file);
        ctx.ExecuteQuery();

        //commit move
        file.MoveTo("http://site/Library2/1.docx", MoveOperations.Overwrite);
        ctx.ExecuteQuery();
    }
}

Edit:

updated screen shot to text