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.
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
Hi Vijayakumar ,
Do for each in batch it will work
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.
100 Marine Pkwy #275, Redwood City, CA 94065
+1 (855) 360-DATA+1 (855) 360-3282
© 2022 Reltio. All Rights Reserved
Site by eConverse MediaAlso of Interest: Master Data Management (MDM) Reltio Community Reltio Integration Hub Community, Data Management Community Matching, Merge, Survivorship Reltio Workflow Master Data Management (MDM)