Reltio Connect

 View Only

  • 1.  Relationship values export from entity without crosswalk with API call

    Posted 12-05-2024 03:25

    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



    ------------------------------
    Shruti Das
    Optum
    ------------------------------


  • 2.  RE: Relationship values export from entity without crosswalk with API call

    Reltio Employee
    Posted 12-05-2024 13:26

    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)



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

    Original Message


  • 3.  RE: Relationship values export from entity without crosswalk with API call

    Posted 12-09-2024 06:17

    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



    ------------------------------
    Shruti Das
    Optum
    ------------------------------

    Original Message


  • 4.  RE: Relationship values export from entity without crosswalk with API call

    Reltio Employee
    Posted 12-09-2024 11:47

    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?



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

    Original Message


Related Content