How to generate a unique id in snaplogic
Hi Team,
Can you please let me know how to generate a unique ld like the below one in snaplogic.
1553020781234-4901709987102371234-03202019DFF456F123
Thanks in Advance!
Forum Discussion
That is because the expression to build the SQL is inserting the random value only once when the SQL statement is generated and parsed for the Select statement that is executed, so SQL Server is treating it like a static string. Try moving it to a Mapper snap after the Execute snap.
Otherwise, you may need to find the syntax for SQL Server to generate a GUUID.
Ok, so I am using a mapper snap to get the path for the json splitter like:
jsonPath($, “$response.entity.feed.entry[*].content.Record”)
So, not to clear about how I would use the function for the columns embedded in each record?
