Item count with a filter condition using REST API gets result in web browser, error when coding

Question

I need to get the no.of items in a SharePoint list which satisfying a condition.

https://<SITEURL>/_vti_bin/listdata.svc/LISTNAME/$count?&$filter=FIELDNAME eq 'abc'

using above url in browser gives me correct result.

So I Tried get it using below code,

    getItems("/_vti_bin/listdata.svc/LISTNAME/$count?&$filter=FIELDNAME eq 'abc'").done(function(data){
                console.log(data);
            });

getitems function,

function getItems(url){

    return $.ajax({
        url: _spPageContextInfo.webAbsoluteUrl + url,
        type: "GET",
        headers: {
            "accept": "application/json;odata=verbose",
        }
    });
}

But using this code gives an error "415 Unsupported Media Type".
please help.

https://sharepoint.stackexchange.com/questions/139377/getting-an-itemcount-with-filtering-in-sp2013-using-rest-api — Yavuz, May 18 '17 at 09:01
Possible duplicate of Getting an ItemCount with filtering in SP2013 using REST api — Jussi Palo, May 18 '17 at 09:02
@Yavuz I had seen that link, but that does not resolve my issue. — Vishnu S, May 18 '17 at 09:15
Wouldn't call this a duplicate, since that is about how to get the item count, and this is about an error received while trying to get an item count. — wjervis, May 18 '17 at 10:54
Just out of curiosity, why are you using the older endpoint instead of the newer one? — wjervis, May 18 '17 at 10:58
sorry I didn't know about the version diff, I got this Idea from https://social.msdn.microsoft.com/Forums/office/en-US/5db895ab-172b-424b-bd61-53de6db7fa33/sharepoint-2013-rest-api-how-to-get-the-item-count-with-startswith?forum=sharepointdevelopment — Vishnu S, May 18 '17 at 11:15

score 2 · Accepted Answer · answered May 18 '17 at 09:26

2

/_vti_bin/listdata.svc/LISTNAME/$count?&$filter=FIELDNAME eq 'abc'

_vti_bin is the old (SP2007) SOAP WebServices endpoint (might still work),
But it is not the same as the Modern (SP2010) _api REST end point:

/_api/web/lists/getbytitle('LISTNAME')/items?$filter=FIELDNAME eq 'abc'

You will get the resultst back in data.d.results, you can get the length of.

answered May 18 '17 at 09:26

Danny '365CSI' Engelman

21,176
7
35
79

thanks, it worked. _vti_bin is working in web browser that confused me – Vishnu S May 18 '17 at 09:35
1

It is supposed to work but the syntax is different. See the jQuery / SPServices Library, that uses the SOAP endpoint and sometimes still has greater powers than REST – Danny '365CSI' Engelman May 18 '17 at 09:37

score 0 · Answer 2 · edited May 18 '17 at 09:01

0

Instead of writing the result in done function you can use success and error methods. Your code look like

function getItems(url){

return $.ajax({
    url: _spPageContextInfo.webAbsoluteUrl + url,
    type: "GET",
    headers: {
        "accept": "application/json;odata=verbose",
    }
 success: function (data) {
        console.log(data.d.results);
    },
    error: function (error) {
        alert(JSON.stringify(error));
    }
});
}

edited May 18 '17 at 09:01

Jussi Palo

8,196
1
20
36

answered May 18 '17 at 09:01

Mukesh M

49
3

I tried that one, but getting error – Vishnu S May 18 '17 at 09:04
{"readyState":4,"responseText":"{\r\n\"error\": {\r\n\"code\": \"\", \"message\": {\r\n\"lang\": \"en-US\", \"value\": \"Unsupported media type requested.\"\r\n}\r\n}\r\n}","status":415,"statusText":"Unsupported Media Type"} – Vishnu S May 18 '17 at 09:08

score 0 · Answer 3 · answered Oct 10 '20 at 18:04

You should set the "Accept" header to "text/plain" when querying for counts from "/_vti_bin/" URL via ajax.

function getItems(url){
return $.ajax({
    url: _spPageContextInfo.webAbsoluteUrl + url,
    type: "GET",
    headers: {
        "accept": "text/plain",
    }
  });
}

Item count with a filter condition using REST API gets result in web browser, error when coding

3 Answers3