Reltio Connect

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

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

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

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. 

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

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

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

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

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