Reltio Connect

 View Only
  • 1.  Search with Source ID

    Posted 05-19-2023 11:12

    Hi,

    Any idea how can we perform bulk search with source ID in Reltio ? we don't have option in advances search or no filter can be added with multiple source ID's. Please let me know if there is a way to achieve it. 

    Regards,
    Sree



    ------------------------------
    Sreekumar Appanam Karakkad
    ------------------------------


  • 2.  RE: Search with Source ID

    Reltio Employee
    Posted 05-22-2023 11:22

    It's not directly supported in the UI, but you can use the "In File" search against the crosswalks.value.  The In File can be used natively against most other attributes.

    Via the standard API you can accomplish this with the entity filter like:

    https://{{environment}}.reltio.com/reltio/api/{{tenantID}}/entities?activeness=active&filter=(listEquals(crosswalks.value,"URL:s3://{{bucket-name}}/{{path}}/dataFileList.csv")) 

    But you CAN actually do this same filter in the UI.  If you clear the search filter and type the word "filter:" in the search box and then past the filter condition after it, you can perform any properly formatted Reltio search filter.  So here it would look like:

    filter:(listEquals(crosswalks.value,"URL:s3://{{bucket-name}}/{{path}}/dataFileList.csv")) 

    Note that it is case sensitive.  And you Reltio tenant needs to be able to access the S3 bucket you use.  If you perform a search on a different attribute and upload the file from the Reltio UI, it will cache the file in the search storage.  Which for my tenant on Azure was:

    URL:s3://reltio-search-data-azure-us/na03-sales/valueListFiles/{{mytenantID}}/22-May-2023/data030422990.csv



    ------------------------------
    Dan Gage
    Principal Solution Consultant
    ------------------------------



  • 3.  RE: Search with Source ID

    Posted 05-24-2023 10:16

    Thanks Dan. I'll try this and let you know, but I am not sure whether I can access S3 bucket from our Reltio tenants. 



    ------------------------------
    Sreekumar Appanam Karakkad
    ------------------------------



  • 4.  RE: Search with Source ID

    Reltio Employee
    Posted 05-25-2023 10:18

    Do not worry, Reltio has your back.

    You can upload Source IDs using the below API to Reltio cloud Storage, this will generate a link that can be used in the filter condition.

    POST: https://{{env}}.reltio.com/reltio/api/{{mdmTenant}}/valueList


    Note:
    File to be upload to have one value per row with no commas or quotes. 
    path value from the response to be used in the filter condition.



    ------------------------------
    Mallikarjuna Aakulati
    ------------------------------



  • 5.  RE: Search with Source ID

    Reltio Employee
    Posted 05-23-2023 11:53

    you can do the 'search in file' that Dan refers to in Advanced Search



    ------------------------------
    Gino Fortunato
    Senior Solution Engineer
    Reltio
    ------------------------------



  • 6.  RE: Search with Source ID

    Reltio Employee
    Posted 05-23-2023 12:02

    as I said elsewhere, disagree with Dan at your own peril. 

    The above functionality is not available for the attribute you are referring to.... ;-)



    ------------------------------
    Gino Fortunato
    Senior Solution Engineer
    Reltio
    ------------------------------