`exclude`

To exclude specific properties from a response body, use the exclude request parameter. The exclude parameter is available in API version 27.0 and later.

The value for the exclude query is a list of properties separated by bars (|). You must URL encode the bars as %7C. You must include a forward slash before each property name.

The following request excludes both the aboutMe and address properties from a response body:

1/chatter/users/me?exclude=/aboutMe%7C/address

The following rules describe how to use the exclude query parameter.

Forward Slashes

Include a forward slash (/) before property names or the request returns an error.

Original output:

1{
2  "bar": "bar value",
3  "baz": "baz value"
4}

Exclude value: exclude=bar

Filtered output: 400 error with error code INVALID_FILTER_VALUE.

Filter properties by name.

Original output:

1{
2  "bar": "bar value",
3  "baz": "baz value"
4}

Exclude value: exclude=/bar

Filtered output:

1{
2  "baz": "baz value"
3}

Top-Level Properties

Top-level properties cannot be filtered. Note that this query string doesn’t return an error.

Original output:

1<foo>
2  <bar>bar value</bar>
3  <baz>baz value</baz>
4</foo>

Exclude value: exclude=/foo

Filtered output:

1<foo>
2  <bar>bar value</bar>
3  <baz>baz value</baz>
4</foo>

Multiple Properties

Use a bar (|) delimiter to filter multiple properties. URL encode the delimiter as %7C.

Original output:

1{
2  "foo": "foo value",
3  "bar": "bar value",
4  "baz": "baz value"
5}

Exclude value: exclude=/foo%7C/bar

Filtered output:

1{
2  "baz": "baz value"
3}

Filtering a response body filters everything in the response body.

Original output:

1<foo>
2  <bar>bar value</bar>
3  <baz>baz value</baz>
4  <someObject>
5    <sub>sub 1</sub>
6  </someObject>
7</foo>

Exclude value: exclude=/someObject

Filtered output:

1<foo>
2  <bar>bar value</bar>
3  <baz>baz value</baz>
4</foo>

Nested Properties

To filter a property nested in a response body, include the parent response body name as a filter segment.

Original output:

1<foo>
2  <bar>bar value</bar>
3  <baz>baz value</baz>
4  <someObject>
5    <sub>sub value</sub>
6  </someObject>
7</foo>

Exclude value: exclude=/someObject/sub

Filtered output:

1<foo>
2  <bar>bar value</bar>
3  <baz>baz value</baz>
4  <someObject>
5  </someObject>
6</foo>

XML List Items

Identify an item in a list by its property name. This example uses XML.

Original output:

1<foo>
2  <bar>bar value</bar>
3  <baz>baz value</baz>
4  <someList>
5    <item>
6      <id>1</id>
7    </item>
8    <item>
9      <id>2</id>
10    </item>
11    <item>
12      <id>3</id>
13    </item>
14  </someList>
15</foo>

Exclude value: exclude=/someList/item/id

Filtered output:

1<foo>
2  <bar>bar value</bar>
3  <baz>baz value</baz>
4  <someList>
5    <item/>
6    <item/>
7    <item/>
8  </someList>
9</foo>

JSON List Items

Identify an item in a list by its property name. This example uses JSON.

Original output:

1{
2  "bar": "bar value",
3  "baz": "baz value",
4  "someList": [
5    {
6      "id": "1"
7    },
8    {
9      "id": "2"
10    },
11    {
12      "id": "3"
13    }
14  ]
15}

Exclude value: exclude=/someList/item/id

Filtered output:

1{
2  "bar": "bar value",
3  "baz": "baz value",
4  "someList": [{}, {}, {}]
5}