Reltio Integration Hub

Hello Team,

do we have any RIH or workato Recipe which does reltio events FIFO or ordering 

we have a requirement to do events ordering 

regards,

Nitin Tugave

Hi Nitin,

Sounds like you want to sort messages coming off of a message queue in a particular order.  I did a poc for this and can share some screen shots and notes about what I did.

Instead of iterating over the sqs messages I put them in a list and used a sql collection object to order the list based on criteria including special ordering information stored in a lookup table.

Take the sqs messages (1), put it into the messageList list (2) object, then turn it into a sql collection (3) list so that we can query it in the next step (4) using an order by clause.  then you can iterate over the list produced from the query (5) and pass the json (stored in the list) for further processing.  

I used a lookup table to help establish how I wanted specific entities to be ordered.

EventTypeSorting LookupTable example:

Hello Team,

do we have any RIH or workato Recipe which does reltio events FIFO or ordering 

we have a requirement to do events ordering 

regards,

Nitin Tugave