Reltio Connect

 View Only
  • 1.  Export Entity data

    Posted 01-14-2025 10:45

    Hi Team,

    I need to export data which should have attributes

    type,uri,Attributes.AnchorSourceIdentifiers.ID,Attributes.AnchorSourceIdentifiers.SourceSystem

    From Reltio UI  when I am trying with my advanced search filter as

    1. Search by OV value =true
    2. EntityType =DNBCompany
    3. DNBRefreshIndicator =True

    Export result giving all crosswalk values also. How can I get  only four attributes in export mentioned above.

    I have tried select attributes options from UI and it is not working also tried from POSTMAN API CALL AS below

    https://dev.reltio.com/jobs/v1/export/C0Bxpp76rpACDYG/entities?filter=equals(type,'configuration/entityTypes/DNBCompany')and equals(attributes.DnBRefreshIndicator,true)&select=type,uri,Attributes.AnchorSourceIdentifiers.ID,Attributes.AnchorSourceIdentifiers.SourceSystem&fileFormat=csv&distributed=true&taskPartsCount=7&partSize=4000mb

    This is giving only type and uri values.

    Please let me know how can we do.

    Thanks

    Shruti Das



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


  • 2.  RE: Export Entity data

    Reltio Employee
    Posted 01-14-2025 14:15

    Hi Shruti,

    The reason why its only giving uri & type is that the "Attributes" should be in lower case "attributes"

    Here is the example: "type,attributes.FirstName,attributes.Address.City,createdTime"

    Here is the documentation for the same: 

    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-entities

    Hope this helps. 



    ------------------------------
    Girish Kalburgi
    Reltio
    NC
    ------------------------------



  • 3.  RE: Export Entity data

    Posted 01-15-2025 01:20

    Hi Girish,

    Great thanks!!

    I tried like below and it worked.

    type,uri,attributes.AnchorSourceIdentifiers.ID,attributes.AnchorSourceIdentifiers.SourceSystem

    Output -

    "uri","Type","Attributes.AnchorSourceIdentifiers.ID","Attributes.AnchorSourceIdentifiers.SourceSystem"
    "entities/2KjanKj","DNBCompany","197491012","Validator"

    Can we get  same 4 attributes export  from Reltio UI also?

    Thanks

    Shruti Das



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



  • 4.  RE: Export Entity data

    Reltio Employee
    Posted 01-15-2025 13:01
    Hi Shruti, 

    Yes, you can achieve this via UI as well. 


    Regards,

    Girish Kalburgi

     

    Reltio Inc. www.reltio.com

    Solution Architect

    Reltio Professional Services (PS)





  • 5.  RE: Export Entity data

    Posted 01-17-2025 01:56

    Hi Girish,

    It is not working with UI.

    From Reltio UI  when I am trying with my advanced search filter as

    1. Search by OV value =true
    2. EntityType =DNBCompany
    3. DNBRefreshIndicator =True
    4. and selected in right side attributes  type,uri,Attributes.AnchorSourceIdentifiers.ID,Attributes.AnchorSourceIdentifiers.SourceSystem in UI

    Export result giving all crosswalk values also. 

    If possible can you suggest or shall share more details.

    Thanks

    Shruti Das



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



  • 6.  RE: Export Entity data

    Reltio Employee
    Posted 01-17-2025 09:12
    Hi Shruti,

    When we export from UI it will pick the selected attributes along with the crosswalk. If you need only the attribute then you may need to use the API option. 


    Regards,

    Girish Kalburgi

     

    Reltio Inc. www.reltio.com

    Solution Architect

    Reltio Professional Services (PS)