Reltio Connect

Using RIH, I am successfully calling the Reltio Bulk Create action to have entity records created in the MDM tenant.  I want to take the action's output and create a cross-reference table with the source system's ID and the newly created Reltio ID (URI).  What is the best way to do this?

Hi Chris, I'm assuming your cross-reference table would sit in an external technology like a warehouse. If that's the case you have a couple options. First, you could also use RIH to establish a recipe with Reltio as the source and the cross-reference table as the destination and this information would be part of the payload when you get records from Reltio. Depending on how you design the recipe you could either have this be an event-driven design and update the cross-reference table as data is changing (reacting to the event queues) or it could be a batch design and use our export action and pull data updated in a previous window. Either way you'd want to ensure you you were getting the full record and not OV only so that the payload has both the OV values and the complete set of crosswalks and the Reltio ID.

Using RIH, I am successfully calling the Reltio Bulk Create action to have entity records created in the MDM tenant.  I want to take the action's output and create a cross-reference table with the source system's ID and the newly created Reltio ID (URI).  What is the best way to do this?

Thanks Michael,  I am struggling with transforming the output JSON from the Reltio Bulk action to normalize it into a collection/list.  I have tried using the using the JSON Parse action but keep getting error "unexpected token" even though the sample document into is the same as the Document input field. Is there another or a correction to how to use the JSON Parse action?

Hi Chris, I'm assuming your cross-reference table would sit in an external technology like a warehouse. If that's the case you have a couple options. First, you could also use RIH to establish a recipe with Reltio as the source and the cross-reference table as the destination and this information would be part of the payload when you get records from Reltio. Depending on how you design the recipe you could either have this be an event-driven design and update the cross-reference table as data is changing (reacting to the event queues) or it could be a batch design and use our export action and pull data updated in a previous window. Either way you'd want to ensure you you were getting the full record and not OV only so that the payload has both the OV values and the complete set of crosswalks and the Reltio ID.

Using RIH, I am successfully calling the Reltio Bulk Create action to have entity records created in the MDM tenant.  I want to take the action's output and create a cross-reference table with the source system's ID and the newly created Reltio ID (URI).  What is the best way to do this?

Hey Chris, can you share a screenshot of your recipe or the recipe itself so that I might take a look?

Thanks Michael,  I am struggling with transforming the output JSON from the Reltio Bulk action to normalize it into a collection/list.  I have tried using the using the JSON Parse action but keep getting error "unexpected token" even though the sample document into is the same as the Document input field. Is there another or a correction to how to use the JSON Parse action?

Hi Chris, I'm assuming your cross-reference table would sit in an external technology like a warehouse. If that's the case you have a couple options. First, you could also use RIH to establish a recipe with Reltio as the source and the cross-reference table as the destination and this information would be part of the payload when you get records from Reltio. Depending on how you design the recipe you could either have this be an event-driven design and update the cross-reference table as data is changing (reacting to the event queues) or it could be a batch design and use our export action and pull data updated in a previous window. Either way you'd want to ensure you you were getting the full record and not OV only so that the payload has both the OV values and the complete set of crosswalks and the Reltio ID.

Using RIH, I am successfully calling the Reltio Bulk Create action to have entity records created in the MDM tenant.  I want to take the action's output and create a cross-reference table with the source system's ID and the newly created Reltio ID (URI).  What is the best way to do this?