Reltio Connect

Hey there everyone,

I was trying to export the entities and their corresponding relationships. But ended up with this behavior where all the entities having that specific relationship is being exported.

So here's what I did.

1. In the Advanced Search, an entity type is selected along with a WHERE filter clause for a specific attribute. (Let's say this search result pulled one profile where this profile has only one relationship item)
2. Export option is chosen, where the necessary entity attributes to export and the corresponding relationship type of this entity is selected.
3. Export Operational Values only, CSV Flattened and Produce a single output file is selected.
4. The job is triggered to Run.

Now, we will have 2 jobs. One to export the entity and another to export the relationships. And, we are expecting one row each in the entity export and the relations export.

The entity export is turning out to be fine. But the relations export is pulling all the entities that are having this relationship, rather than pulling the relationship of this only profile which I queries for.

This is incorrect and this is not something that is expected to be exported. If we need the all the entities of that specific relationship, we can use the Export feature in the Console, that than using a query expecting the relationship of only that entity to be exported.

Is that any other way to resolve this or achieve the requirement by any workaround?

Hi Nideesh,

Have you seen this conversation?  https://community.reltio.com/discussion/search-connection-api-reference-attributes

I think you can get what you are looking for via API.

Regarding your problem with the export and the advanced search, have you filed a ticket?

Hey there everyone,

I was trying to export the entities and their corresponding relationships. But ended up with this behavior where all the entities having that specific relationship is being exported.

So here's what I did.

1. In the Advanced Search, an entity type is selected along with a WHERE filter clause for a specific attribute. (Let's say this search result pulled one profile where this profile has only one relationship item)
2. Export option is chosen, where the necessary entity attributes to export and the corresponding relationship type of this entity is selected.
3. Export Operational Values only, CSV Flattened and Produce a single output file is selected.
4. The job is triggered to Run.

Now, we will have 2 jobs. One to export the entity and another to export the relationships. And, we are expecting one row each in the entity export and the relations export.

The entity export is turning out to be fine. But the relations export is pulling all the entities that are having this relationship, rather than pulling the relationship of this only profile which I queries for.

This is incorrect and this is not something that is expected to be exported. If we need the all the entities of that specific relationship, we can use the Export feature in the Console, that than using a query expecting the relationship of only that entity to be exported.

Is that any other way to resolve this or achieve the requirement by any workaround?