jquery and javascript : can i get the last ID from document library?

Question

Is there a way to get the last ID from a Document Library with javascript/jquery?

Answer 1

There was a similar question in SharePoint Stackexchange. I even wrote a blog post about retrieving the last item in a list/library: Three ways to get the id of last created SPListItem. There I show the last item for current user... If you want to retrieve the very last document, it is much easier. I prefer the Client object model. But it can be done with SPServices and listdata.svc. Here is the code:

var caml = "<View><Query><Where>"
    + "<Eq><FieldRef Name='FSObjType' /><Value Type='int'>0</Value></Eq>"
    + "</Where>" 
    + "<OrderBy><FieldRef Name='ID' Ascending='False' /></OrderBy>" 
    + "</Query>"
    + "<ViewFields><FieldRef Name='ID' /></ViewFields>"
    + "<RowLimit>1</RowLimit>"
    + "</View>";
var ctx = SP.ClientContext.get_current()
var web = ctx.get_web();
var list = web.get_lists().getByTitle("Shared Documents")
var query = new SP.CamlQuery();
query.set_viewXml(caml);
var items = list.getItems(query);
ctx.load(items)
ctx.executeQueryAsync(function() {
    var enumerator = items.getEnumerator();
    enumerator.moveNext();
    var item = enumerator.get_current();
    var id = item.get_id();
    alert(id);
}, function() { 
    //failure handling comes here
    alert("failed"); 
});

It is important to ignore folders, otherwise you'll get a latest folder, not the latest document.

If OData is preferred (listdata.svc) you can use it as well:

jQuery.getJSON("/_vti_bin/listdata.svc/Documents()?$orderby=Id desc&$top=1&$select=Id")
    .done(function(data) {
        var id = data.d[0].Id
        alert(id); 
    }).fail(function() {
        alert("hmpf");
    });

Answer 2

SPServices has a function called GetLastItemId you can use. Here is the documentation for that function: $().SPservices.GetLastItemId

Answer 3

I think you need some thing like this - Create the soap envelope

var soapEnd = "<soap:Envelope xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'>
<soap:Body>
    <GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'>
        <listName>Your Doc Library Name</listName>
        <query><Query><OrderBy><FieldRef Name='Modified' Ascending='False' /></OrderBy></Query></query>
        <viewFields>
            <ViewFields>
                <FieldRef Name='ID' />
            </ViewFields>
        </viewFields>
        <rowLimit>1</rowLimit>      
    </GetListItems>
</soap:Body>

";

then ajax call -

$.ajax({
    url: "/_vti_bin/lists.asmx",
    type: "POST",
    dataType: "xml",
    data: soapEnv,
    complete: ProcessListItems,
    contentType: "text/xml; charset=\"utf-8\""
});

and in the ProcessListItems you can easily retrieve the value

function ProcessListItems(xData, status) {
$(xData.responseXML).find("z\\:row").attr("ows_ID")}

or alternatively you can simply bring all rows all columns, get the first one and retrieve value, in that case ommit viewFields and rowLimit

I assumed you meant last modified by 'Last' ID, in case anything else please edit the query portion

Please note this is not a tested code, this is just one sample written instantly, please re-write this as per ur requirement