Reltio Connect

 View Only
  • 1.  Extract CSV from Reltio by using URI

    Founding Member
    Posted 06-28-2023 09:22
    Hi Folks,
    We have a use case where we want to extract the data from Reltio directly in CSV format instead of JSON by using URI as an input. 
    Is it possible? Can someone please suggest if they have done it ?
    Thanks in Advance!
    Best,
    Kumar Shubham


    ------------------------------
    Kumar Shubham
    ZS Associates
    New Delhi
    ------------------------------


  • 2.  RE: Extract CSV from Reltio by using URI

    Reltio Partner
    Posted 06-28-2023 09:43

    Hi Kumar,

    I'm not sure if i understand your question correctly.

    Usually export jobs would provide data in csv/json format and if you specify uri in a file you can extract for 5000 uri using file based search and export via UI.

    Link for UI search in file: Working with Advanced Search Filter Options | Reltio

    I would assume you use API to get CSV instead of JSON:

    This may not be possible directly, but you can leverage RIH or any other integration/ script to normalize into desired format like csv with n no of columns.

    Let us know your requirements.



    ------------------------------
    Sheshadri V
    Fresh Gravity
    ------------------------------



  • 3.  RE: Extract CSV from Reltio by using URI

    Founding Member
    Posted 06-28-2023 10:01

    Hi Sheshadri,

    Thanks for your response. 

    I am looking for extracting CSVs from Reltio via API/jar. Currently we are extracting JSONs by ROCS utility (a jar file), then we convert that JSON to CSV which is a time consuming process. Hence I was looking for an utility which can directly provide me CSV.

    Best,

    Kumar Shubham



    ------------------------------
    Kumar Shubham
    ZS Associates
    New Delhi
    ------------------------------