Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

How to convert a string UUID to an actual UUID value

jamal
Level 2
Level 2

Hi,

 

I have a field in ACS storing UUID values in string format e.g. "631ab184-55be-eb11-bacc-000d3ade34b3", when I try to use the update data activity and store this value under a field with type UUID it doesn't permit the update. 

 

If so, how do I go about transforming a string UUID into an actual UUID value, there don't appear to be any functions available to do this in ACS?

 

Cheers,

Jamal

3 Replies
SatheeskannaK
Community Advisor
Community Advisor

Hi @jamal,

 

I believe you will not be able to pass UUID values from one field to another field which is of same data type UUID. All you can do is generate new UUID.

 

Also, UUID is another primary key will not support any transformations.

 

Thanks, SK!

jamal
Level 2
Level 2

Hi SatheeskannaK, thanks for the response. In this case I want to transform from text -> uuid. I understand the newUUID function is available for creating a key value, but it doesn't accept any parameters. Could I generate a UUID from a set text parameter e.g. textfield: abc123 -> newUUID(textfield). Or is the only solution here to export the text field value and then import it as a uuid value via csv?

SatheeskannaK
Community Advisor
Community Advisor

Hi @jamal,

 

No you won't be able to manipulate anything with UUID rather all you can do is generate UUID using the function and it will not take any parameters.

 

Thanks!