Generate unique id in Canonical Transform


#1

Is there a function (expression engine function) that generates a unique id string that can be used in the Canonical transform expressions?


#2

If your transform is in Javascript you can try with UUID.createUUID() other use use md5 function e.g.

id:      ~ expression 'md5(concat(field1,field2,...))'

#3

I want to avoid using javascript transform and leverage the existing transform expressions.
md5 function may not ensure unicity if I don’t have a changing fields.


#4

Best practice is to construct the ID from the inbound fields (via concatenation or hashing). If you generate a random ID, then this transform is prone to creating duplicates if the file is ever reprocessed.


#5

If every single field is identical, what is the use case of creating multiple identical records in the system?


#6

Well, in fact, md5 would fit for my use case. I was initially focusing on looking for an equivalent expression engine function to UUID.createUUID() but you are right it is may not be useful in canonical transform use cases.