topic Re: UID creation via Workato (automatization of creation UID) in Workato Pros Discussion Board

UID creation via Workato (automatization of creation UID)

Sultanbek — Mon, 05 Feb 2024 20:58:17 GMT

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?

Re: UID creation via Workato (automatization of creation UID)

gary1 — Mon, 05 Feb 2024 21:09:01 GMT

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

Re: UID creation via Workato (automatization of creation UID)

Sultanbek — Tue, 06 Feb 2024 13:19:16 GMT

@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?

Re: UID creation via Workato (automatization of creation UID)

gary1 — Tue, 06 Feb 2024 16:57:10 GMT

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.

https://developers.google.com/sheets/api/samples/rowcolumn#insert-row-column

Re: UID creation via Workato (automatization of creation UID)

Sultanbek — Tue, 06 Feb 2024 18:13:17 GMT

Many thanks! I will try

Re: UID creation via Workato (automatization of creation UID)

Sultanbek — Mon, 12 Feb 2024 15:01:49 GMT

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.

Re: UID creation via Workato (automatization of creation UID)

gary1 — Mon, 12 Feb 2024 17:05:41 GMT

Woah, thanks for sharing! I had no idea this existed.