Reltio Connect

Hi all,

I need to export relationship export of an entity where the attributes I need is start entity,name,end entity,name,relationid,type,uri

I do not need export of crosswalk values. Is this possible from  Reltio API call.

I am providing below details and please suggest some work around if this is not possible.

I have already raised previous request and came to know csv file format not supported hence using json.

Also if we don't use select option we get more attributes which we want to avoid.

https://test.reltio.com/jobs/export/IB5D4yLF6NGP0P2/relations?filter=equals(type,'configuration/relationTypes/AlternateCompanyRel')and(equals(endObject,'0sbZHLp')&fileFormat=json&select=type,uri,createdBy,startObject.type,startObject.objectURI,endObject.type,endObject.objectURI

and below result I am getting

[
{"uri":"relations/uPxzSkc","type":"configuration/relationTypes/AlternateCompanyRel","createdBy":"jason.grant@optum.com","createdTime":1710961244249,"updatedBy":"jason.grant@optum.com","updatedTime":1710961244249,"startRefPinned":false,"startRefIgnored":false,"endRefPinned":false,"endRefIgnored":false,"attributes":{},"analyticsAttributes":{},"crosswalks":[{"uri":"relations/uPxzSkc/crosswalks/4nl93OmKw","type":"configuration/sources/Reltio","value":"uPxzSkc","reltioLoadDate":"2024-03-20T19:00:44.249Z","createDate":"2024-03-20T19:00:44.249Z","updateDate":"2024-03-20T19:00:44.249Z","attributes":[],"singleAttributeUpdateDates":{}}],"startObject":{"type":"configuration/entityTypes/Company","objectURI":"entities/694JdZv","label":"Southern Ohio Medical Center","directionalLabel":"Alternate Parent Company","crosswalks":[{"uri":"entities/694JdZv/crosswalks/AY9VkpXr","type":"configuration/sources/Reltio","value":"694JdZv","reltioLoadDate":"2024-04-10T16:36:33.526Z","createDate":"2019-04-12T21:52:18.493Z","updateDate":"2019-04-12T21:52:18.493Z","attributes":["entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/UpdateTime/AY9Vkh1L","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/Status/AY9VkYUp","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/UpdatedBy/AY9VklHb","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/NeedsStewardship/AY9Vkcl5"],"singleAttributeUpdateDates":{"entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/UpdateTime/AY9Vkh1L":"2019-04-12T21:52:18.493Z","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/Status/AY9VkYUp":"2019-04-12T21:52:18.493Z","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/UpdatedBy/AY9VklHb":"2019-04-12T21:52:18.493Z","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ":"2019-04-12T21:52:18.493Z","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/NeedsStewardship/AY9Vkcl5":"2019-04-12T21:52:18.493Z"}}]},"endObject":{"type":"configuration/entityTypes/Company","objectURI":"entities/0sbZHLp","label":"SOMC Home Health","directionalLabel":"Alternate Child Company","crosswalks":[{"uri":"entities/0sbZHLp/crosswalks/5L16Y3uf","type":"configuration/sources/Reltio","value":"0sbZHLp","reltioLoadDate":"2023-09-21T18:55:45.193Z","createDate":"2023-09-21T18:55:45.193Z","updateDate":"2023-09-21T18:55:45.193Z","attributes":[],"singleAttributeUpdateDates":{}}]}}
]

Thanks

Shruti Das

I think you can handle this in post processing.  For example, put the json above into jsoneditoronline.com and click the filter.  You can get (for example) the beginning and end object with pick(.startObject, .endObject)

Hi Gino,

Thanks for revert. We actually want automated API where we could get all export of relationship.

Can we get it from database?

Thanks

Shruti

Hi Shruti,

There is an API that exports relationships.  It is visualized via the Reltio Console.  But it calls an API, which is documented here: https://docs.reltio.com/en/objectives/load-and-export-data/data-exporting-at-a-glance/data-exporting-operation/export-data-using-reltio-export-service/export-relations

Is that helpful?