Reltio Connect

 View Only
  • 1.  JSON as input to console data loader

    Founding Member
    Posted 08-24-2021 09:12
    Is there a way we can use JSON (Not Reltio model) as input to Console data loader instead of CSV?

    ------------------------------
    Ashish Rawat
    Fresh Gravity
    Bangalore
    ------------------------------


  • 2.  RE: JSON as input to console data loader

    Reltio Employee
    Posted 08-24-2021 11:08

    Hi Ashish,

    Right now this is not possible. You will have to transform the JSON elsewhere to load



    ------------------------------
    Joel Snipes
    ------------------------------



  • 3.  RE: JSON as input to console data loader

    Reltio Employee
    Posted 08-25-2021 00:17
    hi @Ashish Rawat,

    Yes JSON format is supported in console data loader for more information please check our doc portal link

    https://docs.reltio.com/dataloader/dataloaderoverview.html​

    Thanks,
    Shivaputrappa Patil

    ------------------------------
    Shivaputrappa Patil
    ------------------------------



  • 4.  RE: JSON as input to console data loader

    Founding Member
    Posted 08-25-2021 06:13

    Hi Shivaputrappa,

    I see that docs has a mention of JSON but there is no information on how to use it. Also in console the only option I see is for delimited file.

    Please let me know if I am missing something here or need to enable JSON option ?



    ------------------------------
    Ashish Rawat
    Fresh Gravity
    Bangalore
    ------------------------------



  • 5.  RE: JSON as input to console data loader

    Reltio Employee
    Posted 08-25-2021 07:11
    For JSON files "File delimiter type" is not required(it's not mandatory), you can continue to upload the JSON file
    Once you upload it is the same process as CSV file 


    ------------------------------
    Shivaputrappa Patil
    ------------------------------



  • 6.  RE: JSON as input to console data loader

    Posted 08-25-2021 08:59
    Hi Shivaputrappa,

    Is it safe to say that the File delimiter type is ignored when a JSON file is selected?  The dropdown doesn't allow you to select nothing.



    Thanks!


    ------------------------------
    Pete Cory
    ------------------------------



  • 7.  RE: JSON as input to console data loader

    Founding Member
    Posted 08-25-2021 09:31

    Hi Shivaputrappa,

    Thanks a lot, Interestingly this works even with default file delimited setting (comma). 

     



    ------------------------------
    Ashish Rawat
    Fresh Gravity
    Bangalore
    ------------------------------