Reltio Connect

 View Only
  • 1.  JSON Parser : Arrary of JSON into the Reltio Bulk ( create records in Bulk )

    Posted 10-13-2023 06:41

    Hello Team,

    Goal : Get the DnB Enrichment Data and Create Records Bulk in the Reltio

    We have DnB Enrichment Data as JSON files in snowflake, We are trying to parse the JSON using JSON Parser and create Create Records in Bulks using RIH.

    Parsed the JSON files using the JSON parser to create Array of JSON and map those values into Create Records in bulk in the Reltio. I can see the output of the Parsed JSON files into array of JSON. However, mapping to Create Records in bulk is not working.  

    Note: Parsing the one by one JSON file and Create Record ( Single ) is working fine.  We have to achieve the same using bulk.

    1. Selecting JSON Files using the batch

    2. Parsing the JSON Files using the JSON parser into Array of JSON 

    3. When I was trying to create records in bulk using the parsed JSON value.  Getting null / empty values. So, tried to log the records in lookup table using the bulk. Values are not populating in the lookup table. 

     

    Open for Suggestions to achieve the goal. 

    Thanks in advance



    ------------------------------
    Vijayakumar Z
    +91 8608888562
    Bengaluru
    ------------------------------


  • 2.  RE: JSON Parser : Arrary of JSON into the Reltio Bulk ( create records in Bulk )

    Posted 10-16-2023 10:50

    Hi Vijayakumar ,

    Do for each in batch it will work 

    regards,

    Nitin Tugave



    ------------------------------
    Nitin Tugave
    eaton
    ------------------------------



  • 3.  RE: JSON Parser : Arrary of JSON into the Reltio Bulk ( create records in Bulk )

    Reltio Employee
    Posted 10-16-2023 16:43

    Hello Vijayakumar,

    You do not need to add the JSON parser as the Reltio Connector will create the json structure for you. To map the "Create records in bulk" action, you need to to specify the source list and equate it to the batch of records that you want to load per action.  Then you need to map the Snowflake columns to the Reltio attributes.



    ------------------------------
    Bryant Barrenechea
    Solution Architect | Professional Services
    ------------------------------