Unify and manage your data

Get Participating Values

Returns all values that participated in activities (matching the search criteria) for the given field name and tenant.

This operation returns all values that participated in activities, and which match the search criteria, for the given field name and tenant.

Request:

GET {TenantURL}/activities/_participatedValues
Table 1. Parameters
Name Required Details Examples
Headers Authorization Yes Information about authentication access token in format "Bearer <accessToken>" (see details in Authentication API ).
Query fieldName Yes Name of the field for which participated values should be returned. fieldName=items.delta.sources
filter No There are the following Condition Types:
  • equals (property, value): exact match condition
  • not equals (property, value): not equals condition
  • equalsCaseSensitive (property, value): exact match condition considering case
  • containsWordStartingWith (property, tokenized value): prefix condition; returns activities that have condition property starting with condition value
  • startsWith (property, stricted value): prefix condition; returns activities that have condition property starting with condition value
  • missing (property): returns activities with fields that have no values for property, or the property value is empty
  • exists (property): returns activities having some not empty value for property
  • range (property, from, to): returns activities having property within the specified range
  • gt (property, value): returns activities having property greater than the specified value
  • lt (property, value): returns activities having property less than the specified value
  • gte (property, value): returns activities having property greater than or equals the specified value
  • lte) (property, value: returns activities having property less than or equals the specified value
In this condition, property is a dot-delimited path to the property by which to search:
  • label
  • description
  • timestamp
  • user
  • items.objectUri
  • items.objectType
  • items.data.type
  • items.delta.attributeType
  • items.delta.newValue
  • items.delta.oldValue
  • items.delta.sources

To search by all properties, specify attributes for the property.

Search by multiple conditions is supported with AND and OR conditions.

Note: Search is case sensitive for all fields except label.
Note: Replace "+" with %2B on client side in search request. For example, to search for "some+d-423type", use filter=equals(attributes,'some%2Bd-423type')

Filter by object type:

filter=(equals(items.objectType,'configuration/entityTypes/Organization'))

Filter by user:

filter=(equals(user,'user1'))

Filter by a String across all properties:

filter=(equals(attributes,'logged'))

Find activities with items without object type:

filter=missing(objectType)

Find activities that have non-empty description:

filter=exists(description)

Find activities which occurred after 2015-04-01:

filter=(gt(timestamp, 1427742000000))

Find activities which occurred between 2015-03-01 and 2015-04-01:

filter=(range(timestamp,1425063600000,1427742000000))
max No

Positive Integer value to identify maximum number of values to return in a response. Can be used to organize pagination in combination with the "offset" parameter.

Default value is 10.

max=15
offset No

Positive Integer value to identify starting what element in a result set should be returned in a response. Can be used to organize pagination in combination with the "max" parameter.

Default value is 0.

offset=30

Response

List of values that participated in activities.

Example Request

GET {TenantURL}/activities/_participatedValues?fieldName=items.delta.sources&filter=equals(items.delta.attributeType, 'configuration/entityTypes/HCP/attributes/FirstName')
Headers: Authorization: Bearer 204938ca-2cf7-44b0-b11a-1b4c59984512

Example Response

["FB", "LNKD", "ABCD"]