Reltio Connect

Hi All, 

I was going through the APIs to get the Entity details, and I was wondering if there is a way to get Entities giving in the filter the attribute and get only those entities that are having an specific number of characters in the attribute value. For example, I would like to get the individuals that the First name is 10 characters long. 

How can I perform this operation via API or UI ?

Thanks in advance!
Fernando de la Torre

Hi Fernando,

You can use below API.

GET: {{tenantURL}}/entities/?filter=(equals(type,'configuration/entityTypes/Individual')) and equals(attributes.FirstName.length, 10)

UI: Use Reltio Data Quality Dashboard , select the entity, select the attribute, you can find the length statistics.

https://docs.reltio.com/en/engage/analyze-and-remediate-data/view-data-quality-issues-in-real-time/real-time-data-quality-dashboard-charts/length-statistics-dq-chart

Thank You Nagaraju! 

I have tried and the API works perfect. I wanted to tested using other nested attribute like SourceKey like shown below:

How is can I use the filters to get the entities with source Key value of length of 18?
{{testURL}}/entities/?filter=(equals(type,'configuration/entityTypes/Individuals')) and equals(attributes.SourceKey.attributes.Value.length, 18)



Thanks in advance!
Fernando de la Torre

You should not use attributes after SourceKey, Below will work

{{testURL}}/entities/?filter=(equals(type,'configuration/entityTypes/Individuals')) and equals(attributes.SourceKey.Value.length, 18)