Reltio Connect

 View Only

  • 1.  Extract Organization Entity Data using "entity search" more than 1000

    Posted 08-06-2025 08:55

    Extract Organization Entity Data using entity search more than 1000 ? 

    Created process in Mule API using RELTIO Connector and able to extract 200 entities per run using "entity search" connector. 

    Unable to extract more than 200 entities.. modified maxval to 9900 offsetVal : 100 but no luck ! 

    Mule 4 Reltio Connector Details : 

    Get entities based on filter and other options. : Extract Limit 10K

    Get entities based on filter POST Request : Extract Limit 10K

    Get matching entities with specific criteria with strongly defined order and cursor. : Per call 2K and unlimited using "Search with Cursor"



    ------------------------------
    Hari Moyyi
    Robertw Half Inc.
    CA
    ------------------------------



  • 2.  RE: Extract Organization Entity Data using "entity search" more than 1000
    Best Answer

    Reltio Employee
    Posted 08-07-2025 09:34

    Hi Hari, 

    Can you try with the _scan API ? - Search Entity with Cursor | Reltio.

    This should allow you to search for more than 200 records at a time.  This API can also be used to iterate through using on the cursor value. 



    ------------------------------
    Diparnab Dey
    Technical Consultant
    Reltio
    Kolkata, West Bengal
    ------------------------------

    Original Message


  • 3.  RE: Extract Organization Entity Data using "entity search" more than 1000

    Posted 08-14-2025 12:21

    Thank you for suggestion, I do not see "_scan" connector in Mule Reltio Connectors.  I can use "Basic Entity Search - limit 10K records " 


    I am able to use basic "Get entities based on filter and other options / Get entities based on filter POST Request" Mule - Reltio Connector and get 10K entities data. 

    Do we have any Mule - Reltio Connector to accommodate "_scan" operation ?  
    ------------------------------
    Hari Moyyi
    Robert Half Inc.
    CA
    ------------------------------

    Original Message


  • 4.  RE: Extract Organization Entity Data using "entity search" more than 1000

    Posted 08-15-2025 13:05

    Thank you @Diparnab Dey, I found the right Mule 4 - Reltio Connector - Cursor  "Get matching entities with specific criteria with strongly defined order and cursor" but First Time Run required Cursor value... I am not sure where can I get the Cursor value for first time run. Looks I am missing something here! can you please verify below. 

    Note : Initial Cursor value assigned NULL ...here is the error:

    Mule 4 - Reltio Connector Version : 2.5.0 



    ------------------------------
    Hari Moyyi
    Robert Half Inc.
    CA
    ------------------------------

    Original Message


  • 5.  RE: Extract Organization Entity Data using "entity search" more than 1000

    Reltio Employee
    Posted 08-18-2025 01:57

    Hi Hari, 

    The First request for the _scan API, doesn't need a cursor value. It needs the search criteria and the maximum number of records you want to return. The document shared above will give you more information, but I am sharing a sample payload for your reference as well. 

    This is an example of the first request. 

    curl --location 'https://{{env}}.reltio.com/reltio/api/{{mdmTenant}}/entities/_scan' \
--header 'Authorization: Bearer {{accessToken}}' \
--header 'Content-Type: application/json' \
--data '{
    "filter" :"(equals(type,'\''configuration/entityTypes/Organization'\'') and equals(attributes.Address.Country,'\''United States'\'')) and equals(type,'\''configuration/entityTypes/Organization'\'')",
    "sort":"attributes.Name",
    "order":"asc",
    "select": "uri",
    "max":1000
   
}'


    This API will return the cursor value and the first set of results. 


    You will then have to make subsequent API calls with the cursor value returned in the previous requests to retrieve the full data set. Here is an example of the next API 

    curl --location 'https://{{env}}.reltio.com/reltio/api/{{mdmTenant}}/entities/_scan?select=uri' \
--header 'Authorization: Bearer {{accessToken}}' \
--header 'Content-Type: application/json' \
--data '{
  "cursor": {
    "value": "<<Cursor Value Returned in Previous Request>>"
  }
}'


    Can you try to find if you have the first API in your Mule package ? If not, you have two options 

    • Raise a support ticket to understand if that API is available in the Mule connector package. 
    • Use the HTTP connector to make a custom API call to Reltio. 


    ------------------------------
    Diparnab Dey
    Technical Consultant
    Reltio
    Kolkata, West Bengal
    ------------------------------

    Original Message


  • 6.  RE: Extract Organization Entity Data using "entity search" more than 1000

    Posted 08-25-2025 13:06

    Thank you so much,  

    Found Mule Connector "Get matching entities with specific criteria with strongly defined order and cursor. : Per call 2K and unlimited using "Search with Cursor" but connector required Cursor parameter at first call :) 

    Opened Reltio Support ticket and working with support.

    Note: I am able to HTTPS - API call(https://{{url}}/reltio/api/{{tenant}}/entities/_scan) and get the data(2000 records max and we can use Cursor parameter  get the more data) as you explained. thank you again. 



    ------------------------------
    Hari Moyyi
    Robert Half Inc.
    CA
    ------------------------------

    Original Message


Related Content