cancel
Showing results for 
Search instead for 
Did you mean: 

UID creation via Workato (automatization of creation UID)

Sultanbek
Deputy Chef II
Deputy Chef II

We have a use case where we need to import revenue transactions from Intacct to Anaplan via Workato using Unique ID for each transaction. Could you please suggest me how can  Workato create an Unique ID (UID) to each new transaction for import?

 

2 ACCEPTED SOLUTIONS

gary1
Executive Chef III
Executive Chef III

The Sheets API has an endpoint for this. It's not supported by the Workato connector, but you should be able to use the custom action to call the endpoint and make the update.

 

 

View solution in original post

Sultanbek
Deputy Chef II
Deputy Chef II

If someone has the same question regarding creation of UID in workato there is useful formula called "workato.uuid" or you can create your own by using the "encode_base64" formula.

View solution in original post

6 REPLIES 6

gary1
Executive Chef III
Executive Chef III

I don't know of a native way to do it in Workato, but you can use an HTTP action to call this API and generate one for free.

https://www.uuidgenerator.net/

For example, just call https://www.uuidgenerator.net/api/version4/500 and you get 500 freshly generated UUIDs

@gary1 Thank you for your advice! I wonder if we can create an action of adding new columns in google sheet for example? Do you have any insights?

gary1
Executive Chef III
Executive Chef III

The Sheets API has an endpoint for this. It's not supported by the Workato connector, but you should be able to use the custom action to call the endpoint and make the update.

 

 

Many thanks! I will try