REST: Filter List Items by Content Type Name

Question

I can't for the life of me figure out what's wrong with this URL:

_spPageContextInfo.webAbsoluteUrl + String.format("/_api/web/lists/getbytitle('{0}')/items?$select=ContentType/Name&$expand=ContentType&$filter=ContentType/Name eq 'Highlight Report'", documentsListTitle)

I get

400 (Bad Request)

Note I'm specifically looking for a REST solution with an example if possible.

Answer 1

Found a way which works for me. SharePoint 2013 on-prem.

Starting point:

A document library with two content types Document & Highlight Report and two documents in it for testing purpose.

REST URL:

The REST URL for filtering only the document with the content type Document is:

https://<yourdomain>/_api/lists/getbytitle('<yourlistname>')/items?$filter=ContentType eq 'Document'

The output is:

If you want to get the document lorem1 which is content type Highlight Report the REST URL looks like this:

https://<yourdomain>/_api/lists/getbytitle('<yourlistname>')/items?$filter=ContentType eq 'Highlight Report'

Hope this could help you.

Answer 2

$filter by ContentType is not supported. Reason could be ContentType is not any column of list OR Microsoft does not support it yet. $expand is supported.

Ignore the &$filter=ContentType/Name eq 'Highlight Report'" and see it works.

Update #1:

Following solution is regarding CAML + C#

Filter By ContentType using CAML

Now make it CAML + REST API

<View>
  <Query>
    <Where>
      <Eq>
        <FieldRef Name='ContentType'/>
        <Value Type='Computed'>Highlight Report</Value>
      </Eq>
    </Where>
  </Query>
</View>

For executing CAML in REST API

End-Point:

String.format("/_api/web/lists/getbytitle('{0}')/getitems", documentsListTitle)

HTTP Method:

POST

Request Body:

var query = "<View>" + 
 "<Query>" + 
 "<Where>" + 
 "<Eq>" + 
 "<FieldRef Name='ContentType'/>" + 
 "<Value Type='Computed'>Highlight Report</Value>" + 
 "</Eq>" + 
 "</Where>" + 
 "</Query>" + 
 "</View>";

var data = {
    query: {
        __metadata: {
            'type': 'SP.CamlQuery'
        },
        ViewXml: query
    }
};

Let me know for more modification or explanation.

Answer 3

Try using ContentTypeId as the filter , the example below is returning results for me:

http://site/_api/web/lists/getbytitle('Reusable%20Content')/items?$select=ContentType/Name&$expand=ContentType&$filter=ContentTypeId%20eq%20%270x01002CF74A4DAE39480396EEA7A4BA2BE5FB009CBCDDE56A142247B896B1DE93CE3843%27

Update 1: Filtering on ContentType field also works. Try by replacing the space within the content type name by %20 in your REST Url

http://site/_api/web/lists/getbytitle('Reusable%20Content')/items?$select=ContentType/Name&$expand=ContentType&$filter=ContentType%20eq%20%27Reusable%20HTML%27