Reltio Connect

 View Only
  • 1.  Using reference attribute in API Filter

    Reltio Partner
    Posted 10-27-2023 09:21

    Hi Experts,

    Can we use Reference attribute in API filter.

    if yes can you please help me in creating the API.


  • 2.  RE: Using reference attribute in API Filter

    Posted 10-31-2023 10:09

    Hi Karthik,

    This is possible. Below is an example of a request using Python requests. In this example AggregateParent is a reference attribute of Organization and Organization has a nest of names called OrganizationName. I am searching for a Organization with an AggregateParents named "test".

    I have included a few other common parameters for the _search API below as well

    import requests
    url = "{{tenantID}}/entities/_search"
    payload = json.dumps({
      "filter": "(equals(type,'configuration/entityTypes/Organization') and equals(attributes.AggregateParent.OrganizationName.Name,'test')) and equals(type,'configuration/entityTypes/Organization')",
      "select": "uri,label,type,secondaryLabel,defaultProfilePic,defaultProfilePicValue,ctSubscribedUris,attributes.Address,attributes.GeoLocation,attributes.ImageGallery,attributes.Addresses",
      "max": 25,
      "offset": 0,
      "scoreEnabled": False,
      "options": "searchByOv,ovOnly",
      "activeness": "active"
    headers = {
      'Content-Type': 'application/json',
      'Authorization': 'Bearer {{token}}'
    response = requests.request("POST", url, headers=headers, data=payload)

    Joel Snipes
    Savannah GA