Reltio Connect

Hello Team!

We are trying to get the total count of an OV=True values under a certain nested attribute. 

For example, a nested attribute under an entity has 3 OV True values: 

NestedAttribute

NestedValueOVTrue1

NestedValueOVTrue2

NestedValueOVTrue3

We want to get a total number of OV=True values for "NestedAttribute" across all entities of a certain type. 

We tried to use the following, with no success since it appears to be grouping by entityID: Get Entities Total | Reltio

Thanks!

Hi Ujwal,

You could follow this approach to get the count. This involves invoking multiple API calls and then doing some basic math that involves multiplications and additions.

I will take Contact entity and Phone attribute as the example to explain the approach.

These are the steps to be followed:

1. Identify the maximum count of OV true Phone values for Contact entity type by invoking this API call a few times. This is a trial-and-error method, depending on the understanding of the data, you could try different numbers to determine the maximum OV true count.

As you can see from the above screenshots, in my Tenant the maximum OV true count for Phone for Contact Entity Type is 3.

2. Now, invoke this API call with values starting from 1 till the maximum value identified in the above step to get the entity count.

3. Now, multiply the total count from the response with the input number and sum all these values to get the total no.of OV true Phone values for Contact entity type.

In my Tenant the total OV true Phone numbers for Contact Entity type is: (1 x 2) + (2 x 4) + (3 x 6) = 28

Hi Ujwal,

You can use the below API to have the count directly 

curl --location 'https://<env>.reltio.com/reltio/api/<tenant_id>/entities/_facets?options=searchByOv' \ --header 'Content-Type: application/json' \ --data '[ { "fieldName": "attributes.Job.count", "facetType": "valueCount", "pageSize": 100, "pageNo": 1, "orderType": "reversedCount", "includeFilter": [] } ]'

The response should look like this  ( "Job" is the nested attribute considered)

{ "attributes.Job.count": { "count": 3 } }

Reltio doc link : https://docs.reltio.com/en/developer-resources/system-administration-apis/system-administration-apis-at-a-glance/search-api/facet-search-by-statistics-aggregation#minmaxsumavgcount-aggregations-0

Hope this helps.

Thanks for sharing the _facets API, @Abhradeep Sengupta. That is definitely the right call.

Here is how it returns the count of OV True Phone values for Contact entities: