How to generate a unique id in snaplogic

[Sowmya_Rayavara]

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!

[vincenr]

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?

[koryknick]

@vincenr - Have you tried the newid() function from SQL Server?

docs.microsoft.com

NEWID (Transact-SQL) - SQL Server

NEWID (Transact-SQL)

[vincenr]

Yes, and just about every version to do the same thing for Oracle, MySQL, PostGres etc… I’m querying against a proprietary system and don’t know what DB they are using.

[koryknick]

Can you add a Mapper after your API call to generate the unique ID? Or does it need to be generated from within the database?

[vincenr]

I don’t know how to do it so it generates a separate unique id for every row. Is there a post that explains how to do this? I’m brand new to SnapLogic. Specifically, I’m referring to from within the mapper snap.